Show TOC

Performance OverviewLocate this document in the navigation structure

Definition

This is the main screen in the SAP/Oracle Database Monitor. It gives you an overview of the performance of your Oracle database.

Use

You start the database monitor from the DBA Cockpit by choosing Start of the navigation path Performance Next navigation step Performance Overview End of the navigation path. 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.

Note

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.

Structure

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

    • Non-RAC or RAC detail: data buffer size of the current instance

    • RAC total: total instance-related database buffers

      Data source: V$SGA

    - 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

    • Non-RAC or RAC detail: shared pool size of the current instance

    • RAC total: total shared pool size for all instances

      Data source: V$SGA_DYNAMIC_COMPONENTS

    Logical reads

    Number of logical read operations

    • Non-RAC or RAC detail: logical reads of the current instance

    • RAC total: total logical read operations for all instances

      Data source: V$SYSSTAT

    Physical reads

    Number of physical read operations

    • Non-RAC or RAC detail: physical reads of the current instance

    • RAC total: total physical read for all instances

      Data source: V$SYSSTAT

    Physical writes

    Number of physical write operations

    • Non-RAC or RAC detail: physical writes of the current instance

    • RAC total: total physical write operations for all instances

      Data source: V$SYSSTAT

    Read by other sess

    Number of buffer busy wait situations

    • Non-RAC or RAC detail: total waitstat counters of the current instance

    • RAC total: total waitstat counters for all instances

      Data source: GV$SYSTEM_EVENT

    Read by other sess time

    Sum of buffer busy wait times

    • Non-RAC or RAC detail: sum of wait times for all wait counters of the current instance

    • RAC total: sum of wait times for all wait counters for all instances

      Data source: V$WAITSTAT

  • 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)

    • Non-RAC or RAC detail: data buffer quality of the current instance

    • RAC total: average cache quality for all instances

      Data source: V$ROWCACHE

    SQL area getratio

    Ratio of gethits to gets as a percentage, calculated as follows:

    sum ( gethits) / sum ( gets) x 100

    • Non-RAC or RAC detail: get ratio of the current instance

    • RAC total: average of all instance-related get ratios

      Data source: V$LIBRARYCACHE

    SQL area pinratio

    Ratio of pinhits to pin s as a percentage, calculated as follows:

    sum ( pin hits) / sum ( pins) x 100

    • Non-RAC or RAC detail: pin ratio of the current instance

    • RAC total: average of all instance-related pin ratios

      Data source: V$LIBRARYCACHE

    SQLA Reloads/pins

    Ratio of reloads to pin s as a percentage, calculated as follows:

    sum ( reload s) / sum ( pins) x 100

    • Non-RAC or RAC detail: reloads per pin ratio of the current instance

    • RAC total: average of all instance-related pin ratios

      Data source: V$LIBRARYCACHE

  • Log buffer

    Field

    Description

    Size

    Size of the redo log buffer

    • Non-RAC or RAC detail: redo log buffer size of the current instance

    • RAC total: total instance-related redo log buffer sizes

      Data source: V$SGA

    Entries

    Number of redo log buffer entries

    • Non-RAC or RAC detail: redo log buffer entries of the current instance

    • RAC total: sum of all instance-related redo log buffer entries

      Data source: V$SYSSTAT

    Allocation retries

    Number of redo buffer allocation retries

    • Non-RAC or RAC detail: allocation retries of the current instance

    • RAC total: total instance-related log buffer allocation retries

      Data source: V$SYSSTAT

    Redo log space wait

    Redo log wait in seconds

    • Non-RAC or RAC detail: Redo log wait time of the current instance

    • RAC total: sum of instance-related redo log wait times

      Data source: V$SYSSTAT

    Redo log groups

    Number of redo log groups

    Log files [in use]

    Number of active log files

    • Non-RAC or RAC detail: active log files for the current instance

    • RAC total: total active log files

      The figure in brackets refers to the number of active log files in use.

      Data source: V$LOGFILE

  • Time Statistics

    Field

    Description

    Busy wait time

    Busy wait time, calculated as the sum of the time waited for all non-idle events.

    • Non-RAC or RAC detail: busy wait time for the current instance

    • RAC total: total instance-related busy wait times

      Data source: V$SESSION_EVENT

    CPU time session

    CPU time session, calculated as sum of CPU time used by this session

    • Non-RAC or RAC detail: total CPU time for the current instance

    • RAC total: total CPU time for all instances

      Data source: V$SYSSTAT

    Time/User call

    Time for each user call, calculated as follows:

    (busy wait time + CPU time) / user calls

    • Non-RAC or RAC detail: time for the current instance

    • RAC total: average time for all instances

      Data source: V$SESSION_EVENT and V$SYSSTAT

    Sessions busy

    Busy sessions as a percentage, calculated as follows:

    (busy wait time + CPU time) / total wait time

    • Non-RAC or RAC detail: percentage for the current instance

    • RAC total: average percentage for all instances

      Data source: V$SESSION_EVENT and V$SYSSTAT

    CPU usage

    CPU usage as a percentage, calculated as follows:

    CPU time / (elapsed time x CPU count)

    • Non-RAC or RAC detail: percentage for the current instance

    • RAC total: average percentage for all instances

      Data source: V$SYSSTAT, V$INSTANCE, and V$PARAMETER

    Number of CPUs

    Number of CPUs

    • Non-RAC or RAC detail: CPUs for the current instance

    • RAC total: total CPUs for all instances

      Data source: V$PARAMETER

  • Calls

    Field

    Description

    User calls

    Number of user calls

    • Non-RAC or RAC detail: user calls for the current instance

    • RAC total: total user calls for all instances

      Data source: V$SYSSTAT

    User commits

    Number of user commits

    • Non-RAC or RAC detail: user commits for the current instance

    • RAC total: total user commits for all instances

      Data source: V$SYSSTAT

    User rollbacks

    Number of user rollbacks

    • Non-RAC or RAC detail: user rollbacks for the current instance

    • RAC total: total user rollbacks for all instances

      Data source: V$SYSSTAT

    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

    • Non-RAC or RAC detail: redo log writes for the current instance

    • RAC total: total redo log writes for all instances

      Data source: V$SYSSTAT

    OS blocks written

    Number of operating system redo blocks written

    • Non-RAC or RAC detail: redo blocks written for the current instance

    • RAC total: sum of written redo blocks for all instances

      Data source: V$SYSSTAT

    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

    • Non-RAC or RAC detail: redo write time for the current instance

    • RAC total: total redo write time for all instances

      Data source: V$SYSSTAT

    Volume written

    Volume amount written

    • Non-RAC or RAC detail: redo log data written for the current instance

    • RAC total: total redo log data written for all instances

      Data source: V$SYSSTAT

  • Table scans and fetches

    Field

    Description

    Short table scans

    Number of short table scans

    • Non-RAC or RAC detail: short table scans for the current instance

    • RAC total: total short table scans for all instances

      Data source: V$SYSSTAT

    Long table scans

    Number of long table scans

    • Non-RAC or RAC detail: long table scans for the current instance

    • RAC total: total long table scans for all instances

      Data source: V$SYSSTAT

    Table fetch by rowid

    Number of table fetches by row ID

    • Non-RAC or RAC detail: table fetches by row ID for the current instance

    • RAC total: total table fetches by row ID for all instances

      Data source: V$SYSSTAT

    Fetch by contin. row

    Number of fetches by continued row

    • Non-RAC or RAC detail: table fetches by continued row for the current instance

    • RAC total: total table fetches by continued row for all instances

      Data source: V$SYSSTAT

  • Sorts

    Field

    Description

    Sorts (memory)

    Number of sorts in memory

    • Non-RAC or RAC detail: sorts in memory for the current instance

    • RAC total: total sorts in memory for all instances

      Data source: V$SYSSTAT

    Sorts (disk)

    Number of sorts in disk

    • Non-RAC or RAC detail: sorts on disk for the current instance

    • RAC total: total sorts on disk for all instances

      Data source: V$SYSSTAT

    Sorts (rows)

    Number of sorted rows

    • Non-RAC or RAC detail: sorted rows in memory for the current instance

    • RAC total: total rows for all instances

      Data source: V$SYSSTAT

    WA exec. optimal mode

    Number of work area executions in optimal mode

    • Non-RAC or RAC detail: work area executions in optimal mode for the current instance

    • RAC total: total work area executions in optimal mode for all instances

      Data source: V$SYSSTAT

    WA exec. one pass mode

    Number of work area executions in one-pass mode

    • Non-RAC or RAC detail: work area executions in one-pass mode for the current instance

    • RAC total: total work area executions in one-pass mode for all instances

      Data source: V$SYSSTAT

    WA exec. multipass mode

    Number of work area executions below the one-pass memory requirement

    • Non-RAC or RAC detail: work area executions in multipass mode for the current instance

    • RAC total: total work area executions in multipass mode for all instances

      Data source: V$SYSSTAT

  • Top System Events

    This shows the system events in descending order of Wait Time.