|
Oracle® HTML DB
Release 2.0 |
|
 Previous |
 Next |
The Database Monitor page features a variety reports that describe the activity, storage, and configuration of the current database instance.
|
Note: Only users having a database user account that has been granted a DBA role can access the Database Monitor page. |
Topics:
The reports available under Activity detailed provide a database-wide view of the database sessions, system statistics, SQL statements, and longer operations. You can use these reports to identify poorly preforming SQL and to gain a better understand the workload of the database.
To access database activity reports:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities and then Database Monitor.
Accessing the Database Monitor page requires database administrator privileges. You must have a database account that has been granted a DBA role.
When prompted, enter the appropriate username and password and click Login.
Under Activity, select the appropriate report.
The following sections describe each report page.
A session is the connection of a user to an Oracle database instance. A session lasts from the time the user connects until the time the user disconnects or exits the database application.
The Sessions page contains six reports as described Table 21-1. To view a report, select the appropriate tab.
Table 21-1 Database Monitor Activity Reports
| Report Name | Description |
|---|---|
|
Displays a report of the current session on the database. |
|
|
Displays a report of session which has locks blocking another session(s). |
|
|
Displays a report of the wait events for each session. |
|
|
Displays a report of the I/O for each session. |
|
|
Displays a report showing the current or last SQL statement executed for each session. |
|
|
Displays a report of the number of open cursors for each session. |
The System Statistics report displays statistics for:
Physical I/O. A physical I/O is an I/O that requires disk access. This report displays disk access statistics for physical reads and writes.
Logical I/O. An logical I/O is an I/O that is satisfied in memory or disk. Displays the sum of buffer reads which might be consistent gets or current mode gets. Redo is the buffer in the SGA that contains information about changes.
Memory. Displays memory consumption of the database.
Time. Shows various times consumed by the database
SQL Cursor. Displays statistics about the cursors in the Oracle database. See
Transaction. Shows the number of transactions performed.
Additional controls on the System Statistics page include:
Refresh Report - Click this button to refresh the System Statistics report.
Save Statistics - Click this button to save the current report.
Removed Saved Statistics - Click this link to create a baseline which is used on subsequent refreshes of the page. The statistics will then show deltas from what was saved and what is current.
|
See Also: "Memory and Configuration Use" in Oracle Database Performance Tuning Guide and "Cursor Access and Management" in Oracle Database Performance Tuning Guide |
Use the Top SQL page to identify poorly performing SQL. Use the search fields and lists and the top of the page to narrow the display.
Click the View icon to access the SQL Plan page. The SQL Plan page contains the following sections:
Query Plan - Contains a color coded explain plan. Note that unindexed columns display in red.
SQL Text - Displays the full text of the SQL statement.
Indexes - Displays all indexes on the table in the query. There is a checkmark when that index is used in the query.
Table Columns - Shows all columns on all tables or views in the query.
This view displays the status of various operations that run for longer than 6 seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution, and more operations are added for every Oracle release.
|
See Also: V$SESSION_LONGOPS" in Oracle Database Reference |
Oracle stores data logically in tablespaces and physically in datafiles associated with the corresponding tablespace. The reports available under Storage provide information about tablespaces, data files, and free space.
To access database storage reports:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities and then Database Monitor.
Accessing the Database Monitor page requires database administrator privileges. You must have a database account that has been granted a DBA role.
When prompted, enter the appropriate username and password and click Login.
Under Storage, select the appropriate icon:
Tablespaces -Displays the size of each tablespace in MB as well as the number of related data files.
Data Files - Displays information about each data file, including the related table space, related file name, size in MB, and auto extensible status.
Free Space - Displays free space in the database by tablespaces.
|
See Also: Oracle Database Reference for information about tablespaces and data files |
The reports in the Configuration section of the Database Monitor provide details about how the database is configured. This information is useful in understanding your database version and configuration options.
To access database storage reports:
Click the SQL Workshop icon on the Workspace home page.
Click Utilities and then Database Monitor.
Accessing the Database Monitor page requires database administrator privileges. You must have a database account that has been granted a DBA role.
When prompted, enter the appropriate username and password and click Login.
Under Configuration, select the appropriate icon:
Click Database to view details about the current database instance. The About Database page is divided into two sections: Database and Version. To view additional information about installed options, currently used features, or National Language Support, expand the following:
Options
Feature Usage
National Language Support
CGI Environment
Click Parameters to view configuration parameters for the current database instance.