Database Objects Window Features

From the Database Objects window, you can:

  • Click an object type in the tree to see more information about it.
  • For Oracle, search for a specific database item.
  • Click the down arrow next to the database name at the top of the page to choose to view the database objects of a different database by either selecting the database from the list or by searching for the database by entering text in the search bar and then clicking the refresh icon to show only databases that meet that search criteria.

The following are some examples of browsable content.

  • Database uptime and version for all platforms
  • Users: who has access to the database for all platforms (supported only for Oracle, MySQL, PostgreSQL, and SAP HANA)
  • Settings: current configured settings (supported only for PostgreSQL and SAP HANA)
  • Job Status: status of SQL agent job (supported only for SQL Server)
  • Parameters: database initialization parameters (supported only for Oracle)
  • Variables: system variables indicating how the database was configured.
  • Current Statistics: the current value of statistics collected. The various statistics available are database dependent and are a superset of those shown on the Database Monitoring - Metric Browser page.
  • Storage: displays information about the storage of tables. (supported only for PostgreSQL and SAP HANA)
  • System Waits: SQL waits experienced by the database.
  • Objects Stats: displays the schema information. (supported only for PostgreSQL and SAP HANA)
  • Database Objects: search for specific objects, and browse through database schemas, tables, columns, and indices.