Data for the Main Screen of the Database Monitor

Main screen of the Database Monitor Database Performance Analysis: SAP/Oracle Database Monitor: Main Screen.

The statistics on the main screen are determined from the relevant Oracle V$ tables when you call the Monitor. An Oracle statistics "snapshot" recording current database activity is therefore provided. These details are constantly updated by the Oracle database system, beginning from the last system startup.

Choose Refresh to update the details (the relevant V$ tables will be read again).

Detail analysis menu

A series of more detailed analysis options is available via Detail analysis menu ( Detail Analysis Menu (Oracle)). The DB collector is started for some of these analyses.

Table: Analyses without the DB collector

Pushbutton
Buffer busy waits, Filesystem requests, Wait events, SAP client, Oracle session, SQL request, Exclusive lockwaits, Latch waits	Statistical data determined directly from the dynamic performance tables (Oracle V$ tables).
Database message log	Displays the ALERT file (central Oracle log file).
Display V$ Tables	Displays the list of Oracle V$ tables.

Table: Analyses using the DB collector

Pushbutton
Performance database	Displays the performance statistics of the database. Snapshot data is provided, which is collected regularly in table DBSNP using report RSDBPREV.
State on disk	Displays the screen Database Performance: Tables and Indexes. The details on this screen are basically provided by report RSORATDB. See also: Data for the Screen: Database Performance: Tables and Indexes.
Parameter changes	Displays the init.ora parameters and their changes. These details are provided by report RSORAPAR, which stores the old and new parameters in table PAHI.
Summary report	Displays up-to-date overall statistics (settings, database parameters, data status). These statistics are provided by reports RSORATDB, RSORAPAR, and RSORA811 of the DB collector.