Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$OSSTAT

V$OSSTAT displays system utilization statistics from the operating system. One row is returned for each system statistic.

Column Datatype Description
STAT_NAME VARCHAR2(64) Name of the statistic (see Table 5-1)
VALUE NUMBER Instantaneous statistic value
OSSTAT_ID NUMBER Statistic ID

Table 5-1 V$OSSTAT Statistics

Statistic Name Description
NUM_CPUS Number of CPUs or processors available
IDLE_TICKS Number of hundredths of a second that a processor has been idle, totalled over all processors
BUSY_TICKS Number of hundredths of a second that a processor has been busy executing user or kernel code, totalled over all processors
USER_TICKS Number of hundredths of a second that a processor has been busy executing user code, totalled over all processors
SYS_TICKS Number of hundredths of a second that a processor has been busy executing kernel code, totalled over all processors
IOWAIT_TICKS Number of hundredths of a second that a processor has been waiting for I/O to complete, totalled over all processors
NICE_TICKS Number of hundredths of a second that a processor has been busy executing low-priority user code, totalled over all processors
AVG_IDLE_TICKS Number of hundredths of a second that a processor has been idle, averaged over all processors
AVG_BUSY_TICKS Number of hundredths of a second that a processor has been busy executing user or kernel code, averaged over all processors
AVG_USER_TICKS Number of hundredths of a second that a processor has been busy executing user code, averaged over all processors
AVG_SYS_TICKS Number of hundredths of a second that a processor has been busy executing kernel code, averaged over all processors
AVG_IOWAIT_TICKS Number of hundredths of a second that a processor has been waiting for I/O to complete, averaged over all processors
AVG_NICE_TICKS Number of hundredths of a second that a processor has been busy executing low-priority user code, averaged over all processors
OS_CPU_WAIT_TIME Total number of hundredths of a second that processes have been in a ready state, waiting to be selected by the operating system scheduler to run
RSRC_MGR_CPU_WAIT_TIME Total number of hundredths of a second that Oracle processes have been in a ready state, waiting for CPU to be available for their consumer group in the currently active resource plan
IN_BYTES Total number of bytes that have been paged in
OUT_BYTES Total number of bytes that have been paged out
FS_IN_BYTES Total number of bytes that have been paged in due to the file system
FS_OUT_BYTES Total number of bytes that have been paged out due to the file system
AVG_IN_BYTES Number of bytes that have been paged in, averaged over all processors
AVG_OUT_BYTES Total number of bytes that have been paged out, averaged over all processors
AVG_FS_IN_BYTES Total number of bytes that have been paged in due to the file system, averaged over all processors
AVG_FS_OUT_BYTES Total number of bytes that have been paged out due to the file system, averaged over all processors


Note:

The availability of all statistics except for NUM_CPUS and RSRC_MGR_CPU_WAIT_TIME is subject to the operating system platform on which the Oracle Database is running.DBMS_DEFER_SYS.PUSH function for a push to use parallel propagation. Otherwise, the push uses serial propagation, and no data appears in this view during the push.