1. WebCenter Sites Help
  2. Viewing Database Information

49 Viewing Database Information

back to WebCenter Sites Help

You can download or view the following types of database information:

  • Basic Information – The database engine and version, default transaction isolation level, JDBC driver, URL, and version, and JNDI data source.

  • System Tables – Tables that store core WebCenter Sites data. The ElementCatalog table, for example, lists all of the XML or JSP elements used in your system.

  • Tree Tables – Tables that store parent-child relationships between objects. The AssetRelationTree, for example, stores information about the associations between assets.

  • Sites Object Tables – Tables that store uniquely identified objects, such as asset types, asset attributes, and asset definitions.

  • Other Sites Tables – Tables that store flat data that cannot be organized into parent-child relationships and the foreign tables that WebCenter Sites does not manage.

    Note:

    You have permission to access a database table if at least one Access Control List (ACL) assigned to the table is assigned to your user. For more information about database permissions, see Access Control Lists (ACLs) in Administering Oracle WebCenter Sites.

To download or view database information:

  1. In the General Admin tree, expand the Admin node, expand the System Tools node, expand the System Information, and then double-click DB Info.

    The Database Information form is displayed with basic information about your database and the tables that you can select to download or view.

  2. In the System Tables, Tree Tables, Sites Object Tables, and Other Sites Tables sections, select the tables to view and click Add.

  3. To download the selected database information as a spreadsheet file, click Download and then open or save SysInfo.zip. The spreadsheet file is inside SysInfo.zip.

  4. To view the selected database information in the administrator's interface, click Show Results.

    1. For each selected table that you have permission to access, the following information opens:

      • Table Name

      • Primary key

      • Number of rows

      • CSz (number of resultsets to cache in memory)

      • Timeout (number of minutes to keep a resultset cached in memory)

      • Abs (how to calculate the expiration time for resultsets)

      • Time to run SQL

      • Special table key

    2. To view a table's column and indices, click its "plus" icon. If an index is listed more than one time, it extends across multiple rows, as illustrated in Tree Tables Information.