When you detect a problem with database performance, you may be able to correct the problem by adding an index, refusing access to certain users, or creating a new index on a table. You can browse through the database objects to find ways to tune the database, including the indexes that are currently available on the various tables. The contents of the Database Object Browser are updated when you access them or click Refresh.
The objects available for browsing are database dependent. For clustered databases, select the node to browse its objects.
Access the Database Objects Window
To access the Database Objects window:
To view a database's objects, click the name of the database.
Click the Objects tab.
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.
