System Stat Summary (PD)

Function

The System Stat Summary (PD) record stores performance data, taken at a specific point in time, indicating cumulative values from the start of the instance.

Default and changeable values

ItemDefault valueChangeable
Collection Interval300Y
Collection Offset0Y
LogNoY
LOGIF(Blank)Y

ODBC key fields

None

Lifetime

From the creation to the deletion of an Oracle instance

Record size

Fields

PFM - View name
(PFM - Manager name)
DescriptionSummaryFormatDeltaSupported versionData source
Block Changes/Tran
(BLOCK_CHANGES_PER_TRANSACTION)
Rate at which each transaction executed DML operation--doubleNoAlldb block changes / user commits
Block Visits/Tran
(BLOCK_VISITS_PER_TRANSACTION)
Number of times a work database was loaded per transaction--doubleNoAll(db block gets + consistent gets) / user commits
Buffer Busy Wait %
(BUFFER_BUSY_WAIT_PERCENTAGE)
Percentage ratio of buffer busy waits--doubleNoAll(V$SYSTEM_EVENT.TOTAL_WAITS where EVENT = 'buffer busy waits' / (consistent gets + db block gets)) * 100
Cache Hit %
(CACHE_HIT_PERCENTAGE)
Buffer cache usage--doubleNoAll(1 - (physical reads cache / (consistent gets from cache + db block gets from cache))) * 100
Calls/Tran
(CALLS_PER_TRANSACTION)
Rate at which client requests were executed per transaction--doubleNoAlluser calls / user commits
Changed Block %
(CHANGED_BLOCK_PERCENTAGE)
Percentage ratio of difference between query and database manipulation language (DML) in the database application. This value changes according to indexes and application utilization status.--doubleNoAll(db block changes / (block gets + consistent gets)) * 100
Consistent Change %
(CONSISTENT_CHANGE_PERCENTAGE)
Percentage ratio of extents used for consistency of application read operations--doubleNoAll(consistent changes / consistent gets) * 100
Continued Row %
(CONTINUED_ROW_PERCENTAGE)
Percentage ratio of continued rows. The value is close to 0 unless the application handles LONG columns.--doubleNoAll(table fetch continued row / (table fetch by rowid + table scan rows gotten)) * 100
Current Logons
(CURRENT_LOGONS)
Number of current login to Oracle Database--longNoAllV$SYSSTAT.VALUE
Deadlocks
(LOCK_DEADLOCKS)
Number of deadlocks caused by locked DML processing--doubleNoAllV$SYSSTAT.VALUE
Dict Cache Get Misses %
(DICTIONARY_CACHE_GET_MISSES_PERCENTAGE)
Percentage ratio of data requests issued due to cache miss--doubleNoAll(SUM(V$ROWCACHE.GETMISSES) / SUM(V$ROWCACHE.GETS)) * 100
Disk Sorts
(SORTS_DISK)
Number of disk sort operations--doubleNoAllV$SYSSTAT.VALUE
Free List Wait Events
(FREE_LIST_WAIT_EVENTS)
Number of wait events in the free list--doubleNoAllV$WAITSTAT.COUNT where class = 'free list'
Lib Cache Miss %
(LIBRARY_CACHE_MISS_PERCENTAGE)
Library cache miss rate. This field means the ratio of times the allocated objects in library cache are reloaded. As the value of this field increases, the amount of resources in use also increases.--doubleNoAll(SUM(V$LIBRARYCACHE.RELOADS) / SUM(V$LIBRARYCACHE.PINS)) * 100
Lock Conversions
(LOCK_CONVERSIONS)
Number of enqueues (locks) whose mode was changed (such as from share to lock)--doubleNoAllV$SYSSTAT.VALUE
Lock Releases
(LOCK_RELEASES)
Number of times enqueuing (locking) was released--doubleNoAllV$SYSSTAT.VALUE
Lock Requests
(LOCK_REQUESTS)
Number of times enqueuing (locking) was requested--doubleNoAllV$SYSSTAT.VALUE
Lock Timeouts
(LOCK_TIMEOUTS)
Number of times an enqueuing (locking) request was not permitted within the allocated time--doubleNoAllV$SYSSTAT.VALUE
Lock Waits
(LOCK_WAITS)
Number of times an enqueuing (locking) request was placed in wait status. The difference between the enqueuing requests count and the enqueuing waits count is the number of times the request was not treated as an enqueuing request.--doubleNoAllV$SYSSTAT.VALUE
Logical Reads
(LOGICAL_READS)
Number of logical read operations in read consistency mode and number of requests to the current copy of blocks--doubleNoAlldb block gets + consistent gets
Memory Sorts
(SORTS_MEMORY)
Number of sort operations in memory--doubleNoAllV$SYSSTAT.VALUE
Non-Index Lookups %
(NON_INDEX_LOOKUPS)
Percentage ratio of full table scans that do not involve caching--doubleNoAll(table scans (long tables) / (table scans (short tables) + table scans (long tables))) * 100
Physical Reads
(PHYSICAL_READS)
Number of physical read operations on database block from disk--doubleNoAllV$SYSSTAT.VALUE
Physical Writes
(PHYSICAL_WRITES)
Number of physical write operations on the disk by DBWR--doubleNoAllV$SYSSTAT.VALUE
Record Time
(RECORD_TIME)
Collection termination time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Record Type
(INPUT_RECORD_TYPE)
Record name (always PD)--string(4)NoAllRemote Monitor Collector
Recursive Calls
(RECURSIVE_CALLS)
Number of user calls processed--doubleNoAllV$SYSSTAT.VALUE
Recursive To User Call %
(RECURSIVE_TO_USER_CALL_PERCENTAGE)
Correct values cannot be collected in this field.
Percentage indicating overhead
--doubleNoAll(recursive calls / user calls) * 100
Redo Alloc Immediate %
(REDO_ALLOC_IMMEDIATE_HIT_PERCENTAGE)
Success rate of immediately acquiring REDO allocation latch--doubleNoAll(1 - (V$LATCH.IMMEDIATE_MISSES / (V$LATCH.IMMEDIATE_GETS + V$LATCH.IMMEDIATE_MISSES))) * 100 where V$LATCH.NAME = 'redo allocation'
Redo Alloc Willing to Wait %
(REDO_ALLOC_WILLING_TO_WAIT_HIT_PERCENTAGE)
Success rate of acquiring REDO allocation latch from cache--doubleNoAll(1 - (V$LATCH.MISSES / V$LATCH.GETS)) * 100 where name = 'redo allocation'
Redo Copy Immediate %
(REDO_COPY_IMMEDIATE_HIT_PERCENTAGE)
Success rate of immediately acquiring REDO copy latch--doubleNoAll(1 - (V$LATCH.IMMEDIATE_MISSES / (V$LATCH.MMEDIATE_GETS + V$LATCH.IMMEDIATE_MISSES))) * 100 where name = 'redo copy'
Redo Copy Willing to Wait %
(REDO_COPY_WILLING_TO_WAIT_HIT_PERCENTAGE)
Success rate of acquiring REDO copy latch from cache--doubleNoAll(1 - (V$LATCH.MISSES / V$LATCH.GETS)) * 100 where name = 'redo copy'
Redo Log Space Requests
(REDO_LOG_SPACE_REQUESTS)
Number of times Oracle must wait for disk spaces to be allocated to REDO log entry because the active log file is full.--doubleNoAllV$SYSSTAT.VALUE
Redo Log Space Wait %
(REDO_LOG_SPACE_WAIT_PERCENTAGE)
Whether or not memory allocation is appropriate--doubleNoAll(redo log space requests / redo entries) * 100
Row Source %
(ROW_SOURCE_PERCENTAGE)
Percentage ratio of rows obtained by full-table scan--doubleNoAll(table scan rows gotten / (table fetch by rowid + table scan rows gotten)) * 100
SQL Executing
(SQL_EXECUTING)
This field is not supported.
Number of current SQL executions
--doubleNoNot supportedRemote Monitor Collector
SQL Net Bytes Rcvd
(SQL_NET_BYTES_RECEIVED)
Amount of data received from clients via SQL*Net--doubleNoAllV$SYSSTAT.VALUE
SQL Net Bytes Sent
(SQL_NET_BYTES_SENT)
Amount of data sent to clients via SQL*Net--doubleNoAllV$SYSSTAT.VALUE
Session CPU Usage
(SESSION_CPU_USAGE)
CPU time used in 1/100 seconds.
To collect the value of this field, the TIMED_STATISTICS parameter must be set to TRUE in the init.ora file.
--doubleNoAllV$SYSSTAT.VALUE
Session Cursor Cache Count
(SESSION_CURSOR_CACHE_COUNT)
Number of session cursors cached. The SESSION_CACHED_CURSORS parameter in the init.ora file specifies the maximum value of this field.--doubleNoAllV$SYSSTAT.VALUE
Session Cursor Cache Hit %
(SESSION_CURSOR_CACHE_HIT_PERCENTAGE)
Hit rate of analysis calls in session's cursor cache--doubleNoAll(session cursor cache hits / session cursor cache count) * 100
Session Cursor Cache Hits
(SESSION_CURSOR_CACHE_HITS)
Number of times a cursor was found in the session's cursor cache by analysis call--doubleNoAllV$SYSSTAT.VALUE
Session PGA Memory
(SESSION_PGA_MEMORY)
Size of PGA memory currently being used in bytes--doubleNoAllV$SYSSTAT.VALUE
Session UGA Memory
(SESSION_UGA_MEMORY)
Size of used session memory in bytes--doubleNoAllV$SYSSTAT.VALUE
Sort Overflow %
(SORT_OVERFLOW_PERCENTAGE)
Percentage ratio of sort operations using a temporary segment--doubleNoAll(sorts (disk) / (sorts (memory) + sorts (disk))) * 100
Start Time
(START_TIME)
Collection start time for the performance data stored in the record--time_tNoAllRemote Monitor Collector
Sys Undo Blk Wait Events
(SYSTEM_UNDO_BLOCK_WAIT_EVENTS)
Number of block wait events for the system's rollback segment--doubleNoAllV$WAITSTAT.COUNT where class = 'system undo block'
Sys Undo Hdr Wait Events
(SYSTEM_UNDO_HEADER_WAIT_EVENTS)
Number of header block wait events for the system's rollback segment--doubleNoAllV$WAITSTAT.COUNT where class = 'system undo header'
Total Logons
(TOTAL_LOGONS)
Number of logins to the server--doubleNoAllV$SYSSTAT.VALUE
Total SQL Executions
(TOTAL_SQL_EXECUTIONS)
Total number of SQL executions--doubleNoAllexecute count
Undo Blk Wait Events
(UNDO_BLOCK_WAIT_EVENTS)
Number of block wait events for other rollback segments--doubleNoAllV$WAITSTAT.COUNT where class = 'undo block'
Undo Hdr Wait Events
(UNDO_HEADER_WAIT_EVENTS)
Number of header block wait events for other rollback segments--doubleNoAllV$WAITSTAT.COUNT where class = 'undo header'
User Calls
(USER_CALLS)
Number of user calls processed--doubleNoAllV$SYSSTAT.VALUE
User Calls / Parse
(USER_CALLS_PER_PARSE)
Application management status in the context area--doubleNoAlluser calls / parse count (total)
User Commits
(USER_COMMITS)
Number of transactions--doubleNoAllV$SYSSTAT.VALUE
User Rollback %
(USER_ROLLBACK_PERCENTAGE)
Failure rate of application transactions--doubleNoAll(user rollbacks / (user commits + user rollbacks)) * 100
User Rollbacks
(USER_ROLLBACKS)
Number of rollbacks--doubleNoAllV$SYSSTAT.VALUE
VA DeviceID
(VADEVICEID)
Device ID of virtual agent.--string(256)NoAllRemote Monitor Collector
Write %
(WRITE_PERCENTAGE)
Percentage ratio of write operations--doubleNoAll(physical writes / (physical reads + physical writes)) * 100