
This is the main screen in the SAP/Oracle Database Monitor. It gives you an overview of the performance of your Oracle database.
You start the database monitor from the DBA Cockpit by choosing . You see an overview of database performance.
You can right-click a field and choose Details to see the values for each instance if you are running an Oracle Real Application Cluster (RAC).
If you are running RAC, you choose in DB Instances whether to display overview information for one RAC instance or for the total of all RAC instances.
The appearance of a yellow or red light indicates that the difference in percent for the value of at least one instance from the average of all instances exceeds a certain limit.
The fields are grouped as follows:
General information, data source is V$INSTANCE
|
Field |
Description |
|---|---|
|
DB instance |
Name of the current database instance This is the SAP-SID in non-RAC environments. |
|
DB node |
Host name of the selected DB node This is the database server in non-RAC environments. |
|
DB release |
Release of the current database |
|
Day, time |
Current day and time |
|
Start up at |
Date and time when the current database instance started |
|
Time since start |
Time since start of the current database instance, in days-hours-minutes-seconds |
|
DB Time |
<Busy wait time> + <CPU time session> |
Sizes
|
Field |
Description |
|---|---|
|
Database Buffer Size |
Size of the data buffer
|
|
- Size default pool |
Size of the default buffer pool, calculated as follows: select value from v$parameter where name = 'db_cache_size' Data source: gv$sga_dynamic_components |
|
- Size keep pool |
Size of the keep buffer pool, calculated as follows: select value from v$parameter where name = 'db_keep_cache_size' Data source: gv$sga_dynamic_components |
|
- Size others |
Sum of the sizes of all other buffer caches pools, calculated as follows: select inst_id, round(sum(CURRENT_SIZE)/1024,0) othersize from gv$sga_dynamic_components where component = 'DEFAULT 2K buffer cache' or component = 'EFAULT 4K buffer cache' or component = 'DEFAULT 8K buffer cache' or component = 'DEFAULT 16K buffer cache' or component = 'DEFAULT 32K buffer cache' or component = 'RECYCLE buffer cache' group by inst_id Can be displayed in detail as a pop-up Data source: gv$sga_dynamic_components |
|
In-Memory-Size |
Size available to in-memory data, configurable as of Oracle 12. |
|
Shared pool size |
Size of the shared pool
|
|
Logical reads |
Number of logical read operations
|
|
Physical reads |
Number of physical read operations
|
|
Physical writes |
Number of physical write operations
|
|
Read by other sess |
Number of buffer busy wait situations
|
|
Read by other sess time |
Sum of buffer busy wait times
|
Quality
|
Field |
Description |
|---|---|
|
Data Buffer Quality |
Data buffer quality, calculated as follows: 100% - (( physicalreads - physicalreads_direct - physicalreads_directlob) / ( sess_logicalreads - physicalreads_direct - physicalreads_directlob)) Non-RAC or RAC detail: data buffer quality of the current instance RAC total: average of quality for all instance-related data buffer Data source: V$SYSSTAT |
|
DD-cache Quality |
Data dictionary cache quality as percentage, calculated as follows: 100% - ( totalget_misses / totalgets)
|
|
SQL area getratio |
Ratio of gethits to gets as a percentage, calculated as follows: sum ( gethits) / sum ( gets) x 100
|
|
SQL area pinratio |
Ratio of pinhits to pin s as a percentage, calculated as follows: sum ( pin hits) / sum ( pins) x 100
|
|
SQLA Reloads/pins |
Ratio of reloads to pin s as a percentage, calculated as follows: sum ( reload s) / sum ( pins) x 100
|
Log buffer
|
Field |
Description |
|---|---|
|
Size |
Size of the redo log buffer
|
|
Entries |
Number of redo log buffer entries
|
|
Allocation retries |
Number of redo buffer allocation retries
|
|
Redo log space wait |
Redo log wait in seconds
|
|
Redo log groups |
Number of redo log groups |
|
Log files [in use] |
Number of active log files
|
Time Statistics
|
Field |
Description |
|---|---|
|
Busy wait time |
Busy wait time, calculated as the sum of the time waited for all non-idle events.
|
|
CPU time session |
CPU time session, calculated as sum of CPU time used by this session
|
|
Time/User call |
Time for each user call, calculated as follows: (busy wait time + CPU time) / user calls
|
|
Sessions busy |
Busy sessions as a percentage, calculated as follows: (busy wait time + CPU time) / total wait time
|
|
CPU usage |
CPU usage as a percentage, calculated as follows: CPU time / (elapsed time x CPU count)
|
|
Number of CPUs |
Number of CPUs
|
Calls
|
Field |
Description |
|---|---|
|
User calls |
Number of user calls
|
|
User commits |
Number of user commits
|
|
User rollbacks |
Number of user rollbacks
|
|
Recursive calls |
Internal SQL statement or SQL statement in PL/SQL statement |
|
Parse count |
Total number of parse calls (hard and soft) |
|
User/recursive calls |
Ratio of user to recursive calls |
|
Log Reads/User calls |
Number of logical reads per user call. |
Redo Logging
|
Field |
Description |
|---|---|
|
Redo writes |
Number of redo log writes
|
|
OS blocks written |
Number of operating system redo blocks written
|
|
Latching time |
Redo writer latching time in seconds Non-RAC or RAC detail: redo writer latching time for the current instance RAC total: total latching time for all instances Data source: V$SYSSTAT |
|
Redo write time |
Redo write time in seconds
|
|
Volume written |
Volume amount written
|
Table scans and fetches
|
Field |
Description |
|---|---|
|
Short table scans |
Number of short table scans
|
|
Long table scans |
Number of long table scans
|
|
Table fetch by rowid |
Number of table fetches by row ID
|
|
Fetch by contin. row |
Number of fetches by continued row
|
Sorts
|
Field |
Description |
|---|---|
|
Sorts (memory) |
Number of sorts in memory
|
|
Sorts (disk) |
Number of sorts in disk
|
|
Sorts (rows) |
Number of sorted rows
|
|
WA exec. optimal mode |
Number of work area executions in optimal mode
|
|
WA exec. one pass mode |
Number of work area executions in one-pass mode
|
|
WA exec. multipass mode |
Number of work area executions below the one-pass memory requirement
|
Top System Events
This shows the system events in descending order of Wait Time.