TOCPREVNEXTINDEX

Lund Performance Solutions


SOS Oracle Detail Database Activity

The Oracle Detail Database Activity Screen

The Oracle Detail Database screen provides important statistics related to Oracle database activities.
To open the Oracle Detail Database screen from any SOS display screen:
  • Type s from the SOS Enter command: prompt to view the Screen Selection Menu.
  • From the Screen Selection Menu, enter A (upper case). An example of the screen is shown in Figure 36.1.




  • Figure 36.1 SOS Oracle Detail Database Activity screen

    Oracle Detail Database Activity Display Items

    Transaction Management

    The Transaction Management portion of the Oracle Detail Database screen shows the amount of database activity.
    Table 36.1 SOS Oracle Detail Database Activity data items: Transaction Management
    Data Item
    Description
    Opened cursors
    The number of opened cursors.
    User commits
    The number of user commits.
    User rollbacks
    The number of user rollbacks.

    Locking

    The Locking section of the screen shows statistics related to locking activity. Locking is managed in Oracle using an enqueue mechanism.
    Table 36.2 SOS Oracle Detail Database Activity data items: Locking
    Data Item
    Description
    Current Locks
    The number of locks currently held.
    Enq Requests
    The number of enqueue requests.
    Enq Releases
    The number of enqueue releases.
    Enq Waits
    The number of waits for enqueue time-outs.
    Enqueue Time-outs
    The number of enqueue time-outs.
    Performance Tip
    The number of locks performed and still held can be calculated as: (enq requests - enq releases - enq time-outs).

    Sorts

    The Sorts section of the Oracle Detail Database screen shows statistics related to sorts.
    Table 36.3 SOS Oracle Detail Database Activity data items: Sorts
    Data Item
    Description
    Memory
    The number of sorts done in memory.
    Disk
    The number of sorts performed on disk.
    Rows
    The number of rows sorted.
    Performance Tip
    Most sorting should happen in memory, not on disk. Sorting on disk is a very slow operation and should be avoided.

    Table Scans

    The Table Scans section shows statistics related to sequential table access; accesses made directly, not through an index.
    Table 36.4 SOS Oracle Detail Database Activity data items: Table Scans
    Data Item
    Description
    Short tables
    The number of short tables scanned.
    Long tables
    The number of long tables scanned.
    Performance Tip
    Long table scans should be avoided unless they return most of the scanned rows.

    Rollback

    The Rollback section provides statistics about database changes.
    Table 36.5 SOS Oracle Detail Database Activity data items: Rollback
    Data Item
    Description
    Gets
    The number of gets.
    Waits
    The number of waits.
    Writes
    The number of writes.

    Lund Performance Solutions
    www.lund.com
    Voice: (541) 812-7600
    Fax: (541) 81207611
    info@lund.com
    TOCPREVNEXTINDEX