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.
|
