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 for Oracle, MySQL)
- Job Status: status of SQL agent job (supported for SQL Server)
- Parameters: database initialization parameters (supported 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 in the Database Monitoring - Metric Browser page.
- System Waits: SQL waits experienced by the database
- Database Objects: search for specific objects, and browse through database schemas, tables, columns, and indices.