Datacentre Support Reference Guides

Visit our online shop for ALL your parts, components, laptops, electronics and gadgets
 

Instance dynamic dba_ views

 
 

  1. v$filestat
  2. v$latch
  3. v$librarycache
  4. v$lock
  5. v$locked_object
  6. v$process
  7. v$rollname
  8. v$rollstat
  9. v$rowcache
  10. v$session_event
  11. v$sgastat
  12. v$statname
  13. v$sysstat
  14. v$system_event
  15. v$waitstat
v$filestat v$latch
Lists the information on file read/write status Lists statistics for nonparent latches and summary statistics for parent latches
Name Null? Type Name Null? Type
FILE# Y NUMBER ADDR Y RAW(4)
PHYRDS Y NUMBER LATCH# Y NUMBER
PHYWRTS Y NUMBER LEVEL# Y NUMBER
PHYBLKRD Y NUMBER NAME Y VARCHAR2(64)
PHYBLKWRT Y NUMBER GETS Y NUMBER
READTIM Y NUMBER MISSES Y NUMBER
WRITETIM Y NUMBER SLEEPS Y NUMBER
AVGIOTIM Y NUMBER IMMEDIATE_GETS Y NUMBER
LSTIOTIM Y NUMBER IMMEDIATE_MISSES Y NUMBER
MINIOTIM Y NUMBER WAITERS_WOKEN Y NUMBER
MAXIORTM Y NUMBER WAITS_HOLDING_LATCH Y NUMBER
MAXIOWTM Y NUMBER SPIN_GETS Y NUMBER
SLEEP1 Y NUMBER
SLEEP2 Y NUMBER
SLEEP3 Y NUMBER
SLEEP4 Y NUMBER
SLEEP5 Y NUMBER
SLEEP6 Y NUMBER
SLEEP7 Y NUMBER
SLEEP8 Y NUMBER
SLEEP9 Y NUMBER
SLEEP10 Y NUMBER
SLEEP11 Y NUMBER
v$librarycache v$lock
Contains statistics about the library cache performance and activity Lists the locks currently held by the Oracle server and outstanding requests for a lock or latch
Name Null? Type Name Null? Type
NAMESPACE Y VARCHAR2(15) ADDR Y RAW(4)
GETS Y NUMBER KADDR Y RAW(4)
GETHITS Y NUMBER SID Y NUMBER
GETHITRATIO Y NUMBER TYPE Y VARCHAR2(2)
PINS Y NUMBER ID1 Y NUMBER
PINHITS Y NUMBER ID2 Y NUMBER
PINHITRATIO Y NUMBER LMODE Y NUMBER
RELOADS Y NUMBER REQUEST Y NUMBER
INVALIDATIONS Y NUMBER CTIME Y NUMBER
DLM_LOCK_REQUESTS Y NUMBER BLOCK Y NUMBER
DLM_PIN_REQUESTS Y NUMBER
DLM_PIN_RELEASES Y NUMBER
DLM_INVALIDATION_REQUESTS Y NUMBER
DLM_INVALIDATIONS Y NUMBER
v$locked_object v$process
Lists all locks acquired by every transaction on the system. Contains information about the currently running processes
Name Null? Type Name Null? Type
XIDUSN Y NUMBER ADDR Y RAW(4)
XIDSLOT Y NUMBER PID Y NUMBER
XIDSQN Y NUMBER SPID Y VARCHAR2(9)
OBJECT_ID Y NUMBER USERNAME Y VARCHAR2(15)
SESSION_ID Y NUMBER SERIAL# Y NUMBER
ORACLE_USERNAME Y VARCHAR2(30) TERMINAL Y VARCHAR2(10)
OS_USER_NAME Y VARCHAR2(30) PROGRAM Y VARCHAR2(48)
PROCESS Y VARCHAR2(9) BACKGROUND Y VARCHAR2(1)
LOCKED_MODE Y NUMBER LATCHWAIT Y VARCHAR2(8)
LATCHSPIN Y VARCHAR2(8)
v$rollname v$rollstat
Rollback segment lookup table. Lists the names of all online rollback segments
Name Null? Type Name Null? Type
USN Y NUMBER USN Y NUMBER
NAME N VARCHAR2(30) EXTENTS Y NUMBER
RSSIZE Y NUMBER
WRITES Y NUMBER
XACTS Y NUMBER
GETS Y NUMBER
WAITS Y NUMBER
OPTSIZE Y NUMBER
HWMSIZE Y NUMBER
SHRINKS Y NUMBER
WRAPS Y NUMBER
EXTENDS Y NUMBER
AVESHRINK Y NUMBER
AVEACTIVE Y NUMBER
STATUS Y VARCHAR2(15)
CUREXT Y NUMBER
CURBLK Y NUMBER
v$rowcache v$session_event
Shows statistics for data dictionary activity Contains information on total waits for an event on the session level.
Name Null? Type Name Null? Type
CACHE# Y NUMBER SID Y NUMBER
TYPE Y VARCHAR2(11) EVENT Y VARCHAR2(64)
SUBORDINATE# Y NUMBER TOTAL_WAITS Y NUMBER
PARAMETER Y VARCHAR2(32) TOTAL_TIMEOUTS Y NUMBER
COUNT Y NUMBER TIME_WAITED Y NUMBER
USAGE Y NUMBER AVERAGE_WAIT Y NUMBER
FIXED Y NUMBER MAX_WAIT Y NUMBER
GETS Y NUMBER
GETMISSES Y NUMBER
SCANS Y NUMBER
SCANMISSES Y NUMBER
SCANCOMPLETES Y NUMBER
MODIFICATIONS Y NUMBER
FLUSHES Y NUMBER
DLM_REQUESTS Y NUMBER
DLM_CONFLICTS Y NUMBER
DLM_RELEASES Y NUMBER
v$sgastat v$statname
Contains detailed information on the system global area Lists the name of the statistics
Name Null? Type Name Null? Type
POOL Y VARCHAR2(11) STATISTIC# Y NUMBER
NAME Y VARCHAR2(26) NAME Y VARCHAR2(64)
BYTES Y NUMBER CLASS Y NUMBER
v$sysstat v$system_event
Contains basic instance statistics Contains information on total waits for an event
Name Null? Type Name Null? Type
STATISTIC# Y NUMBER EVENT Y VARCHAR2(64)
NAME Y VARCHAR2(64) TOTAL_WAITS Y NUMBER
CLASS Y NUMBER TOTAL_TIMEOUTS Y NUMBER
VALUE Y NUMBER TIME_WAITED Y NUMBER
AVERAGE_WAIT Y NUMBER
v$waitstat
Lists block contention statistics.
Name Null? Type
CLASS Y VARCHAR2(18)
COUNT Y NUMBER
TIME Y NUMBER