Chapter 4. Dynamic View

Table of Contents

4.1. Overview
4.2. List of Dynamic Views
4.2.1. V$ACCESS
4.2.2. V$ACTIVE_SESSION_HISTORY
4.2.3. V$ALL_FILESTAT
4.2.4. V$ARCHIVED_LOG
4.2.5. V$ARCHIVE_DEST_FILES
4.2.6. V$AS_ALIAS
4.2.7. V$AS_DISK
4.2.8. V$AS_DISKSPACE
4.2.9. V$AS_EXTENT_MAP
4.2.10. V$AS_FILE
4.2.11. V$AS_OPERATION
4.2.12. V$AS_USER
4.2.13. V$AS_USERGROUP
4.2.14. V$AS_USERGROUP_MEMBER
4.2.15. V$AUTO_COALESCE
4.2.16. V$BACKUP
4.2.17. V$BACKUP_ARCHIVED_LOG
4.2.18. V$BACKUP_SET
4.2.19. V$BACKUP_SET_TABLESPACE
4.2.20. V$BG_SESSION
4.2.21. V$BG_SESSTAT
4.2.22. V$BH
4.2.23. V$BLOCKER_SESSION
4.2.24. V$BPARAMETERS
4.2.25. V$BUFFER_CACHE_ADVICE
4.2.26. V$BUFFER_POOL
4.2.27. V$BUFFER_POOL_STATISTICS
4.2.28. V$CHECKPOINT
4.2.29. V$CLUSTER_INTERCONNECTS
4.2.30. V$CONTEXT
4.2.31. V$CONTROLFILE
4.2.32. V$CORRUPT_XID
4.2.33. V$DATABASE
4.2.34. V$DATAFILE
4.2.35. V$DATAFILE_HEADER
4.2.36. V$DBFILE
4.2.37. V$DBLINK
4.2.38. V$DBLINK_STATUS
4.2.39. V$DB_PIPES
4.2.40. V$ENCRYPTED_TABLESPACES
4.2.41. V$ENCRYPTION_WALLET
4.2.42. V$ENQUEUE_STAT
4.2.43. V$EST_CHECKPOINT_TIME
4.2.44. V$EVENT_NAME
4.2.45. V$FILESTAT
4.2.46. V$GLOBAL_TRANSACTION
4.2.47. V$INSTANCE
4.2.48. V$INSTANCEMETRIC
4.2.49. V$INSTANCEMETRIC_HISTORY
4.2.50. V$INTERCONNECT_LATENCY
4.2.51. V$INTERCONNECTION
4.2.52. V$IPARAM_DESC
4.2.53. V$LATCH
4.2.54. V$LIBRARYCACHE
4.2.55. V$LICENSE
4.2.56. V$LOCK
4.2.57. V$LOG
4.2.58. V$LOGFILE
4.2.59. V$LOG_HISTORY
4.2.60. V$MEDIA_RECOVERY_PROGRESS
4.2.61. V$METRIC
4.2.62. V$METRICNAME
4.2.63. V$MYSTAT
4.2.64. V$OBJECT_USAGE
4.2.65. V$OPEN_CURSOR
4.2.66. V$OSSTAT
4.2.67. V$OSSTAT2
4.2.68. V$PARAMETERS
4.2.69. V$PATCH
4.2.70. V$PE_PESPLAN
4.2.71. V$PE_PESSTAT
4.2.72. V$PE_PROCESS
4.2.73. V$PE_SESSION
4.2.74. V$PE_SYSSTAT
4.2.75. V$PE_TQSTAT
4.2.76. V$PGASTAT
4.2.77. V$PROCESS
4.2.78. V$PROXY_SQLTEXT
4.2.79. V$PROXY_SQL_PARAM
4.2.80. V$RECOVERY_FILE_STATUS
4.2.81. V$RECOVERY_PROGRESS
4.2.82. V$RECOVERY_STATUS
4.2.83. V$RECOVER_FILE
4.2.84. V$RESERVED_WORDS
4.2.85. V$RESULT_CACHE_DEPENDENCY
4.2.86. V$RESULT_CACHE_OBJECTS
4.2.87. V$RESULT_CACHE_OBJECT_STATISTICS
4.2.88. V$RESULT_CACHE_STATISTICS
4.2.89. V$ROLLSTAT
4.2.90. V$ROWCACHE
4.2.91. V$RSBSTAT
4.2.92. V$RSRC_CONSUMER_GROUP
4.2.93. V$RSRC_PLAN
4.2.94. V$RSRC_SESSION_INFO
4.2.95. V$RUNNING_JOBS
4.2.96. V$RUNNING_JOBS_WITH_NAME
4.2.97. V$SEGMENT_STATISTICS
4.2.98. V$SESSION
4.2.99. V$SESSION_EVENT
4.2.100. V$SESSION_IO
4.2.101. V$SESSION_LONGOPS
4.2.102. V$SESSION_WAIT
4.2.103. V$SESSTAT
4.2.104. V$SESS_TIME_MODEL
4.2.105. V$SGA
4.2.106. V$SGASTAT
4.2.107. V$SHP_ADVICE
4.2.108. V$SPINUSE_STAT
4.2.109. V$SQL
4.2.110. V$SQLAREA
4.2.111. V$SQLSTATS
4.2.112. V$SQLTEXT
4.2.113. V$SQLTEXT2
4.2.114. V$SQLTEXT_WITH_NEWLINES
4.2.115. V$SQLTEXT_WITH_NEWLINES2
4.2.116. V$SQL_BIND_CAPTURE
4.2.117. V$SQL_BIND_CAPTURE_ALL
4.2.118. V$SQL_EXPC_INFO
4.2.119. V$SQL_MONITOR
4.2.120. V$SQL_PLAN
4.2.121. V$SQL_PLAN_MONITOR
4.2.122. V$SQL_PLAN_STATISTICS
4.2.123. V$SQL_WORKAREA
4.2.124. V$SQL_WORKAREA_HISTOGRAM
4.2.125. V$SSVR_CLIENT
4.2.126. V$SSVR_FLASHCACHE
4.2.127. V$SSVR_GRID_DISK
4.2.128. V$SSVR_IOLOAD
4.2.129. V$SSVR_IORM_CATEGORY_PLAN
4.2.130. V$SSVR_IORM_DB_PLAN
4.2.131. V$SSVR_IOSTAT
4.2.132. V$SSVR_MEMSTAT
4.2.133. V$SSVR_SLAB_STAT
4.2.134. V$SSVR_STORAGE_DISK
4.2.135. V$STANDBY
4.2.136. V$STANDBY_DEST
4.2.137. V$STANDBY_STATUS
4.2.138. V$STATNAME
4.2.139. V$SYSSTAT
4.2.140. V$SYSSTAT_VALUE
4.2.141. V$SYSTEM_EVENT
4.2.142. V$SYSTEM_PARAMETERS
4.2.143. V$SYS_TIME_MODEL
4.2.144. V$TABLESPACE
4.2.145. V$TACSTAT
4.2.146. V$TEMPFILE
4.2.147. V$TEMPSEG_OP_USAGE
4.2.148. V$TEMPSEG_USAGE
4.2.149. V$TEMPSTAT
4.2.150. V$THR_ACT_INFO
4.2.151. V$THR_EVENT
4.2.152. V$TIMER
4.2.153. V$TIMEZONE_NAMES
4.2.154. V$TRANSACTION
4.2.155. V$TSN_TIME
4.2.156. V$UNDOSTAT
4.2.157. V$UNDO_FREE_SPACE
4.2.158. V$USGMT_TXENTRY
4.2.159. V$VERSION
4.2.160. V$WAITER_SESSION
4.2.161. V$WAITSTAT
4.2.162. V$WAITUSE_STAT
4.2.163. V$WAITUSE_THR_STAT

4.1. Overview

A dynamic view, which is also called Dynamic Performance View (DPV), belongs to the SYS user schema. Dynamic views are used by the DBA to monitor the internal operating status of Tibero and thus users are required to have DBA authority when viewing most of the dynamic views.

Unlike static views providing structural information of the database, dynamic views provide status information of the database at a specific point in time. As the information of dynamic views is provided by information stored in memory and control files, it provides accurate information of the current status of the database.

As the information written to memory and the control file reflects changes over time, dynamic views are recommended for database monitoring and tuning. The dynamic views can be seen using the tbSQL tool, but are not updatable or deletable as they are managed by system.

4.2. List of Dynamic Views

This section provides the list of dynamic views of Tibero in alphabetical order and describes the columns which corresponds to each dynamic view in the table.

The following is the list of summarized dynamic views:

Dynamic ViewDescription
V$ACCESSDisplays information for the objects that the session is accessing.
V$ACTIVE_SESSION_HISTORYDisplays information on the active session history. To enable ACTIVE_SESSION_HISTORY, TOTAL_SHM_SIZE needs to be greater than 2GB.
V$ALL_FILESTATDisplays statistics of data file and temp file I/O.
V$ARCHIVED_LOGDisplays archive log information.
V$ARCHIVE_DEST_FILESDisplays archive log information for archive log files in LOG_ARCHIVE_DEST.
V$AS_ALIASAll Aliases in all disk spaces mounted by the AS instance.
V$AS_DISKAll disks discovered by the AS instance.
V$AS_DISKSPACEAll disk spaces discovered by the AS instance.
V$AS_EXTENT_MAPExtent map of each file in each disk space
V$AS_FILEAll files in all disk spaces mounted by the AS instance.
V$AS_OPERATIONOngoing operations in each disk space
V$AS_USERAll users in all disk spaces mounted by the AS instance.
V$AS_USERGROUPAll usergroups in all disk spaces mounted by the AS instance.
V$AS_USERGROUP_MEMBEREach group members in all disk spaces mounted by the AS instance.
V$AUTO_COALESCEDisplays statistics of an index auto coalesce operations
V$BACKUPDisplays the status of online backup.
V$BACKUP_ARCHIVED_LOGDisplays information of backup archive logs.
V$BACKUP_SETDisplays information of backup sets.
V$BACKUP_SET_TABLESPACEDisplays information of backup tablespace
V$BG_SESSIONDisplays information on each background session.
V$BG_SESSTATDisplays statistics of each background session.
V$BHDisplays information for all buffers.
V$BLOCKER_SESSIONDisplays blocker sessions which are not blocked by other session.
V$BPARAMETERSViews the value of the parameter set in BTIP.
V$BUFFER_CACHE_ADVICEDisplay the estimate hit ratios
V$BUFFER_POOLDisplays information for buffer pools.
V$BUFFER_POOL_STATISTICSDisplays statistics of buffer pools.
V$CHECKPOINTDisplays information for checkpoints.
V$CLUSTER_INTERCONNECTSDisplays interconnects available for use in cluster communication.
V$CONTEXTDisplays context attributes in the current session.
V$CONTROLFILEDisplays information for control files.
V$CORRUPT_XIDDisplays transactions whose recovery is suspended.
V$DATABASEDisplays database status information.
V$DATAFILEDisplays information for data files in the database.
V$DATAFILE_HEADERDisplays information of datafiles by extracting it from file headers.
V$DBFILEDisplays datafile names in the database.
V$DBLINKDisplays information for the open database links in the current session.
V$DBLINK_STATUSDisplays gateway and remote session information for the open database links in each session.
V$DB_PIPESDisplays DBMS_PIPE information.
V$ENCRYPTED_TABLESPACESDisplays information on encrypted tablespaces.
V$ENCRYPTION_WALLETDisplays information of the status of the wallet.
V$ENQUEUE_STATDisplays statistics of locks.
V$EST_CHECKPOINT_TIMEDisplays information for estimated checkpoint time.
V$EVENT_NAMEDisplays event names.
V$FILESTATDisplays file read/write statistics.
V$GLOBAL_TRANSACTIONDisplays information of the currently running global transactions.
V$INSTANCEDisplays instance statuses.
V$INSTANCEMETRICShows the load status of the current node in TAC.
V$INSTANCEMETRIC_HISTORYShows the load status of the current node in TAC.
V$INTERCONNECT_LATENCYDisplays interconnect latency in cluster
V$INTERCONNECTIONDisplays information of interconnection(s) in cluster
V$IPARAM_DESCDisplays initialization parameters.
V$LATCHDisplays spinlock information.
V$LIBRARYCACHEDisplays information of PP cache and DD cache.
V$LICENSEDisplays license information.
V$LOCKDisplays locks that are currently in use.
V$LOGDisplays information of log groups.
V$LOGFILEDisplays information of log member files.
V$LOG_HISTORYDisplays log history information.
V$MEDIA_RECOVERY_PROGRESSDisplays the progress of media recovery.
V$METRICDisplays information on the metric history.
V$METRICNAMEDisplays specifications of the metrics.
V$MYSTATDisplays statistics of the current session.
V$OBJECT_USAGEDisplays statistics about index usage gathered from the database for the indexes owned by the current user.
V$OPEN_CURSORDisplays information for all open cursors for each session
V$OSSTATDisplays various OS statistics.
V$OSSTAT2Displays various OS statistics.
V$PARAMETERSDisplays values of initialization parameters.
V$PATCHDisplays list of patch files.
V$PE_PESPLANDisplays elapsed time information of PES in the format of SQL execution plan.
V$PE_PESSTATDisplays statistics of each PES for parallel processing.
V$PE_PROCESSDisplays information of each parallel execution process currently allocated by QC session.
V$PE_SESSIONDisplays sessions in parallel processing.
V$PE_SYSSTATDisplays statistics of parallel execution.
V$PE_TQSTATDisplays statistics of table queues for parallel processing.
V$PGASTATDisplays statistics of PGA.
V$PROCESSDisplays processes and threads used in RDBMS.
V$PROXY_SQLTEXTDisplays texts of SQL statements that are remotely executed through the database link.
V$PROXY_SQL_PARAMDisplays bind parameters of SQL statements that are remotely executed through the database link.
V$RECOVERY_FILE_STATUSDisplays the status of a file that is being recovered.
V$RECOVERY_PROGRESSDisplays recovery progress.
V$RECOVERY_STATUSDisplays the status of media recovery progress.
V$RECOVER_FILEDisplays files which require media recovery.
V$RESERVED_WORDSDisplays a list of all SQL keywords.
V$RESULT_CACHE_DEPENDENCYDisplays the depends-on relationship between cached result and dependencies.
V$RESULT_CACHE_OBJECTSDisplays Result Cache Objects and their attributes.
V$RESULT_CACHE_OBJECT_STATISTICSDisplays Result Cache Object statistics.
V$RESULT_CACHE_STATISTICSDisplays various Result Cache settings and usage statistics.
V$ROLLSTATDisplays statistics of Undo usage.
V$ROWCACHEDisplays details of status information on DD cache.
V$RSBSTATDisplays Stats of RSBs
V$RSRC_CONSUMER_GROUPDisplays data related to currently active resource consumer groups
V$RSRC_PLANDisplays the names of all currently active resource plans
V$RSRC_SESSION_INFODisplays resource manager statistics per session
V$RUNNING_JOBSDisplays information on running jobs.
V$RUNNING_JOBS_WITH_NAMEDisplays information on running jobs with name.
V$SEGMENT_STATISTICS!!! No documentation yet !!!
V$SESSIONDisplays information on each session.
V$SESSION_EVENTDisplays events that are performed in each session.
V$SESSION_IODisplays input/output which occurred in each session.
V$SESSION_LONGOPSDisplays status of sessions taking longer time than specified in LONGOPS_THRESHOLD_SEC seconds.
V$SESSION_WAITDisplays the waiting status of each session.
V$SESSTATDisplays statistics of each session.
V$SESS_TIME_MODELDisplays the session-level time statistics.
V$SGADisplays information on shared memory used in the database.
V$SGASTATDisplays information on the shared pool for a database, such as its purpose and how much of the shared pool is used.
V$SHP_ADVICEDisplays advice information on the shared pool for a database, such as a recommended shared pool size.
V$SPINUSE_STATDisplays statistics of Spinlock.
V$SQLDisplays details of a SQL child cursor execution.
V$SQLAREADisplays details of SQL statement execution.
V$SQLSTATSDisplays information on SQL statement execution.
V$SQLTEXTDisplays texts of SQL statements belonging to the cursor.
V$SQLTEXT2Displays texts of SQL statements belonging to the cursor.
V$SQLTEXT_WITH_NEWLINESDisplays texts of SQL statements belonging to the cursor, without removing newline characters or blank characters.
V$SQLTEXT_WITH_NEWLINES2Displays texts of SQL statements belonging to the cursor, without removing newline characters or blank characters.
V$SQL_BIND_CAPTUREDisplays the values of the captured bind variables from the current session
V$SQL_BIND_CAPTURE_ALLDisplays the values of the captured bind variables from all sessions
V$SQL_EXPC_INFODisplays information about expression execution of a physical plan
V$SQL_MONITORShows the details of SQL statements that are currently being monitored or those that have been monitored through the real time SQL monitoring function.
V$SQL_PLANDisplays information on physical plans to execute SQL statements.
V$SQL_PLAN_MONITORDisplays plan level information about each SQL execution registered in V$SQL_MONITOR. Each row corresponds to a single plan operation of one SQL execution.
V$SQL_PLAN_STATISTICSDisplays statistics of results of each physical plan job.
V$SQL_WORKAREADisplay information about work areas used by SQL cursors.
V$SQL_WORKAREA_HISTOGRAMDisplay the cumulative work area execution statistics
V$SSVR_CLIENTDisplays information of valid connection to the storage server instance.
V$SSVR_FLASHCACHEDisplays information of flashcaches used by the storage server instance.
V$SSVR_GRID_DISKDisplays information of grid disks.
V$SSVR_IOLOADIO load of storage server
V$SSVR_IORM_CATEGORY_PLANCategory Plan List used by the storage server instance
V$SSVR_IORM_DB_PLANDB Plan List used by the storage server instance
V$SSVR_IOSTATIO stat per sec of storage server
V$SSVR_MEMSTATMemory stat of storage server
V$SSVR_SLAB_STATused buffer slab information of storage server
V$SSVR_STORAGE_DISKDisplays information of storage disks used by the storage server instance.
V$STANDBYDisplays information on the database duplication in the RDBMS Standby Cluster.
V$STANDBY_DESTDisplays information on the standby DB in the RDBMS Standby Cluster.
V$STANDBY_STATUSDisplays information on log duplication of the primary DB in the RDBMS Standby Cluster.
V$STATNAMEDisplays the detailed information on the statistics event.
V$SYSSTATDisplays statistics of a system.
V$SYSSTAT_VALUEDisplays values for getting statistics of a system.
V$SYSTEM_EVENTDisplays events performing in the system.
V$SYSTEM_PARAMETERSDisplays system parameter values.
V$SYS_TIME_MODELDisplays the system-level time statistics.
V$TABLESPACEDisplays information on tablespaces.
V$TACSTATDisplays statistics of a TAC.
V$TEMPFILEDisplays temporary files in the database.
V$TEMPSEG_OP_USAGEDisplays temporary segments usage in the server.
V$TEMPSEG_USAGEDisplays temporary segments in the server.
V$TEMPSTATDisplays statistics of file I/O.
V$THR_ACT_INFODisplays information on activities of the threads.
V$THR_EVENTDisplays events that are performed in each thread.
V$TIMERDisplays information on the system timer.
V$TIMEZONE_NAMESDisplays timezone names.
V$TRANSACTIONDisplays ongoing transactions.
V$TSN_TIMEDisplays the mapping table of TSN and time.
V$UNDOSTATDisplays statistics of Undo storage.
V$UNDO_FREE_SPACEDisplays free space in block count for each UNDO tablespace.
V$USGMT_TXENTRYDisplays undo segment transaction entry information.
V$VERSIONDisplays RDBMS version information.
V$WAITER_SESSIONDisplays information on the sessions that wait for a lock acquisition
V$WAITSTATDisplays information on block wait events for each block type and class
V$WAITUSE_STATDisplays information on block wait events
V$WAITUSE_THR_STATDisplays information on block wait events for each block type, class, and pin usage

4.2.1. V$ACCESS

Displays information for the objects that the session is accessing.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    OWNERVARCHAR(128)

    Owner of the object

    OBJECTVARCHAR(128)

    Name of the object

    TYPEVARCHAR(23)

    Type of the object

4.2.2. V$ACTIVE_SESSION_HISTORY

Displays information on the active session history. To enable ACTIVE_SESSION_HISTORY, TOTAL_SHM_SIZE needs to be greater than 2GB.

  • Columns

    Column NameData TypeDescription
    SAMPLE_IDNUMBER

    Sample ID

    THREAD#NUMBER

    Thread#

    SAMPLE_TIMEDATE

    Sample Time

    SIDNUMBER

    Session ID

    SESS_SERIAL_NONUMBER

    A serial number of a session

    USER_NONUMBER

    The user's ID

    WAIT_EVENTNUMBER

    Type of the wait event which the session waits

    ID1NUMBER

    First Parameter

    ID2NUMBER

    Second Parameter

    WE_SEQNUMBER

    Sequence# of the Wait Event

    TIME_WAITEDNUMBER

    The amount of time waited for this event (msec)

    WAIT_OBJ_IDNUMBER

    ID of the object which the session waits

    WAIT_FILE_NONUMBER

    Number of the file which the session waits

    WAIT_BLOCK_NONUMBER

    Number of the block which the session waits

    WAIT_ROW_NONUMBER

    Number of the row which the session waits

    USGMT_IDNUMBER

    USGMT number at the time of sampling

    SLOTNONUMBER

    Slot number at the time of sampling

    WRAPNONUMBER

    Wrap number at the time of sampling

    SQL_IDVARCHAR(13)

    SQL identifier

    SQL_CHILD_NUMBERNUMBER

    The number of this child physical plan

    CURR_HASHVALNUMBER

    SQL hash value

    MODULE_NAMEVARCHAR(64)

    Name of a module specified by dbms_application_info.set_module

    ACTION_NAMEVARCHAR(64)

    Name of an action specified by dbms_application_info.set_module/action

    CLIENT_INFO_NAMEVARCHAR(64)

    Name of client_info specified by dbms_application_info.set_client_info

    PROG_NAMEVARCHAR(30)

    Client program name

    SQL_EXEC_STARTDATE

    The time when the execution started.

    SQL_EXEC_IDNUMBER

    Execution identifier. It is necessary to identify multiple simultaneous SQL executions. To identify a single SQL execution, three columns; SQL_ID, SQL_EXEC_START, and SQL_EXEC_ID must be defined. The three column values are used to match with corresponding rows in the V$SQL_MONITOR.

    SQL_PLAN_LINE_IDNUMBER

    Identifier of the plan operation

    PORTNUMBER

    Client port number

    DELTA_TIMENUMBER

    Time interval (in seconds) since the last time this session was sampled or created.

    DELTA_PHY_READ_BLKSNUMBER

    The number of blocks read from disk over the last DELTA_TIME seconds

    DELTA_PHY_WRITE_BLKSNUMBER

    The number of blocks written to disk over the last DELTA_TIME seconds

    DELTA_LOG_READ_BLKSNUMBER

    The number of blocks read over the last DELTA_TIME seconds

    PGA_SIZENUMBER

    The amount of PGA memory consumed by this session

4.2.3. V$ALL_FILESTAT

Displays statistics of data file and temp file I/O.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    File number

    TEMPFILECHAR(1)

    Whether this is tempfile

    PHYRDSNUMBER

    The number of reading times

    PHYWRTSNUMBER

    The number of writing times

    PHYBLKRDNUMBER

    The number of read blocks

    PHYBLKWRTNUMBER

    The number of written blocks

    SINGLEBLKRDSNUMBER

    The number of times of reading a single block

    READTIMNUMBER

    Reading time (msec)

    WRITETIMNUMBER

    Writing time (msec)

    SINGLEBLKRDTIMNUMBER

    Time for which a single block was read (msec)

    AVGIOTIMNUMBER

    Average I/O time (msec)

    LSTIOTIMNUMBER

    Last I/O time (msec)

    MINIOTIMNUMBER

    Shortest I/O time (msec)

    MAXIORTMNUMBER

    Longest reading time (msec)

    MAXIOWTMNUMBER

    Longest writing time (msec)

4.2.4. V$ARCHIVED_LOG

Displays archive log information.

  • Columns

    Column NameData TypeDescription
    RECIDNUMBER

    Archive log record ID

    THREAD#NUMBER

    Log group number recorded by instances of a server

    NAMEVARCHAR(256)

    Archive log file path and name

    SEQUENCE#NUMBER

    Sequence number of the log group

    FIRST_CHANGE#NUMBER

    TSN associated with the first archive log that belongs to the log group

    FIRST_TIMEDATE

    Time when the first archive log that belongs to the log group was recorded

    NEXT_CHANGE#NUMBER

    TSN associated with the next archive log that belongs to the log group

    RESETLOGS_CHANGE#NUMBER

    Resetlogs TSN of the database when the log was written

    RESETLOGS_TIMEDATE

    Resetlogs time of the database when the log was written

    FILESIZENUMBER

    Size of logfile in bytes

    BLOCKSNUMBER

    Number of blocks in logfile

    BLOCK_SIZENUMBER

    Size of log block

4.2.5. V$ARCHIVE_DEST_FILES

Displays archive log information for archive log files in LOG_ARCHIVE_DEST.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(256)

    Archive log file path and name

    THREAD#NUMBER

    Log group number recorded by instances of a server

    SEQUENCE#NUMBER

    Sequence number of the log group

    FIRST_CHANGE#NUMBER

    TSN associated with the first archive log that belongs to the log group

    FIRST_TIMEDATE

    Time when the first archive log that belongs to the log group was recorded

    NEXT_CHANGE#NUMBER

    TSN associated with the next archive log that belongs to the log group

    RESETLOGS_CHANGE#NUMBER

    Resetlogs TSN of the database when the log was written

    RESETLOGS_TIMEDATE

    Resetlogs time of the database when the log was written

4.2.6. V$AS_ALIAS

All Aliases in all disk spaces mounted by the AS instance.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(48)

    File Alias(File Name String)

    DISKSPACE_NUMBERNUMBER

    Disk space number that the alias belongs to

    FILE_NUMBERNUMBER

    File number for the alias

    FILE_INCARNATIONNUMBER

    File incarnation number for the alias

    ALIAS_INCARNATIONNUMBER

    Alias incarnation number

4.2.7. V$AS_DISK

All disks discovered by the AS instance.

  • Columns

    Column NameData TypeDescription
    DISKSPACE_NUMBERNUMBER

    Disk space number that the disk belongs to

    DISK_NUMBERNUMBER

    Disk number in the disk space

    STATEVARCHAR(16)

    Disk state in the disk space

    - ONLINE

    - PREPARE_ADD

    - PREPARE_DROP

    - ADDING

    - DROPPING

    - SYNC

    - FAIL

    OS_MBNUMBER

    Disk size recognized by the OS

    TOTAL_MBNUMBER

    Disk size

    FREE_MBNUMBER

    Unused disk space

    NAMEVARCHAR(48)

    Disk name

    FAILGROUPVARCHAR(48)

    Name of the failure group that the disk belongs to

    PATHVARCHAR(256)

    Absolute path of the disk

    CREATE_DATEDATE

    Date when the disk was added to the disk space

4.2.8. V$AS_DISKSPACE

All disk spaces discovered by the AS instance.

  • Columns

    Column NameData TypeDescription
    DISKSPACE_NUMBERNUMBER

    Number assigned to the disk space

    NAMEVARCHAR(48)

    Name of the disk space

    SECTOR_SIZENUMBER

    Physical block size (in bytes)

    BLOCK_SIZENUMBER

    AS metadata block size (in bytes)

    ALLOCATION_UNIT_SIZENUMBER

    Size of the allocation unit (in bytes)

    STATEVARCHAR(16)

    State of the disk space on the AS instance

    - ASSIGNED

    - MOUNTING

    - CREATING

    - MOUNT

    TYPEVARCHAR(8)

    Redundancy level of the disk space

    - EXTERN

    - NORMAL

    - HIGH

    TOTAL_MBNUMBER

    Total capacity of the disk space

    FREE_MBNUMBER

    Unused capacity of the disk space

    REQUIRED_MIRROR_FREE_MBNUMBER

    Required free capacity of the disk space for disk failure

    USABLE_FILE_MBNUMBER

    Usable capacity of the disk space

4.2.9. V$AS_EXTENT_MAP

Extent map of each file in each disk space

  • Columns

    Column NameData TypeDescription
    DISKSPACE_NUMBERNUMBER

    Disk space number that the file belongs to

    FILE_NUMBERNUMBER

    File number in the disk space

    EXTENT_NUMBERNUMBER

    Extent number in the file

    REDUN_NUMBERNUMBER

    Redundancy number of the extent

    - 0 primary

    - 1, 2 redun copy

    EXTENT_SIZENUMBER

    # of AUs in the extent

    DISK_NUMBERNUMBER

    Disk number in the disk space

    AU_NUMBERNUMBER

    AU number in the disk

4.2.10. V$AS_FILE

All files in all disk spaces mounted by the AS instance.

  • Columns

    Column NameData TypeDescription
    DISKSPACE_NUMBERNUMBER

    Disk space number that the file belongs to

    FILE_NUMBERNUMBER

    File number in the disk space

    INCARNATIONNUMBER

    File incarnation number

    BLOCK_SIZENUMBER

    Block size of the file (in bytes)

    BYTESNUMBER

    Number of bytes of the file

    TYPEVARCHAR(64)

    File type

    - DATA

    - CTRL

    - CM

    REDUNDANCYVARCHAR(8)

    Redundancy level of the file

    - EXTERN

    - NORMAL

    - HIGH

    STRIPEDVARCHAR(8)

    Striping type

    - COARSE

    - FINE

4.2.11. V$AS_OPERATION

Ongoing operations in each disk space

  • Columns

    Column NameData TypeDescription
    DISKSPACE_NUMBERNUMBER

    Disk space number that the operation belongs to

    OPERATIONVARCHAR(16)

    Type of the operation

    STATEVARCHAR(8)

    State of the operation

    POWERNUMBER

    Power requested for the operation

    JOB_DONENUMBER

    # of extents that have been processed so far

    JOB_REMAINNUMBER

    # of remained extents that have to be processed

    JOB_TOTALNUMBER

    # of extents that have to be processed by the operation

    EST_SPEEDNUMBER

    extents processed divided by elapsed time

    EST_REMAIN_TIMEVARCHAR(32)

    job_total divided by ext_speed

4.2.12. V$AS_USER

All users in all disk spaces mounted by the AS instance.

  • Columns

    Column NameData TypeDescription
    DISKSPACE_NUMBERNUMBER

    Disk space number that the file belongs to

    USER_NUMBERNUMBER

    User number in the disk space

    INCARNATIONNUMBER

    User incarnation number

    USER_NAMEVARCHAR(128)

    User name

4.2.13. V$AS_USERGROUP

All usergroups in all disk spaces mounted by the AS instance.

  • Columns

    Column NameData TypeDescription
    DISKSPACE_NUMBERNUMBER

    Disk space number that the file belongs to

    USERGROUP_NUMBERNUMBER

    Usergroup number in the disk space

    INCARNATIONNUMBER

    Usergroup incarnation number

    OWNER_NUMBERNUMBER

    Owner number of the usergroup

    OWNER_INCARNATIONNUMBER

    Owner incarnation number

    USERGROUP_NAMEVARCHAR(128)

    Usergroup name

4.2.14. V$AS_USERGROUP_MEMBER

Each group members in all disk spaces mounted by the AS instance.

  • Columns

    Column NameData TypeDescription
    DISKSPACE_NUMBERNUMBER

    Disk space number that the file belongs to

    MEMBER_NUMBERNUMBER

    Member number in the usergroup

    MEMBER_INCARNATIONNUMBER

    Member incarnation number

    USERGROUP_NUMBERNUMBER

    Usergroup number

    USERGROUP_INCARNATIONNUMBER

    Usergroup incarnation number

4.2.15. V$AUTO_COALESCE

Displays statistics of an index auto coalesce operations

  • Columns

    Column NameData TypeDescription
    BUCKET#NUMBER

    Hash bucket number of the coalescing request list

    SGMT_IDNUMBER

    Segment ID of the index to be automatically coalesced

    COAL_REQ_CNTNUMBER

    Total number of the coalescing requests

    COAL_CNTNUMBER

    Total number of the coalescing operations

4.2.16. V$BACKUP

Displays the status of online backup.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    File number

    STATUSVARCHAR(10)

    Status information

    - Active: online backup is being performed

    - Not Active : online backup is not being performed

    CHANGE#NUMBER

    TSN for which backup is started if online backup is being performed

    TIMEDATE

    Time when the backup was started if online backup is being performed

4.2.17. V$BACKUP_ARCHIVED_LOG

Displays information of backup archive logs.

  • Columns

    Column NameData TypeDescription
    SET_IDNUMBER

    Id of backup archivelogs

    THREAD#NUMBER

    Log group number recorded by instances of a server

    MIN_LOG_TIMEDATE

    Minimum begin time of backup archivelogs

    MAX_LOG_TIMEDATE

    Maximum end time of backup archivelogs

    MIN_LOG_TSNNUMBER

    Minimum begin TSN of backup archivelogs

    MAX_LOG_TSNNUMBER

    Maximum end TSN of backup archivelogs

    MIN_LOG_SEQNUMBER

    Minimum sequence of backup archivelogs

    MAX_LOG_SEQNUMBER

    Maximum sequence of backup archivelogs

    RESETLOG_TIMEDATE

    Resetlog time of backup archivelogs

    RESETLOG_TSNNUMBER

    Resetlog TSN of backup archivelogs

4.2.18. V$BACKUP_SET

Displays information of backup sets.

  • Columns

    Column NameData TypeDescription
    SET_IDNUMBER

    Id of backup set

    START_TIMEDATE

    Begin time of backup

    FINISH_TIMEDATE

    End time of backup

    START_TSNNUMBER

    Start TSN of backup

    FINISH_TSNNUMBER

    Finish TSN of backup

    RESETLOGS_TSNNUMBER

    Resetlogs TSN of backup

    BASE_SETNUMBER

    Base set of backup

    SIZENUMBER

    Size of backup set

    IS_PARTIALVARCHAR(10)

    Type of backup

    IS_INCREMENTALVARCHAR(10)

    Type of backup

    WITH_ARCHIVELOGVARCHAR(10)

    Backed up with archivelogs required for point in time recovery

4.2.19. V$BACKUP_SET_TABLESPACE

Displays information of backup tablespace

  • Columns

    Column NameData TypeDescription
    SET_IDNUMBER

    Id of backup set

    TSIDNUMBER

    Tablespace ID

4.2.20. V$BG_SESSION

Displays information on each background session.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    STATUSVARCHAR(32)

    Status of session

    - READY: The session is connected

    - RUNNING: The session is running

    - TX_RECOVERING: The transaction is being recovered

    - SESS_CLEANUP: The session resources are being cleaned up

    - ASSIGNED: Connected to database, but the session is closed

    TYPEVARCHAR(15)

    Session type

    - WTHR: Working thread

    - CTHR: Control thread

    - LGWR: Log writing process

    - CKPT: Checkpoint process

    - LARC: Log archive

    - AGENT: Sequence process

    - MTHR: Monitoring process

    - DBWR: Datablock writing process

    - LNW: Log network writing process

    STATEVARCHAR(25)

    State of working thread

    - INVALID: Not initialized

    - NEW: Being created

    - IDLE: Ready to run

    - RUNNING: Running

    - WAITING: Waiting for internal message

    - RECV_WAITING: Waiting for client message

    - STOP_BY_MTHR: Stopped by MTHR

    - DEAD: Dead

    WLOCK_WAITVARCHAR(18)

    Type of wlock for which the session waits

    WAIT_EVENTNUMBER

    Type of wait_event for which the session waits

    WAIT_TIMENUMBER

    Waiting time of wait_event for which the session waits

    PGA_USED_MEMNUMBER

    The amount of PGA memory occupied by the session

    PIDNUMBER

    Index of a process to which a session belongs

    WTHR_IDNUMBER

    Index of a working thread process to which a session belongs

    OSUSERVARCHAR(128)

    OS account name of the session connected

4.2.21. V$BG_SESSTAT

Displays statistics of each background session.

  • Columns

    Column NameData TypeDescription
    TIDNUMBER

    Session ID

    STAT#NUMBER

    Number of event to obtain statistics

    NAMEVARCHAR(60)

    Name of event to obtain statistics

    CLASSNUMBER

    Class of the event

    VALUENUMBER

    Value of the event (Corresponding to the event name)

4.2.22. V$BH

Displays information for all buffers.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    Absolute number of the file

    BLOCK#NUMBER

    Block number

    BLKTYPENUMBER

    Type of the block

    STATUSVARCHAR(7)

    Status of the buffer

    - READING

    - CURRENT

    - CR

    PIN_MODEVARCHAR(3)

    Pin mode

    TEMPVARCHAR(1)

    Whether it is a buffer of the temporary file or not

    DIRTYVARCHAR(1)

    Whether it is a modified buffer or not

    TS#NUMBER

    ID of the tablespace to which the block corresponding to the buffer belongs

    OBJDNUMBER

    ID of the segment to which the block corresponding to the buffer belongs

4.2.23. V$BLOCKER_SESSION

Displays blocker sessions which are not blocked by other session.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID of the blocker session

    TYPEVARCHAR(25)

    Type of the lock

    ID1NUMBER

    First ID of the lock

    ID2NUMBER

    Second ID of the lock

    MODE_HELDNUMBER

    Mode in which the lock is held

4.2.24. V$BPARAMETERS

Views the value of the parameter set in BTIP.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(64)

    Name of the parameter.

    VALUEVARCHAR(1024)

    Value of the parameter.

4.2.25. V$BUFFER_CACHE_ADVICE

Display the estimate hit ratios

  • Columns

    Column NameData TypeDescription
    BUFFER_CACHE_SIZENUMBER

    The buffer cache size (in Mbytes)

    HIT_RATIONUMBER

    The estimate hit ratio at given buffer cache size

4.2.26. V$BUFFER_POOL

Displays information for buffer pools.

  • Columns

    Column NameData TypeDescription
    IDNUMBER

    Buffer pool ID

    NAMEVARCHAR(7)

    Name of the buffer pool

    BLOCK_SIZENUMBER

    Size of the block

    BUFFERSNUMBER

    The number of the buffers

    WSCNTNUMBER

    The number of the working sets of the buffers pool

4.2.27. V$BUFFER_POOL_STATISTICS

Displays statistics of buffer pools.

  • Columns

    Column NameData TypeDescription
    WS#NUMBER

    Working set number of the buffer pool

    TOTAL_CNTNUMBER

    The total number of blocks in the working set

    MAIN_CNTNUMBER

    The number of main lists

    MAIN2_CNTNUMBER

    The number of the second main lists

    AUX_CNTNUMBER

    The number of the auxiliary lists

    HOT_CNTNUMBER

    The number of the most frequently used buffers

    CR_CNTNUMBER

    The number of the buffers read in the Consistent-Read mode

    EXL_CNTNUMBER

    The number of buffers being modified

    SHR_CNTNUMBER

    The number of buffers being scanned

    DIRTY_CNTNUMBER

    The number of the modified buffers

    SUM_GOTNUMBER

    The total number of buffers gotten by the working set

    SUM_WRITENUMBER

    The total number of the buffers modified by the working set

    SUM_READNUMBER

    The total number of the buffers scanned by the working set

    FREE_WAITNUMBER

    The number of times it waited for a free buffer

    WRITE_WAITNUMBER

    The number of times it waited to write data to disk

    BUSY_WAITNUMBER

    The number of times it waited for the busy buffer

    FREE_SCANNUMBER

    The number of times a free buffer is scanned

    MAIN2_SCANNUMBER

    The number of times the second main list is scanned

4.2.28. V$CHECKPOINT

Displays information for checkpoints.

  • Columns

    Column NameData TypeDescription
    ONGOINGNUMBER

    Whether a checkpoint is activated or not

    - 0: Checkpoint is not activated

    - 1: Checkpoint is activated

    REQ_TYPEVARCHAR(100)

    The reason the checkpoint is activated

    WAITERSNUMBER

    The number of waiters waiting for checkpoint to complete

    MIN_WAIT_TSNNUMBER

    The smallest TSN among the target TSNs waiting for checkpoint to complete

    TARGET_TSNNUMBER

    The target TSN of the checkpoint that is ongoing or has recently completed (A checkpoint gets completed when the target TSN is bigger than LOW_CACHE_TSN)

    LOW_CACHE_TSNNUMBER

    TSN for which the current checkpoint is valid

    MAX_TIMENUMBER

    The longest amount of time needed to complete checkpoint

    MAX_BLOCKSNUMBER

    The maximum number of blocks used by checkpoint

    CHECKPOINT_TSNNUMBER

    TSN of the current checkpoint

4.2.29. V$CLUSTER_INTERCONNECTS

Displays interconnects available for use in cluster communication.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(15)

    Name of the interconnect

    IP_ADDRESSVARCHAR(16)

    IP address of the interconnect

    IS_PUBLICVARCHAR(4)

    Type of interface: public or private. Currently, it supports only private so is always set to NO.

    SOURCEVARCHAR(31)

    Indicates where this interface was picked up from. Currently, it is always set to 'the local_cluster_addr parameter'

4.2.30. V$CONTEXT

Displays context attributes in the current session.

  • Columns

    Column NameData TypeDescription
    NAMESPACEVARCHAR(128)

    The namespace of the context attribute

    ATTRIBUTEVARCHAR(128)

    The name of the attribute

    VALUEVARCHAR(65532)

    The value of the attribute

4.2.31. V$CONTROLFILE

Displays information for control files.

  • Columns

    Column NameData TypeDescription
    STATUSNUMBER

    Status information

    - 0: Normal

    - Negative: Error

    NAMEVARCHAR(256)

    Path name for the control file

    BLKSIZENUMBER

    The size of the control file block

    BLOCKSNUMBER

    The number of blocks in the control file

4.2.32. V$CORRUPT_XID

Displays transactions whose recovery is suspended.

  • Columns

    Column NameData TypeDescription
    XIDVARCHAR(65532)

    ID of the suspended transaction

4.2.33. V$DATABASE

Displays database status information.

  • Columns

    Column NameData TypeDescription
    DBIDNUMBER

    Database identifier (Unique value specified when creating a database)

    NAMEVARCHAR(40)

    Name of the database (Name specified when creating a database)

    CREATE_DATEDATE

    Creation date of the database

    CURRENT_TSNNUMBER

    The current TSN of the database

    OPEN_MODEVARCHAR(10)

    Open mode of the database

    - MOUNTED

    - RECOVERY

    - READ ONLY

    - READ WRITE

    - NOMOUNT

    RESETLOG_TSNNUMBER

    TSN associated with the last resetlogs

    RESETLOG_DATEDATE

    The last resetlogs time

    PREV_RESETLOG_TSNNUMBER

    TSN associated with the previous resetlogs

    PREV_RESETLOG_DATEDATE

    The previous resetlogs time

    LOG_MODEVARCHAR(12)

    Archive log mode

    - ARCHIVELOG

    - NOARCHIVELOG

    CKPT_TSNNUMBER

    TSN associated with the last checkpoint

    CKPT_DATEDATE

    The last checkpoint time

    CPU_NAMEVARCHAR(32)

    The CPU type name

    PLATFORM_NAMEVARCHAR(32)

    The OS platform name

    CPU_MODELVARCHAR(256)

    The CPU model name

    OS_UPTIMEVARCHAR(256)

    The OS uptime info

4.2.34. V$DATAFILE

Displays information for data files in the database.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    Datafile number

    CREATE_TSNNUMBER

    TSN that created the datafile

    CREATE_DATEDATE

    Datafile created time

    TS#NUMBER

    Tablespace number to which the datafile belongs

    RFILE#NUMBER

    Relative datafile number in the tablespace

    STATUSVARCHAR(7)

    Status information of the datafile

    - OFFLINE: Datafile needs to be deleted

    - ONLINE: Datafile is in the normal state

    - RECOVER: Datafile needs to be recovered

    ENABLEDCHAR(10)

    File accessibility

    - DISABLED: Unable to read/write

    - READ ONLY: Readable only

    - READ WRITE: Readable and writable

    CKPT_TSNNUMBER

    TSN associated with the last checkpoint

    CKPT_DATEDATE

    The last checkpoint time

    CREATE_BYTESNUMBER

    Size of the datafile at the time when it is created

    NAMEVARCHAR(256)

    Path name of the datafile

4.2.35. V$DATAFILE_HEADER

Displays information of datafiles by extracting it from file headers.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    Datafile number

    STATUSVARCHAR(7)

    Status of the datafile

    - OFFLINE

    - ONLINE

    DBIDNUMBER

    ID of the database to which the datafile belongs

    DBNAMEVARCHAR(40)

    Name of the database to which the datafile belongs

    BLKSIZENUMBER

    Size of the block

    RECOVERVARCHAR(3)

    Media recovery necessity

    FUZZYVARCHAR(3)

    Whether or not the datafile has been normally closed

    CREATE_TSNNUMBER

    TSN that created the datafile

    CREATE_DATEDATE

    Datafile created time

    TABLESPACE_NAMEVARCHAR(128)

    Name of the tablespace to which the datafile belongs

    TS#NUMBER

    Tablespace number to which the datafile belongs

    RFILE#NUMBER

    Tablespace relative datafile number

    RESETLOGS_TSNNUMBER

    TSN associated with the last reset logs

    RESETLOGS_DATEDATE

    The last resetlogs time

    CKPT_TSNNUMBER

    TSN associated with the last checkpoint

    CKPT_DATEDATE

    The last checkpoint time

    CKPT_COUNTNUMBER

    Checkpoint count

    FILESIZENUMBER

    Size of the datafile

    NAMEVARCHAR(256)

    Path name of the datafile

4.2.36. V$DBFILE

Displays datafile names in the database.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    Datafile number

    NAMEVARCHAR(256)

    Path name of the datafile

4.2.37. V$DBLINK

Displays information for the open database links in the current session.

  • Columns

    Column NameData TypeDescription
    DB_LINKVARCHAR(128)

    Name of the database link

    OWNER_IDNUMBER

    ID of the owner of the database link

    OPEN_CURSORSNUMBER

    The number of cursors opened by the current database link

    IN_TRANSACTIONVARCHAR(3)

    Whether it is a database link that is accessed from the currently running transaction or other transactions

    HETEROGENEOUSVARCHAR(3)

    Whether or not the remote database is RDBMS

    COMMIT_POINT_STRENGTHNUMBER

    Commit point strength of the remote database

4.2.38. V$DBLINK_STATUS

Displays gateway and remote session information for the open database links in each session.

  • Columns

    Column NameData TypeDescription
    SESS_IDNUMBER

    Session ID

    SERIAL#NUMBER

    A serial number of a session (Like SID, used to recognize sessions)

    DB_LINKVARCHAR(128)

    Name of the database link

    OWNER_IDNUMBER

    ID of the owner of the database link

    GATEWAY_PIDNUMBER

    PID of the gateway (in heterogeneous link)

    GATEWAY_NAMEVARCHAR(128)

    Process name of the gateway (in heterogeneous link)

    GATEWAY_TIDNUMBER

    TID (thread id) of the gateway (in heterogeneous link)

    REMOTE_SESS_INFOVARCHAR(32)

    Remote session info

4.2.39. V$DB_PIPES

Displays DBMS_PIPE information.

  • Columns

    Column NameData TypeDescription
    OWNERIDNUMBER

    Owner id of a pipe.

    NAMEVARCHAR(1000)

    Pipe name.

    TYPEVARCHAR(7)

    Pipe type(private or public).

    PIPE_SIZENUMBER

    Maximum size of pipe.

4.2.40. V$ENCRYPTED_TABLESPACES

Displays information on encrypted tablespaces.

  • Columns

    Column NameData TypeDescription
    TS#NUMBER

    A serial number of tablespace

    ENCRYPTIONALGVARCHAR(7)

    An encryption algorithm

    ENCRYPTEDTSVARCHAR(3)

    Whether or not the tablespace was encrypted (YES or NO)

4.2.41. V$ENCRYPTION_WALLET

Displays information of the status of the wallet.

  • Columns

    Column NameData TypeDescription
    WRL_TYPEVARCHAR(20)

    Type of the wallet resource locator

    WRL_PARAMETERVARCHAR(4000)

    Parameter of the wallet resource locator (absolute filename)

    STATUSVARCHAR(10)

    Status of the wallet

4.2.42. V$ENQUEUE_STAT

Displays statistics of locks.

  • Columns

    Column NameData TypeDescription
    IDXNUMBER

    Lock number

    TYPEVARCHAR(25)

    Lock type

    TOTAL_REQ#NUMBER

    Lock requested count

    TOTAL_WAIT#NUMBER

    Lock wait count

    SUCC_REQ#NUMBER

    Lock success count

    FAILED_REQ#NUMBER

    Lock failure count

    CUM_WAIT_TIMENUMBER

    Total Lock wait time (msec)

4.2.43. V$EST_CHECKPOINT_TIME

Displays information for estimated checkpoint time.

  • Columns

    Column NameData TypeDescription
    DIRTY_BLOCKSNUMBER

    The number of dirty blocks in buffer cache

    DISK_WRITE_TIMENUMBER

    The disk write time per block(ms)

    ESTIMATED_CHECKPOINT_TIMENUMBER

    the estimated checkpoint time(s)

4.2.44. V$EVENT_NAME

Displays event names.

  • Columns

    Column NameData TypeDescription
    EVENT#NUMBER

    Event number

    NAMEVARCHAR(40)

    Event name

    CLASSVARCHAR(40)

    Class of the event

    DESCVARCHAR(60)

    Description of the waitevent

    ID1_DESCVARCHAR(60)

    Description of the first event parameter

    ID2_DESCVARCHAR(60)

    Description of the second event parameter

4.2.45. V$FILESTAT

Displays file read/write statistics.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    File number

    PHYRDSNUMBER

    The number of read operations performed

    PHYWRTSNUMBER

    The number of write operations performed

    PHYBLKRDNUMBER

    The number of blocks read

    PHYBLKWRTNUMBER

    The number of blocks written

    SINGLEBLKRDSNUMBER

    Single-block read count

    READTIMNUMBER

    Time spent on read operations (msec)

    WRITETIMNUMBER

    Time spent on write operations (msec)

    SINGLEBLKRDTIMNUMBER

    Time spent to read a single-block (msec)

    AVGIOTIMNUMBER

    Average input/output time (msec)

    LSTIOTIMNUMBER

    Time spent on the last input/output operation (msec)

    MINIOTIMNUMBER

    The minimum time spent on an input/output operation (msec)

    MAXIORTMNUMBER

    The maximum time spent on a read operation (msec)

    MAXIOWTMNUMBER

    The maximum time spent on a write operation (msec)

4.2.46. V$GLOBAL_TRANSACTION

Displays information of the currently running global transactions.

  • Columns

    Column NameData TypeDescription
    GLOBAL_IDVARCHAR(256)

    ID of the global transaction

    SESS_IDNUMBER

    ID of the current session

    LOCAL_IDVARCHAR(65532)

    ID of the local transaction

4.2.47. V$INSTANCE

Displays instance statuses.

  • Columns

    Column NameData TypeDescription
    INSTANCE_NUMBERNUMBER

    Instance number (Used by CM)

    INSTANCE_NAMEVARCHAR(40)

    Name of the instance

    DB_NAMEVARCHAR(40)

    Name of the database

    HOST_NAMEVARCHAR(63)

    Name of the host

    PARALLELVARCHAR(3)

    Whether clustering is activated or not

    THREAD#NUMBER

    Log group number recorded by instances of a server

    VERSIONVARCHAR(8)

    Version of RDBMS

    STARTUP_TIMEDATE

    Instance startup time

    STATUSVARCHAR(16)

    Current status of the server

    - NOMOUNT

    - MOUNT

    - NORMAL

    - RAISING_SVRMODE

    SHUTDOWN_PENDINGVARCHAR(4)

    Whether server shutdown was requested or not

    TIP_FILEVARCHAR(256)

    Pathname of the TIP file

4.2.48. V$INSTANCEMETRIC

Shows the load status of the current node in TAC.

  • Columns

    Column NameData TypeDescription
    BEGIN_TIMEDATE

    Begin time for load calculations

    END_TIMEDATE

    End time for load calculations

    INTSIZE_CSECNUMBER

    Interval length for load calculations (Unit: 0.01 seconds)

    ELAPSEDPERCALLNUMBER

    Average processing time per user request within the interval

    CPUPERCALLNUMBER

    Average CPU processing time per user request within the interval (currently not supported)

    DBTIMEPERCALLNUMBER

    Average DB processing time per user request within the interval (currently not supported)

    CALLSPERSECNUMBER

    Number of user requests per second within the interval

    DBTIMEPERSECNUMBER

    The time consumed in DB per second within the interval (currently not supported)

    GOODNESSNUMBER

    Load level of the interval (number of sessions or average processing time used)

    DELTANUMBER

    Load fluctuation predicated for additional sessions

4.2.49. V$INSTANCEMETRIC_HISTORY

Shows the load status of the current node in TAC.

  • Columns

    Column NameData TypeDescription
    BEGIN_TIMEDATE

    Begin time for load calculations

    END_TIMEDATE

    End time for load calculations

    INTSIZE_CSECNUMBER

    Interval size for load calculations (Unit: 0.01 Seconds)

    ELAPSEDPERCALLNUMBER

    Average processing time per user request within the interval

    CPUPERCALLNUMBER

    Average CPU processing time per user request within the interval (currently not supported)

    DBTIMEPERCALLNUMBER

    Average DB processing time per user request within the interval (currently not supported)

    CALLSPERSECNUMBER

    Number of user requests per second within the interval

    DBTIMEPERSECNUMBER

    The time consumed in DB per second within the interval (currently not supported)

    GOODNESSNUMBER

    Load level of the interval (number of sessions or average processing time used)

    DELTANUMBER

    Load fluctuation predicated for additional sessions

4.2.50. V$INTERCONNECT_LATENCY

Displays interconnect latency in cluster

  • Columns

    Column NameData TypeDescription
    REMOTE_INST_IDNUMBER

    Remote instance id

    MIN_TIMENUMBER

    min time latency(us)

    MAX_TIMENUMBER

    max time latency(us)

    AVG_TIMENUMBER

    average time latency(us)

    CUR_TIMENUMBER

    current time latency(us)

4.2.51. V$INTERCONNECTION

Displays information of interconnection(s) in cluster

  • Columns

    Column NameData TypeDescription
    CONNECTION_IDNUMBER

    Connection ID

    CONNECTION_NIDNUMBER

    Remote instance node ID

    MSG_TO_SENDNUMBER

    Number of messages in send queue

4.2.52. V$IPARAM_DESC

Displays initialization parameters.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(60)

    Name of the initialization parameter

    DESCRIPTIONVARCHAR(65532)

    Description of the initialization parameter

4.2.53. V$LATCH

Displays spinlock information.

  • Columns

    Column NameData TypeDescription
    LATCH#NUMBER

    Spinlock number

    LEVEL#NUMBER

    Level of the spinlock

    NAMEVARCHAR(30)

    Name of the spinlock

    GETSNUMBER

    The number of times a spinlock was acquired

    MISSESNUMBER

    The number of times the requester had to wait for a spinlock

    SPIN_GETSNUMBER

    The number of times the requester failed to acquire a spinlock but succeeded in gaining a spin

    SLEEPSNUMBER

    The number of times the requester was put to sleep while waiting for a spinlock

    IMMEDIATE_GETSNUMBER

    The number of times a trylock was acquired

    IMMEDIATE_MISSESNUMBER

    The number of times the requester failed to acquire a trylock

    WAIT_TIMENUMBER

    The total sleep time of spinlock

    SLEEPS_CNTNUMBER

    The number of actual sleep count while waiting for a spinlock

4.2.54. V$LIBRARYCACHE

Displays information of PP cache and DD cache.

  • Columns

    Column NameData TypeDescription
    NAMESPACEVARCHAR(16)

    Name of the table

    - PP cache: set to ''SQL AREA''

    - DD cache: set to the name of each DD table

    GETSNUMBER

    Cache total access count

    GETHITSNUMBER

    Cache hit count

    GETHITRATIONUMBER

    Cache hit ratio (%)

    PINSNUMBER

    Number of times a PIN was requested for objects

    PINHITSNUMBER

    Number of times objects was pinned

    PINHITRATIONUMBER

    Ratio of PINHITS to PINS

4.2.55. V$LICENSE

Displays license information.

  • Columns

    Column NameData TypeDescription
    LICENSE_VERSIONVARCHAR(50)

    Version of the license

    LICENSEEVARCHAR(100)

    User of the license

    LICENSE_TYPEVARCHAR(30)

    Type of the license

    - DEMO

    - REAL

    PRODUCT_NAMEVARCHAR(100)

    Name of the product

    PRODUCT_VERSIONVARCHAR(50)

    Version of the product

    EDITIONVARCHAR(30)

    Type of product

    - BASE

    - STANDARD

    - ENTERPRISE

    ISSUE_DATEVARCHAR(10)

    Issue date of the license

    EXPIRE_DATEVARCHAR(10)

    Expiration date of the license (Only for the DEMO type of license)

    LIMIT_USERVARCHAR(10)

    Limit for the number of users

    LIMIT_CPUVARCHAR(10)

    Limit for the number of CPUs

    HOSTVARCHAR(100)

    Host (IP or host name)

4.2.56. V$LOCK

Displays locks that are currently in use.

  • Columns

    Column NameData TypeDescription
    TYPEVARCHAR(25)

    Type of the Lock

    ID1NUMBER

    The first ID of the Lock

    ID2NUMBER

    The second ID of the Lock

    LMODENUMBER

    Mode that the Lock owner owns.

    - 0: None

    - 1: Row-Shared(RS)

    - 2: Row-Exclusive(RX)

    - 3: Shared(S)

    - 4: Shared-Row-Exclusive(SRX)

    - 5: Exclusive(X)

    - 6: Pin (Special mode for TX-wait)

    REQUESTEDNUMBER

    Mode that the Lock waiter requests

    SESS_IDNUMBER

    ID of the thread that owns the Lock(the same as SID)

    CTIMENUMBER

    The amount of elapsed time (in seconds) in current mode

4.2.57. V$LOG

Displays information of log groups.

  • Columns

    Column NameData TypeDescription
    THREAD#NUMBER

    Log group number recorded by instances of a server

    GROUP#NUMBER

    Log group number

    SEQUENCE#NUMBER

    Sequence number of the log group

    BYTESNUMBER

    Size of the log group

    MEMBERSNUMBER

    The number of log member files that belong to the log group

    ARCHIVEDVARCHAR(3)

    Whether it was archived or not

    STATUSVARCHAR(8)

    Status information of the log group

    - ACTIVE: File archive needs to be done

    - UNUSED: The log file has not been used

    - CURRENT: The log file is currently in use

    - INACTIVE: File archive has been completed

    FIRST_CHANGE#NUMBER

    TSN associated with the first log that belongs to the log group

    FIRST_TIMEDATE

    Time when the first log that belongs to the log group was recorded

4.2.58. V$LOGFILE

Displays information of log member files.

  • Columns

    Column NameData TypeDescription
    GROUP#NUMBER

    Log group number to which the log member file belongs.

    STATUSVARCHAR(7)

    Status information of the log member file (Whether or not the log member file was deleted. Currently, it is always set to null.)

    TYPECHAR(6)

    Always ONLINE

    MEMBERVARCHAR(256)

    Path name of the log member file

4.2.59. V$LOG_HISTORY

Displays log history information.

  • Columns

    Column NameData TypeDescription
    THREAD#NUMBER

    Log group number recorded by instances of a server

    SEQUENCE#NUMBER

    Sequence number of the log group

    FIRST_CHANGE#NUMBER

    TSN associated with the first log that belongs to the log group

    FIRST_TIMEDATE

    Time when the first log that belongs to the log group was recorded

    NEXT_CHANGE#NUMBER

    TSN associated with the next log that belongs to the log group

    NEXT_TIMEDATE

    Time when the next log that belongs to the log group was recorded

    RESETLOGS_CHANGE#NUMBER

    Resetlogs TSN of the database when the log was written

    RESETLOGS_TIMEDATE

    Resetlogs time of the database when the log was written

    FILESIZENUMBER

    Size of the logfile at the time of log switch

4.2.60. V$MEDIA_RECOVERY_PROGRESS

Displays the progress of media recovery.

  • Columns

    Column NameData TypeDescription
    THREAD#NUMBER

    Log group number recorded by instances of a server

    START_TIMEVARCHAR(19)

    The time when media recovery began

    CURRENT_TIMEVARCHAR(19)

    Current time

    ESTIMATE_TIMEVARCHAR(19)

    Estimated finish time of the media recovery

    BEGIN_SEQUENCE#NUMBER

    Sequence number of the log group where media recovery started

    RECOVERY_SEQUENCE#NUMBER

    Sequence number of the log group that is currently being replayed

    END_SEQUENCE#NUMBER

    Sequence number of the log group where media recovery would end for complete recovery

4.2.61. V$METRIC

Displays information on the metric history.

  • Columns

    Column NameData TypeDescription
    SAMPLE_IDNUMBER

    Sample ID

    THREAD#NUMBER

    Thread#

    BEGIN_TIMEDATE

    Begin Time of the Sample

    END_TIMEDATE

    End Time of the Sample

    METRIC_IDNUMBER

    Metric ID

    METRIC_NAMEVARCHAR(64)

    Metric Name

    VALUENUMBER

    Value of the Metric

    GROUP_IDNUMBER

    Group ID

    GROUP_NAMEVARCHAR(64)

    Group Name

    INTERVALNUMBER

    Interval of the Collection(Sec)

4.2.62. V$METRICNAME

Displays specifications of the metrics.

  • Columns

    Column NameData TypeDescription
    METRIC_IDNUMBER

    Metric ID

    METRIC_NAMEVARCHAR(64)

    Metric Name

    METRIC_UNITVARCHAR(64)

    Descriptions of the Metric Unit

    GROUP_IDNUMBER

    Group ID

    GROUP_NAMEVARCHAR(64)

    Group Name

    INTERVALNUMBER

    Interval of Metric Collection(Sec)

4.2.63. V$MYSTAT

Displays statistics of the current session.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    ID of the session

    STAT#NUMBER

    Event number used to obtain statistics

    NAMEVARCHAR(60)

    Name of the event used to obtain statistics

    CLASSNUMBER

    Class of the event

    VALUENUMBER

    The number of times that the event was used

4.2.64. V$OBJECT_USAGE

Displays statistics about index usage gathered from the database for the indexes owned by the current user.

  • Columns

    Column NameData TypeDescription
    OWNER_NAMEVARCHAR(128)

    Name of user who has the object

    INDEX_NAMEVARCHAR(128)

    The name of the index that is monitored

    TABLE_NAMEVARCHAR(128)

    The name of the base table

    MONITORINGVARCHAR(1)

    Y or N

    USEDVARCHAR(1)

    Y or N

    START_MONITORINGDATE

    Start monitoring time in sys._object_usage.start_monitoring

    END_MONITORINGDATE

    End monitoring time in sys._object_usage.end_monitoring

4.2.65. V$OPEN_CURSOR

Displays information for all open cursors for each session

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    CURSOR_IDNUMBER

    cursor ID

    USER_NAMEVARCHAR(128)

    Name of the current user

    HASH_VALUENUMBER

    Hash value of the SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    SQL_TEXTVARCHAR(64)

    SQL text of the open cursor

    EXEC_TIMENUMBER

    Total working time performed on the cursor

4.2.66. V$OSSTAT

Displays various OS statistics.

  • Columns

    Column NameData TypeDescription
    PIDNUMBER

    Pid of process

    NAMEVARCHAR(64)

    Name of process

    CPUTIMENUMBER

    CPU user time

    CPUUSAGENUMBER

    CPU usage in percentage

4.2.67. V$OSSTAT2

Displays various OS statistics.

  • Columns

    Column NameData TypeDescription
    IDNUMBER

    Id of OS statistic

    STAT_NAMEVARCHAR(64)

    Name of OS statistic

    COMMENTSVARCHAR(512)

    OS statistic comments

    VALUENUMBER

    OS statistic value

    CUMULATIVEVARCHAR(3)

    Whether the statistic is cumulative('YES' or 'NO')

4.2.68. V$PARAMETERS

Displays values of initialization parameters.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(64)

    Name of an initialization parameter

    VALUEVARCHAR(1024)

    Value of an initialization parameter

    DFLT_VALUEVARCHAR(1024)

    Default Value of an initialization parameter

4.2.69. V$PATCH

Displays list of patch files.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(32)

    Name of patch file

4.2.70. V$PE_PESPLAN

Displays elapsed time information of PES in the format of SQL execution plan.

  • Columns

    Column NameData TypeDescription
    Execution_PlanVARCHAR(65532)

    Execution plan and embedded PES statistics

4.2.71. V$PE_PESSTAT

Displays statistics of each PES for parallel processing.

  • Columns

    Column NameData TypeDescription
    SQL_IDVARCHAR(13)

    SQL identifier

    PEM_IDNUMBER

    PEM node ID

    PROD_PPN_IDNUMBER

    PPN ID associated with the producer PES

    PROD_PES_IDNUMBER

    Producer PES ID

    CONS_PPN_IDNUMBER

    PPN ID associated with the consumer PES

    CONS_PES_IDNUMBER

    Consumer PES ID

    ELAPSED_TIMENUMBER

    Total elapsed time

    SAMPLE_TIMENUMBER

    Time taken for sampling with the range mode

4.2.72. V$PE_PROCESS

Displays statistics of each PES for parallel processing.

  • Columns

    Column NameData TypeDescription
    PEP_IDNUMBER

    PE process ID

    OS_PIDNUMBER

    PE process ID generated by OS

    STATUSVARCHAR(16)

    The status of PE process

    CTHR_TIDNUMBER

    The control thread ID of PE process

    QCSIDNUMBER

    ID of a session working as a parallel coordinator

    QCSERIAL#NUMBER

    A serial number of a session working as a parallel coordinator (Like QCSID, used to recognize the session)

    SQL_CNTNUMBER

    The count of processed SQLs plus the current sql after this process has been assigned

    PENDING_MSGVARCHAR(5)

    A flag which indicates whether this process has a pending message from QC

4.2.73. V$PE_SESSION

Displays sessions in parallel processing.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    SERIAL#NUMBER

    A serial number of a session (Like SID, used to recognize the session)

    PEP_IDNUMBER

    ID of parallel execution process which this session belongs to

    QCSIDNUMBER

    ID of a session working as a parallel coordinator

    QCSERIAL#NUMBER

    A serial number of a session working as a parallel coordinator (Like QCSID, used to recognize the session)

    DEGREENUMBER

    Parallel processing degree specified by server

    REQ_DEGREENUMBER

    Parallel processing degree requested by user

4.2.74. V$PE_SYSSTAT

Displays statistics of parallel execution.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(64)

    Name of a PE statistic

    - PEP allocation failure count (current): The number of failure to allocate PEP for current parallel coordinators. This value is incremented at most once for each session.

    - PEP allocation failure count (accumulated): The number of failure to allocate PEP for all parallel coordinators including nonexistent ones. This value is incremented at most once for each session.

    VALUENUMBER

    Value of the PE statistic

4.2.75. V$PE_TQSTAT

Displays statistics of table queues for parallel processing.

  • Columns

    Column NameData TypeDescription
    PEM_IDNUMBER

    PEM node ID

    TQ_IDNUMBER

    Table queue ID

    SERVER_TYPEVARCHAR(10)

    The role of server thread

    - PRODUCER: Transfers a result row to another thread

    - CONSUMER: Receives a result row from another thread

    - RANGER: Determines the range in which a result row is transferred

    NUM_ROWSNUMBER

    The number of processed rows

    BYTESNUMBER

    The byte number of processed data

    WAITSNUMBER

    The number of times of waiting

    THREADVARCHAR(30)

    Thread name

4.2.76. V$PGASTAT

Displays statistics of PGA.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(64)

    Name of a PGA statistic

    - Ex memory soft limit: The maximum amount of PGA memory that can be allocated for the entire working thread running for queries. The memory tuner within the RDBMS monitors the PGA memory usage of the entire thread and adjusts the value accordingly to ensure the value does not exceed the maximum limit.

    - Ex memory operation limit: The maximum amount of memory that can be allocated for a single working thread to use memory (Sort, Hash-Join, and so on) during query executions. The memory tuner within the RDBMS adjusts this value properly when distributing the available memory among a number of working threads simultaneously request memory. The sort and hash-join operation references this value to check whether the operation is possible with its allocated memory. And if not possible, it uses a temporary table space and executes the file I/O operation instead.

    - Total ex memory allocated: The total amount of PGA memory currently occupied by the entire working thread of RDBMS.

    - Total ex memory allocated (max): The highest total PGA memory usage it has ever reached after RDBMS boots. In turn, the system keeps the highest value of the 'Total ex memory allocated' item.

    - FIXED pga memory: The fixed amount of memory that the malloc function directly allocates from the system when booted.

    - ALLOCATED pga memory: The amount of memory allocated using the malloc function and managed by the allocator with the RDBMS. This may increase during the operation.

    - USED pga memory (from ALLOCATED): The amount of 'ALLOCATED pga memory' currently occupied by server processes. This value must be either less than or equal to the value set in 'ALLOCATED pga memory'. And this value is equal to the sum of each 'pga_used_mem' item of the processes listed via v$process.

    - Total workarea memory used: The total amount of memory allocated by the server for query processing.

    - Total workarea temporary segment used: The size of the temporary segments used for query processing.

    VALUENUMBER

    Value of the PGA statistic

4.2.77. V$PROCESS

Displays processes and threads used in RDBMS.

  • Columns

    Column NameData TypeDescription
    PIDNUMBER

    Thread ID

    SPIDNUMBER

    ID of process to which the thread belongs

    NAMEVARCHAR(8)

    Thread name

    LATCHWAITVARCHAR(18)

    Spinlock waiting time of thread (msec)

4.2.78. V$PROXY_SQLTEXT

Displays texts of SQL statements that are remotely executed through the database link.

  • Columns

    Column NameData TypeDescription
    HASH_VALUENUMBER

    Hash value of the SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    IDNUMBER

    Number given to each job of a physical plan

    LINK_NAMEVARCHAR(128)

    Database link name

    PIECENUMBER

    Number given to each text of a split SQL statement

    SQL_TEXTVARCHAR(64)

    Text of an SQL statement split into 64-byte texts

4.2.79. V$PROXY_SQL_PARAM

Displays bind parameters of SQL statements that are remotely executed through the database link.

  • Columns

    Column NameData TypeDescription
    HASH_VALUENUMBER

    Hash value of the SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    IDNUMBER

    Number given to each job of a physical plan

    BIND_NONUMBER

    The order of binding in a proxy node

    CLIENT_BIND_NONUMBER

    The order of binding to all plans

4.2.80. V$RECOVERY_FILE_STATUS

Displays the status of a file that is being recovered.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    A serial number of the file

    NAMEVARCHAR(256)

    The pathname of the file

    STATUSCHAR(11)

    The status of the file (''IN RECOVERY'' signifies a fixed status)

4.2.81. V$RECOVERY_PROGRESS

Displays recovery progress.

  • Columns

    Column NameData TypeDescription
    START_TIMETIMESTAMP(6)

    Start time of the recovery

    END_TIMETIMESTAMP(6)

    End time of the recovery

    TYPECHAR(20)

    Recovery type

    ITEMVARCHAR(32)

    Name of the recovery information

    - UNDO BLOCK COUNT

    - RECOVERY TIME REMAIN

    UNITSVARCHAR(32)

    Unit of the value specified in ITEM column

    AMOUNTNUMBER

    The amount currently recovered

    TOTALNUMBER

    Total amount to be recovered

4.2.82. V$RECOVERY_STATUS

Displays the status of media recovery progress.

  • Columns

    Column NameData TypeDescription
    RECOVERY_FILESNUMBER

    Number of datafiles in media recovery

    NEXT_START_TSNNUMBER

    TSN of the next redo log

    MIN_CANCEL_TSNNUMBER

    The minimum number of TSNs to be the end point of incomplete media recovery

    RECO_TSNNUMBER

    TSN of the current redo log

    REDO_THREADSNUMBER

    Number of redo threads needed in media recovery

    INCOMPLETEVARCHAR(1)

    Whether or not the current media recovery mode is incomplete

    - True: Incomplete media recovery

    - False: Complete media recovery

    CANCEL_TSNNUMBER

    TSN specified to be the end-point of incomplete media recovery

    CANCEL_DATEDATE

    End-point time of the incomplete media recovery

4.2.83. V$RECOVER_FILE

Displays files which require media recovery.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    A serial number of a file

    ONLINEVARCHAR(7)

    Online status of a file

    ERRORVARCHAR(200)

    Error details of a file to be recovered

    CHANGE#NUMBER

    TSN for which to start recovery

    TIMEDATE

    Time that the recovery should be started

4.2.84. V$RESERVED_WORDS

Displays a list of all SQL keywords.

  • Columns

    Column NameData TypeDescription
    KEYWORDVARCHAR(30)

    Name of the keyword

    LENGTHNUMBER

    Length of the keyword

    RESERVEDVARCHAR(1)

    Whether or not the keyword cannot be used as an identifier

4.2.85. V$RESULT_CACHE_DEPENDENCY

Displays the depends-on relationship between cached result and dependencies.

  • Columns

    Column NameData TypeDescription
    RESULT_IDNUMBER

    ID of the cached result

    DEPEND_IDNUMBER

    ID of the dependency object

    OBJECT_NONUMBER

    Dictionary object number of the dependency object

4.2.86. V$RESULT_CACHE_OBJECTS

Displays Result Cache Objects and their attributes.

  • Columns

    Column NameData TypeDescription
    IDNUMBER

    ID of the cached object

    TYPEVARCHAR(10)

    Type of the cached object

    - Result

    - Dependency

    STATUSVARCHAR(9)

    status of the object

    - New: Result is still under construction

    - Published: Result is available for use

    - Invalid: Result is no longer available for use

    BUCKET_NONUMBER

    Internal hash bucket of the object

    HASHNUMBER

    Hash value of the object

    NAMEVARCHAR(512)

    SQL prefix

    NAMESPACEVARCHAR(3)

    Namespace (SQL or PSM)

    CREATION_TIMESTAMPDATE

    Time when the object was created

    CREATOR_UIDNUMBER

    ID of the schema that created the object

    DEPEND_COUNTNUMBER

    Number of dependencies or dependents

    TSNNUMBER

    Build TSN or invalidation TSN

    COLUMN_COUNTNUMBER

    Number of columns in the cached result

    ROW_COUNTNUMBER

    Total number of rows in the cached result

    PIN_COUNTNUMBER

    Number of active scans on this result

    BUILD_TIMENUMBER

    Amount of time (in millisecond) it took to build the cached result

    OBJECT_NONUMBER

    Dictionary object number of the dependency object

    INVALIDATIONSNUMBER

    Number of times the object has invalidated its dependents

    SPACE_USEDNUMBER

    Used space (in bytes) for the result

    CACHE_IDVARCHAR(512)

    Cache ID for the result

4.2.87. V$RESULT_CACHE_OBJECT_STATISTICS

Displays Result Cache Object statistics.

  • Columns

    Column NameData TypeDescription
    IDNUMBER

    ID of the cached object

    NAMEVARCHAR(512)

    SQL prefix

    NAMESPACEVARCHAR(3)

    Namespace (SQL or UDF)

    SEARCH_COUNTNUMBER

    Total number of searches in the cached result

    HIT_COUNTNUMBER

    Total number of hits in the cached result

    HIT_RATIONUMBER

    Ratio of hits in the cached result

4.2.88. V$RESULT_CACHE_STATISTICS

Displays various Result Cache settings and usage statistics.

  • Columns

    Column NameData TypeDescription
    IDNUMBER

    Statistic number

    NAMEVARCHAR(40)

    Name of the statistic

    VALUENUMBER

    Value of the statistic

4.2.89. V$ROLLSTAT

Displays statistics of Undo usage.

  • Columns

    Column NameData TypeDescription
    USNNUMBER

    Undo segment number

    EXTENTSNUMBER

    The number of extents

    RSSIZENUMBER

    The size of Undo segment

    SEQNONUMBER

    Sequence number of undo segment

    INCNONUMBER

    The number of undo segment incarnation

    XACTSNUMBER

    The number of transactions which are performing the assigned Undo segment

    HWMSIZENUMBER

    The number of Undo blocks which were already used

    SHRINKSNUMBER

    The number of times of shrinking Undo space

    WRAPSNUMBER

    The number of times of reusing Undo space

    EXTENDSNUMBER

    The number of times of extending Undo space

    SHRINK_SIZENUMBER

    The number of Undo blocks shrinking Undo space

    ACTIVE_SIZENUMBER

    The number of Undo blocks currently in use

    STATUSNUMBER

    Status information ("ONLINE" signifies a fixed status)

    CUREXTNUMBER

    Extent that is currently in use

    CURSIZENUMBER

    The size of extent currently in use

    CURBLKNUMBER

    Block number in use by the current extent

    MAX_ACTIVE_SIZENUMBER

    The maximum number of blocks used by Undo segment

4.2.90. V$ROWCACHE

Displays details of status information on DD cache.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(16)

    DD table name

    SEARCH_KEYNUMBER

    Search key value in DD cache

    BUCKETSET_IDNUMBER

    Bucketset ID in the search key

    ENTRY_CNTNUMBER

    The number of entries cached in the bucketset

    HIT_CNTNUMBER

    The number of times that DD cache succeeded

    MISS_CNTNUMBER

    The number of times that DD cache failed

    CACHE_SIZENUMBER

    The size of the bucketset (in bytes)

    PINNED_CNTNUMBER

    The number of entries pinned in the bucketset

    INVALID_CNTNUMBER

    The number of invalid entries in the bucketset

    NE_CNTNUMBER

    The number of entries for objects which do not exist in the bucketset

4.2.91. V$RSBSTAT

Displays Stats of RSBs

  • Columns

    Column NameData TypeDescription
    CTXCHAR(3)

    Context (CCC, CWS)

    MST_RSBNUMBER

    Count of Master RSBs

    SHD_RSBNUMBER

    Count of Shadow RSBs

    RECLAIMEDNUMBER

    Accumulated Count of reclaimed RSBs

    FAILED_BHNUMBER

    Accumulated Count of RSB reclamation failures (cached bh)

    FAILED_USINGNUMBER

    Accumulated Count of RSB reclamation failures (in use)

    FAILED_GLOBALNUMBER

    Accumulated Count of RSB reclamation failures (global rsb)

    FAILED_PINNUMBER

    Accumulated Count of RSB reclamation failures (pinned)

    FAILED_INVALNUMBER

    Accumulated Count of RSB reclamation failures (on inval)

4.2.92. V$RSRC_CONSUMER_GROUP

Displays data related to currently active resource consumer groups

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(32)

    Name of the consumer group

    ACTIVE_SESSIONSNUMBER

    Number of currently active sessions in the consumer group

    CONSUMED_CPU_TIMENUMBER

    Cumulative amount of CPU time consumed by all sessions in the consumer group

    YIELDSNUMBER

    Cumulative number of times that sessions in the consumer group had to yield CPU to other sessions because of quantum expiration

    SMALL_READ_MEGABYTESNUMBER

    Number of single block megabytes read

    LARGE_READ_MEGABYTESNUMBER

    Number of multiblock megabytes read

    SMALL_READ_REQUESTSNUMBER

    Number of single block read requests

    LARGE_READ_REQUESTSNUMBER

    Number of multiblock read requests

4.2.93. V$RSRC_PLAN

Displays the names of all currently active resource plans

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(32)

    Name of the resource plan

    IS_TOP_PLANVARCHAR(5)

    Indicates whether the resource plan is the current top plan

4.2.94. V$RSRC_SESSION_INFO

Displays resource manager statistics per session

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session identifier

    CURRENT_CONSUMER_GROUPVARCHAR(32)

    The name of the consumer group in which the session currently belongs

    STATEVARCHAR(32)

    Current state of the session

    CONSUMED_CPU_TIMENUMBER

    Cumulative amount of CPU time consumed by the session

    YIELDSNUMBER

    Cumulative number of times the session had to yield CPU to other sessions due to quantum expiration

    SMALL_READ_MEGABYTESNUMBER

    Total number of single block megabytes read by the session

    LARGE_READ_MEGABYTESNUMBER

    Total number of multiblock megabytes read by the session

    SMALL_READ_REQUESTSNUMBER

    Total number of single block read requests by the session

    LARGE_READ_REQUESTSNUMBER

    Total number of multiblock read requests by the session

4.2.95. V$RUNNING_JOBS

Displays information on running jobs.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID of the currently running job

    JOB_IDNUMBER

    JOB ID of the currently running job

    START_TIMEDATE

    Start time of the job

    FAILURENUMBER

    Job failure count

    INSTANCENUMBER

    Instance name that started the currently running job

4.2.96. V$RUNNING_JOBS_WITH_NAME

Displays information on running jobs with name.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID of the currently running job

    JOB_IDNUMBER

    JOB ID of the currently running job

    JOB_NAMEVARCHAR(100)

    JOB name of the currently running job

    START_TIMEDATE

    Start time of the job

    FAILURENUMBER

    Job failure count

    INSTANCENUMBER

    Instance name that started the currently running job

4.2.97. V$SEGMENT_STATISTICS

  • Columns

    Column NameData TypeDescription
    IDNUMBER

    Object ID

    NAMEVARCHAR(128)

    Object name

    TYPEVARCHAR(20)

    Object type

    STATISTICS#NUMBER

    Segment Statistics Type

    STATISTICS_NAMEVARCHAR(64)

    Name of the Segment Statistics

    VALUENUMBER

    Value of the Segment Statistics

4.2.98. V$SESSION

Displays information on each session.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    SERIAL#NUMBER

    A serial number of a session (Like SID, used to recognize sessions)

    AUDSIDNUMBER

    A secondary serial number of a session

    USER#NUMBER

    The current user's ID

    USERNAMEVARCHAR(128)

    The current user's name

    IPADDRVARCHAR(21)

    IP to which the user connects

    COMMANDNUMBER

    Currently performing SQL type

    - 1: SELECT

    - 2: INSERT

    - 3: UPDATE

    - 4: DELETE

    - 5: CALL

    STATUSVARCHAR(32)

    Status of session

    - READY: The session is ready

    - RUNNING: The session is running

    - TX_RECOVERING: The transaction is being recovered

    - SESS_CLEANUP: The session resources are being cleaned up

    - ASSIGNED: The session has an assigned thread, but is not ready yet

    - CLOSING: The session is being closed

    - ROLLING_BACK: The statement-level transaction of PE slave is rolling back.

    SCHEMA#NUMBER

    The current schema ID

    SCHEMANAMEVARCHAR(128)

    The current schema name

    TYPEVARCHAR(15)

    Session type

    - WTHR: Working thread

    - CTHR: Control thread

    - LGWR: Log writing process

    - CKPT: Checkpoint process

    - LARC: Log archive

    - AGENT: Sequence process

    - MTHR: Monitoring process

    - DBWR: Datablock writing process

    - LNW: Log network writing process

    SQL_IDVARCHAR(13)

    ID of the currently running SQL

    SQL_CHILD_NUMBERNUMBER

    Child number of the currently running SQL

    PREV_SQL_IDVARCHAR(13)

    ID of the last executed SQL

    PREV_CHILD_NUMBERNUMBER

    Child number of the last executed SQL

    SQL_ETNUMBER

    Elapsed time (ms) of SQL that is being performed

    LOGON_TIMEDATE

    Logon time

    STATEVARCHAR(25)

    State of working thread

    - INVALID: Not initialized.

    - NEW: Being created

    - IDLE: Ready to run

    - RUNNING: Running

    - WAITING: Waiting for internal message

    - RECV_WAITING: Waiting for client message

    - STOP_BY_MTHR: Stopped by MTHR

    - DEAD: Dead

    WLOCK_WAITVARCHAR(18)

    Type of wlock for which the session waits

    WAIT_EVENTNUMBER

    Type of wait_event for which the session waits

    WAIT_TIMENUMBER

    Waiting time of wait_event for which the session waits

    PGA_USED_MEMNUMBER

    The amount of PGA memory occupied by the session

    SQL_TRACEVARCHAR(8)

    Whether a session uses SQL trace

    PROG_NAMEVARCHAR(30)

    Client program name

    CLIENT_PIDNUMBER

    Client PID

    PIDNUMBER

    Identifier of a process to which a session belongs

    WTHR_IDNUMBER

    Index of a worker thread to which a session belongs

    OS_THR_IDNUMBER

    Identifier of thread generated from OS to which a session belongs

    OSUSERVARCHAR(128)

    OS account name of the session connected

    MACHINEVARCHAR(64)

    Host name of the session connected

    TERMINALVARCHAR(16)

    Terminal(tty) information of the session connected

    MODULEVARCHAR(64)

    Name of a module specified by dbms_application_info.set_module

    ACTIONVARCHAR(64)

    Name of an action specified by dbms_application_info.set_module/action

    CLIENT_INFOVARCHAR(64)

    Name of client_info specified by dbms_application_info.set_client_info

    CLIENT_IDENTIFIERVARCHAR(64)

    Name of client ID specified by dbms_session.set_identifier

    PDML_ENABLEDVARCHAR(3)

    Parallel dml enabled, YES or NO

    PDML_STATUSVARCHAR(8)

    Parallel dml status, FORCE, ENABLED or DISABLED

    PDDL_STATUSVARCHAR(8)

    Parallel ddl status, FORCE, ENABLED or DISABLED

    PQ_STATUSVARCHAR(8)

    Parallel query status, FORCE, ENABLED or DISABLED

    ROW_WAIT_OBJ_IDNUMBER

    Object ID of the row that causes a lock when waiting for a row lock.

    ROW_WAIT_FILE_NONUMBER

    File number of the row that causes a lock when waiting for a row lock.

    ROW_WAIT_BLOCK_NONUMBER

    Block number of the row that causes a lock when waiting for a row lock.

    ROW_WAIT_ROW_NONUMBER

    Number of row that causes a lock when waiting for a row lock.

    CONSUMER_GROUPVARCHAR(32)

    The name of the consumer group in which the session currently belongs

    CONSUMED_CPU_TIMENUMBER

    Cumulative amount of CPU time consumed by the session

4.2.99. V$SESSION_EVENT

Displays events that are performed in each session.

  • Columns

    Column NameData TypeDescription
    TIDNUMBER

    Session ID

    IDXNUMBER

    Event number

    NAMEVARCHAR(40)

    Name of the event

    CLASSVARCHAR(40)

    Class of the event

    DESCVARCHAR(60)

    Description of the event

    TOTAL_WAITSNUMBER

    Total number of event calls

    TOTAL_TIMEOUTSNUMBER

    The number of times that a time-out occurred in an event

    TIME_WAITEDNUMBER

    The amount of time waited for this event (msec)

    AVERAGE_WAITNUMBER

    The average amount of time waited for this event (msec)

    MAX_WAITNUMBER

    The maximum amount of time waited for this event (msec)

4.2.100. V$SESSION_IO

Displays input/output which occurred in each session.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    BLOCK_GETSNUMBER

    The number of times of reading blocks in Current mode

    CONSISTENT_GETSNUMBER

    The number of times of reading blocks in Consistent Read (CR) mode

    PHYSICAL_READSNUMBER

    The number of blocks read in the disk

    BLOCK_CHANGESNUMBER

    The number of times of changing a buffer read in Current mode

    CONSISTENT_CHANGESNUMBER

    The number of times of changing a buffer read in Consistent Read mode

4.2.101. V$SESSION_LONGOPS

Displays status of sessions taking longer time than specified in LONGOPS_THRESHOLD_SEC seconds.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    SERIAL#NUMBER

    A serial number of a session (Like SID, used to recognize sessions)

    USER_NAMEVARCHAR(128)

    Name of the current user

    WTHR_IDNUMBER

    Index of a working thread process to which a session belongs

    SQL_IDVARCHAR(13)

    SQL identifier

    SQL_PLAN_IDNUMBER

    SQL physical plan identifier

    OPNAMEVARCHAR(128)

    Name of the operation

    TARGETVARCHAR(128)

    Name of the target object

    SOFARNUMBER

    The work throughput done so far

    TOTALWORKNUMBER

    The overall work throughput

    UNITSVARCHAR(128)

    Unit of the work throughput

    START_TIMEDATE

    Start time of the session

    ELAPSED_TIMENUMBER

    Total time for which a particular job has been performed (in milliseconds)

    END_TIMEDATE

    End time of the session

4.2.102. V$SESSION_WAIT

Displays the waiting status of each session.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    NAMEVARCHAR(24)

    Name of waiting event

    ID1NUMBER

    ID1 of waiting target

    ID2NUMBER

    ID2 of waiting target

    SEQ#NUMBER

    Sequence of wait event

    TIME_WAITEDNUMBER

    Time for which an event was waiting (msec)

    TIMEOUTNUMBER

    Time-out value (msec)

4.2.103. V$SESSTAT

Displays statistics of each session.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    STAT#NUMBER

    Number of event to obtain statistics

    NAMEVARCHAR(60)

    Name of event to obtain statistics

    CLASSNUMBER

    Class of the event

    VALUENUMBER

    Value of the event (Corresponding to the event name)

4.2.104. V$SESS_TIME_MODEL

Displays the session-level time statistics.

  • Columns

    Column NameData TypeDescription
    SIDNUMBER

    Session ID

    STAT_IDNUMBER

    Identifier of a time statistics

    STAT_NAMEVARCHAR(64)

    Name of a time statistics

    VALUENUMBER

    Amount of time (in microseconds)

4.2.105. V$SGA

Displays information on shared memory used in the database.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(40)

    Name of shared memory space

    - SHARED MEMORY: Total shared memory size allocated during instance startup according to the value of TOTAL_SHM_SIZE.

    - FIXED MEMORY: Total fixed memory area size fixed for database buffers, redo buffers, etc.

    - SHARED POOL MEMORY: Total/used shared pool size for various purposes. Memory is allocated on demand using a shared pool allocator specific to the purpose. The size of the allocators can be extended as long as the pool is available.

    - SHARED POOL ALLOCATORS (LC): Total/used memory size of the allocators for library cache memory.

    - SHARED POOL ALLOCATORS (DD): Total/used memory size of the allocators for data dictionary cache memory.

    - SHARED POOL ALLOCATORS (SLAB): Total/used memory size of the allocators for slab memory.

    - SHARED POOL ALLOCATORS (MISC): Total/used memory size of the allocators for miscellaneous memory.

    - SHARED POOL ALLOCATORS (Total): Total/used memory size of the allocators for all purposes. This size equals the sum of all allocator sizes.

    - Database Buffers: Total database buffer size allocated since instance startup according to the value of DB_CACHE_SIZE.

    - Redo Buffers: Total redo buffer size allocated during instance startup according to the value of LOG_BUFFER.

    TOTALNUMBER

    Size of shared memory space

    USEDNUMBER

    Usage of shared memory space

4.2.106. V$SGASTAT

Displays information on the shared pool for a database, such as its purpose and how much of the shared pool is used.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(40)

    Purpose for which shared pool is used

    SIZENUMBER

    Usage of shared pool

4.2.107. V$SHP_ADVICE

Displays advice information on the shared pool for a database, such as a recommended shared pool size.

  • Columns

    Column NameData TypeDescription

4.2.108. V$SPINUSE_STAT

Displays statistics of Spinlock.

  • Columns

    Column NameData TypeDescription
    LOCATIONVARCHAR(60)

    Location of Spinlock

    SLEEPS_CNTNUMBER

    The number of cases that a LOCK is possessed in LOCATION while sleeping to obtain Spinlock

4.2.109. V$SQL

Displays details of a SQL child cursor execution.

  • Columns

    Column NameData TypeDescription
    SQL_IDVARCHAR(13)

    SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    HASH_VALUENUMBER

    Hash value of the SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    FIRST_LOAD_TIMEDATE

    Time that an SQL statement was first loaded

    LAST_ACTIVE_TIMEDATE

    Last time that statistics were collected

    PARSING_USER_IDNUMBER

    Identifier of user that parsed an SQL statement for the first time

    PARSING_SCHEMA_IDNUMBER

    Identifier of schema that parsed an SQL statement for the first time

    MODULEVARCHAR(64)

    Name of module that had been set when an SQL statement was parsed for the first time

    ACTIONVARCHAR(64)

    Name of action that had been set when an SQL statement was first parsed

    SQL_TEXTVARCHAR(30000)

    SQL text of the current cursor

    IS_SHAREABLEVARCHAR(1)

    Indicates whether this child cursor can be shared

    CPU_TIMENUMBER

    CPU time (microseconds)

    ELAPSED_TIMENUMBER

    Total execution time

    PARSE_CALLSNUMBER

    The number of parsing requests

    ROWS_PROCESSEDNUMBER

    Total number of processed rows

    FETCHESNUMBER

    The number of fetching times

    EXECUTIONSNUMBER

    The number of times executing an SQL statement

    END_OF_FETCH_COUNTNUMBER

    The number of times this SQL statement was fully executed

    PX_SERVERS_EXECUTIONSNUMBER

    The number of times executing parallel execution slaves

    APPLICATION_WAIT_TIMENUMBER

    Total amount of application wait time

    CONCURRENCY_WAIT_TIMENUMBER

    Total amount of concurrency wait time

    CLUSTER_WAIT_TIMENUMBER

    Total amount of cluster wait time

    USER_IO_WAIT_TIMENUMBER

    Total amount of I/O wait time (by user)

    DISK_READSNUMBER

    Disk read count

    DIRECT_WRITESNUMBER

    Direct write count

    BUFFER_GETSNUMBER

    Total number of buffers read in Consistent-Read mode

    PHYSICAL_READ_REQUESTSNUMBER

    Disk read request count

    PHYSICAL_READ_BYTESNUMBER

    Total number of bytes read from disks (in bytes)

    PHYSICAL_WRITE_REQUESTSNUMBER

    Disk write request count

    PHYSICAL_WRITE_BYTESNUMBER

    Total number of bytes write to disks (in bytes)

    SORTSNUMBER

    The number of sorts performed

    OBJECT_STATUSVARCHAR(14)

    Status of the cursor

4.2.110. V$SQLAREA

Displays details of SQL statement execution.

  • Columns

    Column NameData TypeDescription
    SQL_IDVARCHAR(13)

    SQL identifier

    HASH_VALUENUMBER

    Hash value of the SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    LAST_ACTIVE_TIMEDATE

    Last time that statistics were collected

    FIRST_LOAD_TIMEDATE

    Time that an SQL statement was first loaded

    PARSING_USER_IDNUMBER

    Identifier of user that parsed an SQL statement for the first time

    PARSING_SCHEMA_IDNUMBER

    Identifier of schema that parsed an SQL statement for the first time

    MODULEVARCHAR(64)

    Name of module that had been set when an SQL statement was parsed for the first time

    ACTIONVARCHAR(64)

    Name of action that had been set when an SQL statement was first parsed

    SQL_TEXTVARCHAR(30000)

    SQL text of the current cursor

    CPU_TIMENUMBER

    CPU time (microseconds)

    ELAPSED_TIMENUMBER

    Total execution time

    PARSE_CALLSNUMBER

    The number of parsing requests

    ROWS_PROCESSEDNUMBER

    Total number of processed rows

    FETCHESNUMBER

    The number of fetching times

    EXECUTIONSNUMBER

    The number of times executing an SQL statement

    END_OF_FETCH_COUNTNUMBER

    The number of times this SQL statement was fully executed

    PX_SERVERS_EXECUTIONSNUMBER

    The number of times executing parallel execution slaves

    APPLICATION_WAIT_TIMENUMBER

    Total amount of application wait time

    CONCURRENCY_WAIT_TIMENUMBER

    Total amount of concurrency wait time

    CLUSTER_WAIT_TIMENUMBER

    Total amount of cluster wait time

    USER_IO_WAIT_TIMENUMBER

    Total amount of I/O wait time (by user)

    DISK_READSNUMBER

    Disk read count

    DIRECT_WRITESNUMBER

    Direct write count

    BUFFER_GETSNUMBER

    Total number of buffers read in Consistent-Read mode

    PHYSICAL_READ_REQUESTSNUMBER

    Disk read request count

    PHYSICAL_READ_BYTESNUMBER

    Total number of bytes read from disks (in bytes)

    PHYSICAL_WRITE_REQUESTSNUMBER

    Disk write request count

    PHYSICAL_WRITE_BYTESNUMBER

    Total number of bytes write to disks (in bytes)

    SORTSNUMBER

    The number of sorts performed

4.2.111. V$SQLSTATS

Displays information on SQL statement execution.

  • Columns

    Column NameData TypeDescription
    SQL_TEXTVARCHAR(1000)

    First thousand characters of the SQL text

    SQL_IDVARCHAR(13)

    SQL identifier

    HASH_VALUENUMBER

    Hash value of the SQL statement

    LAST_ACTIVE_TIMEDATE

    Last time that statistics were collected

    LAST_ACTIVE_CHILD_ADDRESSRAW(8)

    Address of the child physical plan when the statistics were collected

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SHAREABLE_MEMNUMBER

    Total shared memory (in bytes) occupied by all child cursors

    CPU_TIMENUMBER

    CPU time (microseconds)

    ELAPSED_TIMENUMBER

    Total execution time (in microseconds)

    PARSE_CALLSNUMBER

    The number of parsing requests

    ROWS_PROCESSEDNUMBER

    Total number of processed rows

    FETCHESNUMBER

    The number of fetching times

    EXECUTIONSNUMBER

    The number of times executing an SQL statement

    END_OF_FETCH_COUNTNUMBER

    The number of times this SQL statement was fully executed

    PX_SERVERS_EXECUTIONSNUMBER

    The number of times executing parallel execution slaves

    APPLICATION_WAIT_TIMENUMBER

    Total amount of application wait time

    CONCURRENCY_WAIT_TIMENUMBER

    Total amount of concurrency wait time

    CLUSTER_WAIT_TIMENUMBER

    Total amount of cluster wait time

    USER_IO_WAIT_TIMENUMBER

    Total amount of I/O wait time (by user)

    DISK_READSNUMBER

    Disk read count

    DIRECT_WRITESNUMBER

    Direct write count

    BUFFER_GETSNUMBER

    Total number of buffers read in Consistent-Read mode

    PHYSICAL_READ_REQUESTSNUMBER

    Disk read request count

    PHYSICAL_READ_BYTESNUMBER

    Total number of bytes read from disks (in bytes)

    PHYSICAL_WRITE_REQUESTSNUMBER

    Disk write request count

    PHYSICAL_WRITE_BYTESNUMBER

    Total number of bytes write to disks (in bytes)

    SORTSNUMBER

    The number of sorts performed

    DISK_READ_TIMENUMBER

    Total disk read time

    TEMP_SGMT_READ_TIMENUMBER

    Total temp segment read time

    TEMP_SGMT_WRITE_TIMENUMBER

    Total temp segment write time

4.2.112. V$SQLTEXT

Displays texts of SQL statements belonging to the cursor.

  • Columns

    Column NameData TypeDescription
    HASH_VALUENUMBER

    Hash value of SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    COMMAND_TYPENUMBER

    Number code of SQL statement type

    - 0: COMMAND_TYPE_NONE

    - 1: COMMAND_TYPE_SELECT

    - 2 : COMMAND_TYPE_INSERT

    - 3: COMMAND_TYPE_UPDATE

    - 4: COMMAND_TYPE_DELETE

    - 5: COMMAND_TYPE_MERGE

    - 6: COMMAND_TYPE_CALL

    - 7: COMMAND_TYPE_MAX

    PIECENUMBER

    Number given to each text of a split SQL statement

    SQL_TEXTVARCHAR(64)

    Text of an SQL statement split into 64-byte texts

  • See also

    V$SQLTEXT2

    V$SQLTEXT_WITH_NEWLINES

    V$SQLTEXT_WITH_NEWLINES2

4.2.113. V$SQLTEXT2

Displays texts of SQL statements belonging to the cursor.

  • Columns

    Column NameData TypeDescription
    HASH_VALUENUMBER

    Hash value of SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    COMMAND_TYPENUMBER

    Number code of SQL statement type

    - 0: COMMAND_TYPE_NONE

    - 1: COMMAND_TYPE_SELECT

    - 2: COMMAND_TYPE_INSERT

    - 3: COMMAND_TYPE_UPDATE

    - 4: COMMAND_TYPE_DELETE -

    - 5: COMMAND_TYPE_MERGE

    - 6: COMMAND_TYPE_CALL

    - 7: COMMAND_TYPE_MAX

    PIECENUMBER

    Number given to each text of a split SQL statement

    SQL_TEXTVARCHAR(30000)

    Text of an SQL statement split into 65532-byte texts

  • See also

    V$SQLTEXT

    V$SQLTEXT_WITH_NEWLINES

    V$SQLTEXT_WITH_NEWLINES2

4.2.114. V$SQLTEXT_WITH_NEWLINES

Displays texts of SQL statements belonging to the cursor, without removing newline characters or blank characters.

  • Columns

    Column NameData TypeDescription
    HASH_VALUENUMBER

    Hash value of SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    COMMAND_TYPENUMBER

    Number code of SQL statement type

    - 0: COMMAND_TYPE_NONE

    - 1: COMMAND_TYPE_SELECT

    - 2: COMMAND_TYPE_INSERT

    - 3: COMMAND_TYPE_UPDATE

    - 4: COMMAND_TYPE_DELETE

    - 5: COMMAND_TYPE_MERGE

    - 6: COMMAND_TYPE_CALL

    - 7: COMMAND_TYPE_MAX

    PIECENUMBER

    Number given to each text of a split SQL statement.

    SQL_TEXTVARCHAR(64)

    Text of an SQL statement split into 64-byte texts

  • See also

    V$SQLTEXT

    V$SQLTEXT2

    V$SQLTEXT_WITH_NEWLINES2

4.2.115. V$SQLTEXT_WITH_NEWLINES2

Displays texts of SQL statements belonging to the cursor, without removing newline characters or blank characters.

  • Columns

    Column NameData TypeDescription
    HASH_VALUENUMBER

    Hash value of SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    COMMAND_TYPENUMBER

    Number code of SQL statement type

    - 0: COMMAND_TYPE_NONE

    - 1: COMMAND_TYPE_SELECT

    - 2: COMMAND_TYPE_INSERT

    - 3: COMMAND_TYPE_UPDATE

    - 4: COMMAND_TYPE_DELETE

    - 5: COMMAND_TYPE_MERGE

    - 6: COMMAND_TYPE_CALL

    - 7: COMMAND_TYPE_MAX

    PIECENUMBER

    Number given to each text of a split SQL statement.

    SQL_TEXTVARCHAR(65532)

    Text of an SQL statement split into 65532-byte texts

  • See also

    V$SQLTEXT

    V$SQLTEXT_WITH_NEWLINES

    V$SQLTEXT2

4.2.116. V$SQL_BIND_CAPTURE

Displays the values of the captured bind variables from the current session

  • Columns

    Column NameData TypeDescription
    SQL_HASH_VALUENUMBER

    The Hash value of the sql

    PLAN_HASH_VALUENUMBER

    The Hash value of the physical plan

    SQL_IDVARCHAR(13)

    The SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    USER_IDNUMBER

    The user id that performed the SQL

    NAMEVARCHAR(128)

    The name of the bind variable

    POSITIONNUMBER

    The position of the bind variable in the SQL

    TYPENUMBER

    The type number of the bind variable

    TYPE_NAMEVARCHAR(128)

    The type of the bind variable

    PRECISIONNUMBER

    The precision of the bind variable

    SCALENUMBER

    The scale of the bind variable

    LENGTHNUMBER

    The length of the bind variable

    TIME_CAPTUREDDATE

    The time when the bind variable was captured

    VALUEVARCHAR(65532)

    The value of the bind variable

4.2.117. V$SQL_BIND_CAPTURE_ALL

Displays the values of the captured bind variables from all sessions

  • Columns

    Column NameData TypeDescription
    SQL_HASH_VALUENUMBER

    The Hash value of the sql

    PLAN_HASH_VALUENUMBER

    The Hash value of the physical plan

    SQL_IDVARCHAR(13)

    The SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    USER_IDNUMBER

    The user id that performed the SQL

    NAMEVARCHAR(128)

    The name of the bind variable

    POSITIONNUMBER

    The position of the bind variable in the SQL

    TYPENUMBER

    The type number of the bind variable

    TYPE_NAMEVARCHAR(128)

    The type of the bind variable

    PRECISIONNUMBER

    The precision of the bind variable

    SCALENUMBER

    The scale of the bind variable

    LENGTHNUMBER

    The length of the bind variable

    TIME_CAPTUREDDATE

    The time when the bind variable was captured

    VALUEVARCHAR(65532)

    The value of the bind variable

4.2.118. V$SQL_EXPC_INFO

Displays information about expression execution of a physical plan

  • Columns

    Column NameData TypeDescription
    SQL_IDVARCHAR(13)

    SQL identifier

    BIND_PARAM_CNTNUMBER

    Number of bind parameters

    BIND_TYPESVARCHAR(65532)

    Type of bind parameters

    ALLOC_SIZENUMBER

    Size of memory usage

4.2.119. V$SQL_MONITOR

Shows the details of SQL statements that are currently being monitored or those that have been monitored through the real time SQL monitoring function.

  • Columns

    Column NameData TypeDescription
    STATUSVARCHAR(19)

    Shows the current execution state of the SQL statement.

    - EXECUTING: The SQL statement is currently being executed.

    - DONE (ERROR): The SQL statement generated a runtime error and was closed.

    - DONE (FIRST N ROWS): Execution completed before all rows were fetched.

    - DONE (ALL ROWS): Execution completed after all rows were fetched.

    - DONE: Completed execution of parallel slaves.

    SQL_IDVARCHAR(13)

    SQL identifier

    SQL_EXEC_STARTDATE

    The time when the execution started.

    SQL_EXEC_IDNUMBER

    Execution identifier. Identifies multiple, simultaneous SQL executions. To specify a single SQL execution, three columns; SQL_ID, SQL_EXEC_START, and SQL_EXEC_ID must be defined.

    SIDNUMBER

    Session identifier

    SESSION_SERIAL#NUMBER

    Session serial number

    SQL_PLAN_HASH_VALUENUMBER

    Hash value of the execution plan

    PX_QCSIDNUMBER

    For parallel execution slaves, this indicates the identifier of the query coordinator session.

    PX_MAXDOPNUMBER

    For parallel execution coordinators, this indicates the maximum allocated DDP value.

    PX_SERVERS_REQUESTEDNUMBER

    For parallel execution coordinators, this indicates the number of requested parallel slaves.

    PX_SERVERS_ALLOCATEDNUMBER

    For parallel execution coordinators, this indicates the number of allocated parallel slaves.

    PX_SERVER#NUMBER

    For parallel execution slaves, this indicates a logical number of slaves within a single parallel execution set.

    PX_SERVER_SETNUMBER

    Whether the parallel execution slave belongs to the producer set or the consumer set. (either 1 or 2)

    PX_SERVER_GROUPNUMBER

    For parallel execution slaves, this indicates the logical group number when queries are performed by multiple query coordinators

    MODULEVARCHAR(48)

    Name of a module specified by dbms_application_info.set_module

    ACTIONVARCHAR(32)

    Name of an action specified by dbms_application_info.set_module/action

    CLIENT_INFOVARCHAR(64)

    Name of client_info specified by dbms_application_info.set_client_info

    CLIENT_IDENTIFIERVARCHAR(64)

    Name of client identifier specified by dbms_session.set_identifier

    PROGRAMVARCHAR(48)

    Client program name

    WTHR_IDNUMBER

    Working thread identifier

    USER#NUMBER

    The current user's identifier

    USERNAMEVARCHAR(30)

    The current user's name

    SQL_TEXTVARCHAR(2000)

    Executed SQL statements (A maximum of 2000 characters)

    IS_FULL_SQLTEXTVARCHAR(1)

    Whether the value saved in the SQL_TEXT column is a full or partial SQL statement.

    ERROR_NUMBERNUMBER

    Error number when a runtime error occurs.

    ERROR_MESSAGEVARCHAR(256)

    Error messages when a runtime error occurs.

    PSM_ENTRY_OBJECT_IDNUMBER

    Object ID of the top-most PSM procedure or function on the stack.

    PSM_ENTRY_SUBPROGRAM_IDNUMBER

    The subprogram identifier of the procedure or function that was called upon entry into the PSM execution.

    PSM_OBJECT_IDNUMBER

    The object identifier of the current executed PSM

    PSM_SUBPROGRAM_IDNUMBER

    The subprogram identifier of the current executed PSM

    CPU_TIMENUMBER

    CPU time (microseconds)

    ELAPSED_TIMENUMBER

    SQL execution time (microseconds)

    FETCHESNUMBER

    Number of fetches

    APPLICATION_WAIT_TIMENUMBER

    Total amount of application wait time

    CONCURRENCY_WAIT_TIMENUMBER

    Total amount of concurrency wait time

    CLUSTER_WAIT_TIMENUMBER

    Total amount of cluster wait time

    USER_IO_WAIT_TIMENUMBER

    Total amount of I/O wait time (by user)

    DISK_READSNUMBER

    Disk read count

    DIRECT_WRITESNUMBER

    Direct disk write cnt without through buffer cache

    BUFFER_GETSNUMBER

    Total number of buffers read in Consistent-Read mode

    PHYSICAL_READ_REQUESTSNUMBER

    Disk read request count

    PHYSICAL_READ_BYTESNUMBER

    Total number of bytes read from disks (in bytes)

    PHYSICAL_WRITE_REQUESTSNUMBER

    Disk write request count

    PHYSICAL_WRITE_BYTESNUMBER

    Total number of bytes write to disks (in bytes)

4.2.120. V$SQL_PLAN

Displays information on physical plans to execute SQL statements.

  • Columns

    Column NameData TypeDescription
    HASH_VALUENUMBER

    Hash value of the SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    OPERATIONVARCHAR(128)

    Name of operation job

    OBJECT#NUMBER

    Identifier of object accessed by the job

    OBJECT_OWNERVARCHAR(128)

    Name of user who has the object

    OBJECT_NAMEVARCHAR(128)

    Object name

    OBJECT_TYPEVARCHAR(20)

    Object type

    IDNUMBER

    Number given to each job of the physical plan

    PARENT_IDNUMBER

    ID of the next execution step that operates on the output of the current step in the physical plan

    DEPTHNUMBER

    Tree level of the physical plan

    POSITIONNUMBER

    Positions between all the jobs with the same PARENT_ID

    SEARCH_COLUMNSNUMBER

    The number of keys used in index search

    COSTNUMBER

    Job cost estimated by query optimizer

    CPU_COSTNUMBER

    CPU cost of the operation as estimated by optimizer

    IO_COSTNUMBER

    I/O cost of the operation as estimated by optimizer

    CARDINALITYNUMBER

    The number of output results estimated by query optimizer

    PSTARTVARCHAR(38)

    In a partitioned table, a start partition for access

    PENDVARCHAR(38)

    In a partitioned table, an end partition for access

    OTHERSVARCHAR(4000)

    Other information specific to the execution step that users may find useful

    ACCESS_PREDICATESVARCHAR(4000)

    Predicate information to access indexes or to handle joins

    FILTER_PREDICATESVARCHAR(4000)

    Predicate information to handle filters

    ADVISED_COLNOVARCHAR(4000)

    Column number(s) recommended as indexes by the advisor for the plan's TSCAN FULL node.

4.2.121. V$SQL_PLAN_MONITOR

Displays plan level information about each SQL execution registered in V$SQL_MONITOR. Each row corresponds to a single plan operation of one SQL execution.

  • Columns

    Column NameData TypeDescription
    STATUSVARCHAR(19)

    Shows the current execution state of the SQL statement.

    - EXECUTING: The SQL statement is currently being executed.

    - DONE (ERROR): The SQL statement generated a runtime error and was closed.

    - DONE (FIRST N ROWS): Execution completed before all rows were fetched.

    - DONE (ALL ROWS): Execution completed after all rows were fetched.

    - DONE: Completed execution of parallel slaves.

    SQL_IDVARCHAR(13)

    SQL identifier

    SQL_EXEC_STARTDATE

    The time when the execution started.

    SQL_EXEC_IDNUMBER

    Execution identifier. It is necessary to identify multiple simultaneous SQL executions. To identify a single SQL execution, three columns; SQL_ID, SQL_EXEC_START, and SQL_EXEC_ID must be defined. The three column values are used to match with corresponding rows in the V$SQL_MONITOR.

    SIDNUMBER

    Session identifier

    SQL_PLAN_HASH_VALUENUMBER

    Hash value of the execution plan

    PLAN_PARENT_IDNUMBER

    Identifier of the parent plan operation of this operation

    PLAN_LINE_IDNUMBER

    Identifier of the plan operation

    PLAN_OPERATIONVARCHAR(30)

    Name of the plan operation

    PLAN_DEPTHNUMBER

    Level of the plan operation within the execution plan tree

    PLAN_POSITIONNUMBER

    Logical number among siblings within the plan execution tree

    PLAN_COSTNUMBER

    Cost of the plan operation estimated by the optimizer

    PLAN_CPU_COSTNUMBER

    CPU cost of the plan operation estimated by the optimizer

    PLAN_IO_COSTNUMBER

    I/O cost of the plan operation estimated by the optimizer

    PLAN_CARDINALITYNUMBER

    The number of rows displayed in a plan operation estimated by the optimizer

    PLAN_OBJECT_OWNERVARCHAR(30)

    Owner of the table or index used by this operation

    PLAN_OBJECT_NAMEVARCHAR(30)

    Name of the table or index used by this operation

    PLAN_OBJECT_TYPEVARCHAR(30)

    Type of object used by this operation

    PLAN_PARTITION_STARTVARCHAR(64)

    Start partition when accessing part of a partitioned object

    PLAN_PARTITION_STOPVARCHAR(64)

    End partition when accessing part of a partitioned object

    FIRST_CHANGE_TIMEDATE

    First time the operation was changed to an upper level operation

    LAST_CHANGE_TIMEDATE

    Last time the operation was changed to an upper level operation

    STARTSNUMBER

    Number of times the operation was executed. (Repeated index accesses, etc.)

    OUTPUT_ROWSNUMBER

    Number of rows produced by this operation

    PHYSICAL_READ_REQUESTSNUMBER

    Disk read count requested by this operation

    PHYSICAL_READ_BYTESNUMBER

    Total number of bytes read from disks by this operation (in bytes)

    PHYSICAL_WRITE_REQUESTSNUMBER

    Disk write count requested by this operation

    PHYSICAL_WRITE_BYTESNUMBER

    Total number of bytes write to disks by this operation (in bytes)

    WORKAREA_MEMNUMBER

    Size of private memory space occupied by this operation (in bytes)

    WORKAREA_MAX_MEMNUMBER

    Maximum value for WORKAREA_MEM

    WORKAREA_TEMPSEGNUMBER

    Sum of temporary segment size currently occupied by this operation (in bytes)

    WORKAREA_MAX_TEMPSEGNUMBER

    Maximum value for WORKAREA_TEMPSEG

4.2.122. V$SQL_PLAN_STATISTICS

Displays statistics of results of each physical plan job.

  • Columns

    Column NameData TypeDescription
    HASH_VALUENUMBER

    Hash value of the SQL statement

    PLAN_HASH_VALUENUMBER

    Hash value of the physical plan

    SQL_IDVARCHAR(13)

    SQL identifier

    CHILD_NUMBERNUMBER

    The number of this child physical plan

    IDNUMBER

    Number given to each job of the physical plan

    EXECUTIONSNUMBER

    The number of times that a particular job has been performed

    LAST_STARTSNUMBER

    The number of times that a particular job was started during the last execution

    STARTSNUMBER

    Total number of times that a particular job has been started

    LAST_OUTPUT_ROWSNUMBER

    The number of rows created in a particular job during the last execution

    OUTPUT_ROWSNUMBER

    Total number of rows created in a particular job

    LAST_LEFT_INPUT_ROWSNUMBER

    The number of rows which a particular job accepted from a left-side lower job during the last execution

    LEFT_INPUT_ROWSNUMBER

    Total number of rows which a particular job has accepted from a left-side lower job

    LAST_RIGHT_INPUT_ROWSNUMBER

    The number of rows which a particular job accepted from a right-side lower job during the last execution

    RIGHT_INPUT_ROWSNUMBER

    Total number of rows which a particular job has accepted from a right-side lower job

    LAST_CR_BUFFER_GETSNUMBER

    The number of buffers which a particular job read in Consistent-Read mode during the last execution

    CR_BUFFER_GETSNUMBER

    Total number of buffers which a particular job has read in Consistent-Read mode

    LAST_ELAPSED_TIMENUMBER

    Time for which a particular job was performed in the last execution (in milliseconds)

    ELAPSED_TIMENUMBER

    Total time for which a particular job has been performed (in milliseconds)

    LAST_MEM_USAGENUMBER

    Memory usage for a particular operation during the last execution.

    MEM_USAGENUMBER

    Total memory usage for which a particular job has been performed

    LAST_TEMP_SEGMENT_READ_CNTNUMBER

    The number of temporary segment read which a particular job was performed in the last execution

    TEMP_SEGMENT_READ_CNTNUMBER

    Total number of temporary segment read which a particular job was performed in the last execution

    LAST_TEMP_SEGMENT_WRITE_CNTNUMBER

    The number of temporary segment write which a particular job was performed in the last execution

    TEMP_SEGMENT_WRITE_CNTNUMBER

    Total number of temporary segment write which a particular job was performed in the last execution

    LAST_CU_BUFFER_GETSNUMBER

    The number of buffers which a particular job read in Current mode during the last execution

    CU_BUFFER_GETSNUMBER

    Total number of buffers which a particular job has read in Current mode

4.2.123. V$SQL_WORKAREA

Display information about work areas used by SQL cursors.

  • Columns

    Column NameData TypeDescription
    ADDRESSRAW(8)

    Address of the parent statement

    HASH_VALUENUMBER

    Hash value of the parent statement in the library cache

    SQL_IDVARCHAR(13)

    SQL identifier of the parent statement in the library cache

    WORKAREA_ADDRESSRAW(8)

    Address of the work area

    OPERATION_TYPEVARCHAR(20)

    Operation type that uses the work area

    OPERATION_IDNUMBER

    Identifier used to distinguish this operation from the execution plan

    POLICYVARCHAR(10)

    Policy that determines the work area size (MANUAL or AUTO)

    ESTIMATED_OPTIMAL_SIZENUMBER

    The minimum size (in bytes) for the work area to be executed in memory only

    ESTIMATED_ONEPASS_SIZENUMBER

    The minimum size (in bytes) of the work area, to be executed by one-time disk use

    LAST_MEMORY_USEDNUMBER

    The memory size (in bytes) that was used by the work area during the last execution

    LAST_EXECUTIONVARCHAR(10)

    The Process that the work area used during the last execution

    - OPTIMAL: optimal mode execution

    - N PASS: multi pass mode execution

    LAST_DEGREENUMBER

    Parallelization degree of the work area, during the last execution

    TOTAL_EXECUTIONSNUMBER

    Count of the number of times the work area was executed

    OPTIMAL_EXECUTIONSNUMBER

    Count of the number of times that the work area was executed in optimal mode

    ONEPASS_EXECUTIONSNUMBER

    Count of the number of times that the work area was executed in one-pass mode

    MULTIPASSES_EXECUTIONSNUMBER

    Count of the number of times that the work area was executed in multi-pass mode

    ACTIVE_TIMENUMBER

    Average time this work area is active

    MAX_TEMPSEG_SIZENUMBER

    The maximum size (in bytes) of a temporary segment, that the work area uses

    LAST_TEMPSEG_SIZENUMBER

    The temporary segment size (in bytes), that was used by the work area in the last execution

4.2.124. V$SQL_WORKAREA_HISTOGRAM

Display the cumulative work area execution statistics

  • Columns

    Column NameData TypeDescription
    LOW_OPTIMAL_SIZENUMBER

    The lower bounding value (in bytes) for the optimal size

    HIGH_OPTIMAL_SIZENUMBER

    The higher bounding value (in bytes) for the optimal size

    OPTIMAL_EXECUTIONSNUMBER

    Number of work areas with an optimal memory requirement between LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE which have been executed in optimal mode.

    ONEPASS_EXECUTIONSNUMBER

    The number of work areas that were executed in one-pass mode, within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound

    MULTIPASSES_EXECUTIONSNUMBER

    The number of work areas that were executed in multi-pass mode, within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound

    TOTAL_EXECUTIONSNUMBER

    The total number of work areas that were executed within each LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE bound

4.2.125. V$SSVR_CLIENT

Displays information of valid connection to the storage server instance.

  • Columns

    Column NameData TypeDescription
    ADDRESSVARCHAR(20)

    ITHR address number

    PORTNUMBER

    ITHR port number

    NAMEVARCHAR(128)

    DB name

    THREAD_NUMBERNUMBER

    Connection Thread number

4.2.126. V$SSVR_FLASHCACHE

Displays information of flashcaches used by the storage server instance.

  • Columns

    Column NameData TypeDescription
    FLASHCACHE_NUMBERNUMBER

    Flashcache number

    NAMEVARCHAR(32)

    Flashcache name

    PATHVARCHAR(256)

    Flashcache path (full)

    OS_BYTESNUMBER

    Flashcache size

4.2.127. V$SSVR_GRID_DISK

Displays information of grid disks.

  • Columns

    Column NameData TypeDescription
    GRID_DISK_NUMBERNUMBER

    Grid disk number

    NAMEVARCHAR(128)

    Grid disk name

    STORAGE_DISK_NUMBERNUMBER

    Storage disk number

    STORAGE_DISK_OFFSETNUMBER

    Storage disk offset

    TOTAL_BYTESNUMBER

    Grid disk size

4.2.128. V$SSVR_IOLOAD

IO load of storage server

  • Columns

    Column NameData TypeDescription
    TYPEVARCHAR(32)

    !!! No documentation yet !!!

    NAMEVARCHAR(32)

    !!! No documentation yet !!!

    READ_CNTNUMBER

    !!! No documentation yet !!!

    READ_CNT_INTERNALNUMBER

    !!! No documentation yet !!!

    READ_MBNUMBER

    !!! No documentation yet !!!

    READ_INTERNAL_MBNUMBER

    !!! No documentation yet !!!

    WRITE_CNTNUMBER

    !!! No documentation yet !!!

    WRITE_CNT_INTERNALNUMBER

    !!! No documentation yet !!!

    WRITE_MBNUMBER

    !!! No documentation yet !!!

    WRITE_INTERNAL_MBNUMBER

    !!! No documentation yet !!!

4.2.129. V$SSVR_IORM_CATEGORY_PLAN

Category Plan List used by the storage server instance

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(128)

    !!! No documentation yet !!!

    SHARE_NUMBERNUMBER

    !!! No documentation yet !!!

    LIMITNUMBER

    !!! No documentation yet !!!

    STATUSVARCHAR(8)

    !!! No documentation yet !!!

4.2.130. V$SSVR_IORM_DB_PLAN

DB Plan List used by the storage server instance

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(128)

    !!! No documentation yet !!!

    SHARE_NUMBERNUMBER

    !!! No documentation yet !!!

    LIMITNUMBER

    !!! No documentation yet !!!

    STATUSVARCHAR(8)

    !!! No documentation yet !!!

4.2.131. V$SSVR_IOSTAT

IO stat per sec of storage server

  • Columns

    Column NameData TypeDescription
    TYPEVARCHAR(32)

    !!! No documentation yet !!!

    NAMEVARCHAR(32)

    !!! No documentation yet !!!

    TPS_READNUMBER

    !!! No documentation yet !!!

    TPS_READ_INTERNALNUMBER

    !!! No documentation yet !!!

    READ_MB_secNUMBER

    !!! No documentation yet !!!

    READ_INTERNAL_MB_secNUMBER

    !!! No documentation yet !!!

    TPS_WRITENUMBER

    !!! No documentation yet !!!

    TPS_WRITE_INTERNALNUMBER

    !!! No documentation yet !!!

    WRITE_MB_secNUMBER

    !!! No documentation yet !!!

    WRITE_INTERNAL_MB_secNUMBER

    !!! No documentation yet !!!

4.2.132. V$SSVR_MEMSTAT

Memory stat of storage server

  • Columns

    Column NameData TypeDescription
    TOTAL_PGA_MEMORYNUMBER

    !!! No documentation yet !!!

    FIXED_PGA_MEMORYNUMBER

    !!! No documentation yet !!!

    USED_PGA_MEMORYNUMBER

    !!! No documentation yet !!!

    TOTAL_SHARED_MEMORYNUMBER

    !!! No documentation yet !!!

    FIXED_SHARED_MEMORYNUMBER

    !!! No documentation yet !!!

    USED_SHARED_MEMORYNUMBER

    !!! No documentation yet !!!

4.2.133. V$SSVR_SLAB_STAT

used buffer slab information of storage server

  • Columns

    Column NameData TypeDescription
    SLAB_SIZE_L1NUMBER

    buf_L1_pool slab size

    SLAB_GET_CNT_L1NUMBER

    buf_L1_pool slab get count

    TOTAL_CHUNK_CNT_L1NUMBER

    buf_L1_pool chunk count

    MAX_CHUNK_CNT_L1NUMBER

    buf_L1_pool max chunk count

    SLAB_SIZE_L2NUMBER

    buf_L2_pool slab size

    SLAB_GET_CNT_L2NUMBER

    buf_L2_pool slab get count

    TOTAL_CHUNK_CNT_L2NUMBER

    buf_L2_pool chunk count

    MAX_CHUNK_CNT_L2NUMBER

    buf_L2_pool max chunk count

    SLAB_SIZE_L3NUMBER

    buf_L3_pool slab size

    SLAB_GET_CNT_L3NUMBER

    buf_L3_pool slab get count

    TOTAL_CHUNK_CNT_L3NUMBER

    buf_L3_pool chunk count

    MAX_CHUNK_CNT_L3NUMBER

    buf_L3_pool max chunk count

4.2.134. V$SSVR_STORAGE_DISK

Displays information of storage disks used by the storage server instance.

  • Columns

    Column NameData TypeDescription
    STORAGE_DISK_NUMBERNUMBER

    Storage disk number

    NAMEVARCHAR(128)

    Storage disk name

    PATHVARCHAR(256)

    Storage disk path (full)

    OS_BYTESNUMBER

    Storage disk size

4.2.135. V$STANDBY

Displays information on the database duplication in the RDBMS Standby Cluster.

  • Columns

    Column NameData TypeDescription
    PRIMARY_ADDRVARCHAR(80)

    Host name and port number of the connection from the primary DB

    STATUSVARCHAR(40)

    Status of a thread related to standby

    PRIMARY_TSNNUMBER

    TSN updated from primary DB

    RECVED_SEQNUMBER

    Log sequence number received from primary DB

    RECVED_BLKNONUMBER

    Log block number received from primary DB

    RECVED_TSNNUMBER

    TSN of last received log block

    ACKED_SEQNUMBER

    Sequence number of the log which the standby DB reported was successfully flushed

    ACKED_BLKNONUMBER

    Block number of the log which the standby DB reported was successfully flushed

    RECOVERED_SEQNUMBER

    Log sequence number recovered by SMR of the standby DB

    RECOVERED_BLKNONUMBER

    Log block number recovered by SMR of the standby DB

    RECOVERED_TSNNUMBER

    TSN after recovered by SMR of the standby DB

    OPEN_SEQNUMBER

    Log sequence number that cannot be used to access the DB as standby

    OPEN_BLKNONUMBER

    Log block number that cannot be used to access the DB as standby

4.2.136. V$STANDBY_DEST

Displays information on the standby DB in the RDBMS Standby Cluster.

  • Columns

    Column NameData TypeDescription
    STANDBY_ADDRVARCHAR(80)

    Host name of standby DB and port number

    TYPEVARCHAR(16)

    Standby type

    - LGWR SYNC

    - LGWR ASYNC

    - ARCH ASYNC

    - LGWR PROXY

    THREAD#NUMBER

    Redo thread#

    FLAGSVARCHAR(32)

    Other information of standby

    - CONNECTED: connected

    - NOT CONNECTED: not connected

    SENT_SEQNUMBER

    Sequence number of transmitted log

    SENT_BLKNONUMBER

    Block number of transmitted log

    ACKED_SEQNUMBER

    Log sequence number reporting that the standby DB was successfully flushed

    ACKED_BLKNONUMBER

    Log block number reporting that the standby DB was successfully flushed

4.2.137. V$STANDBY_STATUS

Displays information on log duplication of the primary DB in the RDBMS Standby Cluster.

  • Columns

    Column NameData TypeDescription
    STANDBY_MODEVARCHAR(16)

    Data protection level

    FLUSHED_SEQNUMBER

    Sequence number of log flushed by the standby DB working in LGWR SYNC mode

    FLUSHED_BLKNONUMBER

    Block number of the log flushed by the standby DB working in LGWR SYNC mode

    SYNCVARCHAR(8)

    Whether or not LGWR participates in the actions of standby

    WAITINGVARCHAR(8)

    Event for which LGWR is waiting

    DETAILSVARCHAR(40)

    Details of the event for which LGWR is waiting

4.2.138. V$STATNAME

Displays the detailed information on the statistics event.

  • Columns

    Column NameData TypeDescription
    STAT#NUMBER

    Event number to obtain statistics

    NAMEVARCHAR(60)

    Event name to obtain statistics

    CLASSNUMBER

    Class number of the event

    CLASS_NAMEVARCHAR(40)

    Class name of the event

4.2.139. V$SYSSTAT

Displays statistics of a system.

  • Columns

    Column NameData TypeDescription
    STAT#NUMBER

    Event number to obtain statistics

    NAMEVARCHAR(60)

    Event name to obtain statistics

    CLASSNUMBER

    Class number of the event

    VALUENUMBER

    Value of the event (Corresponding to the event name)

4.2.140. V$SYSSTAT_VALUE

Displays values for getting statistics of a system.

  • Columns

    Column NameData TypeDescription
    STAT#NUMBER

    Event number to obtain statistics

    NAMEVARCHAR(60)

    Event name to obtain statistics

    VALUENUMBER

    Value of the event

4.2.141. V$SYSTEM_EVENT

Displays events performing in the system.

  • Columns

    Column NameData TypeDescription
    IDXNUMBER

    Event number

    NAMEVARCHAR(40)

    Name of the event

    CLASSVARCHAR(40)

    Class of the event

    DESCVARCHAR(60)

    Description of the event

    TOTAL_WAITSNUMBER

    Total number of event calls

    TOTAL_TIMEOUTSNUMBER

    The number of times that a time-out occurred in an event

    TIME_WAITEDNUMBER

    The amount of time waited for this event (msec)

    AVERAGE_WAITNUMBER

    The average amount of time waited for this event (msec)

    MAX_WAITNUMBER

    The maximum amount of time waited for this event (msec)

4.2.142. V$SYSTEM_PARAMETERS

Displays system parameter values.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(64)

    System parameter name

    VALUEVARCHAR(1024)

    System parameter value

4.2.143. V$SYS_TIME_MODEL

Displays the system-level time statistics.

  • Columns

    Column NameData TypeDescription
    STAT_IDNUMBER

    Identifier of a time statistics

    STAT_NAMEVARCHAR(64)

    Name of a time statistics

    VALUENUMBER

    Amount of time (in microseconds)

4.2.144. V$TABLESPACE

Displays information on tablespaces.

  • Columns

    Column NameData TypeDescription
    TS#NUMBER

    A serial number of tablespace

    NAMEVARCHAR(128)

    Tablespace name

    TYPEVARCHAR(4)

    Tablespace type

    - DATA

    - UNDO

    - TEMP

    BIGFILECHAR(2)

    NO in all cases

    FLASHBACK_ONCHAR(2)

    NO in all cases

4.2.145. V$TACSTAT

Displays statistics of a TAC.

  • Columns

    Column NameData TypeDescription
    STAT#NUMBER

    Event number to obtain statistics

    NAMEVARCHAR(60)

    Event name to obtain statistics

    VALUENUMBER

    Value of the event (Corresponding to the event name)

4.2.146. V$TEMPFILE

Displays temporary files in the database.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    Temporary file number

    CREATE_TSNNUMBER

    TSN that created the temporary file

    CREATE_DATEDATE

    Time that the temporary file was created

    TS#NUMBER

    Number of a tablespace including the temporary file

    RFILE#NUMBER

    Relative number of the temporary file in a tablespace

    ENABLEDCHAR(3)

    Availability (YES in all cases)

    BLOCKSNUMBER

    Size of temporary file (the number of blocks)

    CREATE_SIZENUMBER

    Temporary file size when the file was created

    NAMEVARCHAR(256)

    Path name of temporary file

4.2.147. V$TEMPSEG_OP_USAGE

Displays temporary segments usage in the server.

  • Columns

    Column NameData TypeDescription
    SEGTYPEVARCHAR(32)

    Temporary segment type

    - SORT

    - HASH

    - ANALYTIC

    - INDEX

    - DATA

    - LOBDATA

    CURRENT_EXTENTSNUMBER

    The number of extents currently allocated

    PEEK_EXTENTSNUMBER

    The peak number of extents allocated after instance boot

    MAX_ONE_OP_EXTENTSNUMBER

    The maximum number of extents allocated in single operation

4.2.148. V$TEMPSEG_USAGE

Displays temporary segments in the server.

  • Columns

    Column NameData TypeDescription
    USERNAMEVARCHAR(32)

    Name of user using the temporary segment

    SESSION_NUMNUMBER

    Number of sessions using the temporary segment

    SQL_IDNUMBER

    ID of PP cache used by the temporary segment

    TABLESPACEVARCHAR(128)

    Name of tablespace containing the temporary segment

    SEGTYPEVARCHAR(32)

    Temporary segment type

    - SORT

    - HASH

    - ANALYTIC

    - INDEX

    - DATA

    - LOBDATA

    SEGFILE#NUMBER

    Absolute number of a file containing the header block of the temporary segment

    SEGBLK#NUMBER

    Block number of the header block of the temporary segment

    EXTENTSNUMBER

    The number of extents in the temporary segment

    BLOCKSNUMBER

    The number of blocks in the temporary segment

    SEGRFNO#NUMBER

    Relative number of a file containing the header block of the temporary segment

4.2.149. V$TEMPSTAT

Displays statistics of file I/O.

  • Columns

    Column NameData TypeDescription
    FILE#NUMBER

    File number

    PHYRDSNUMBER

    The number of reading times

    PHYWRTSNUMBER

    The number of writing times

    PHYBLKRDNUMBER

    The number of read blocks

    PHYBLKWRTNUMBER

    The number of written blocks

    SINGLEBLKRDSNUMBER

    The number of times of reading a single block

    READTIMNUMBER

    Reading time (msec)

    WRITETIMNUMBER

    Writing time (msec)

    SINGLEBLKRDTIMNUMBER

    Time for which a single block was read (msec)

    AVGIOTIMNUMBER

    Average I/O time (msec)

    LSTIOTIMNUMBER

    Last I/O time (msec)

    MINIOTIMNUMBER

    Shortest I/O time (msec)

    MAXIORTMNUMBER

    Longest reading time (msec)

    MAXIOWTMNUMBER

    Longest writing time (msec)

4.2.150. V$THR_ACT_INFO

Displays information on activities of the threads.

  • Columns

    Column NameData TypeDescription
    THR_IDNUMBER

    Thread index

    THR_TYPEVARCHAR(15)

    Thread type

    THR_NAMEVARCHAR(8)

    Thread name

    THR_STATUSVARCHAR(25)

    Thread status

    PIDNUMBER

    Process id

    PROC_IDXNUMBER

    Process index

    PHY_TIDNUMBER

    Thread index within the process

    PTHREAD_IDNUMBER

    Pthread id (for pthread_kill etc.)

    CUR_ACT_CNTNUMBER

    Current activity counter

    NO_ACT_TIMENUMBER

    Elapsed time without explicit thread activity

    NO_ACT_TIME_LIMITNUMBER

    Limit of the elapsed time without explicit thread activity

    ACT_REPORTVARCHAR(3)

    Whether or not to report thread activity (on/off)

4.2.151. V$THR_EVENT

Displays events that are performed in each thread.

  • Columns

    Column NameData TypeDescription
    TIDNUMBER

    Thread ID

    IDXNUMBER

    Index of the event

    NAMEVARCHAR(40)

    Name of the event

    CLASSVARCHAR(40)

    Class of the event

    DESCVARCHAR(60)

    Description of the event

    TOTAL_WAITSNUMBER

    Total number of event calls

    TOTAL_TIMEOUTSNUMBER

    The number of times that a time-out occurred in an event

    TIME_WAITEDNUMBER

    The amount of time waited for this event (msec)

    AVERAGE_WAITNUMBER

    The average amount of time waited for this event (msec)

    MAX_WAITNUMBER

    The maximum amount of time waited for this event (msec)

4.2.152. V$TIMER

Displays information on the system timer.

  • Columns

    Column NameData TypeDescription
    TICKNUMBER

    Elapsed time since the system started

4.2.153. V$TIMEZONE_NAMES

Displays timezone names.

  • Columns

    Column NameData TypeDescription
    TZNAMEVARCHAR(40)

    Name of the timezone

    TZABBREVVARCHAR(8)

    Abbreviation of the timezone

4.2.154. V$TRANSACTION

Displays ongoing transactions.

  • Columns

    Column NameData TypeDescription
    SESS_IDNUMBER

    ID of session operation transactions

    USNNUMBER

    Number of Undo segment assigned in the transaction

    SLOTNUMBER

    Slot number of transaction in use

    WRAPNUMBER

    The number of times of reusing a transaction slot

    UEA_FILENUMBER

    Number of a file containing Undo which a transaction used most recently

    UEA_BLKNUMBER

    Number of a block containing Undo which a transaction used most recently

    UEA_SEQNUMBER

    A serial number of Undo which a transaction used most recently

    UEA_ROWNUMBER

    A row number of Undo which a transaction used most recently

    STATENUMBER

    Status of transaction

    START_TIMEDATE

    Transaction start time

    START_BASENUMBER

    Child value of transaction start TSN

    START_WRAPNUMBER

    Parent value of transaction start TSN

    START_UEXTNUMBER

    Extent number of Undo space when the transaction starts

    START_FILENUMBER

    File number of Undo space when the transaction starts

    START_BLKNUMBER

    Block number of Undo space when the transaction starts

    START_SEQNUMBER

    A serial number of Undo space when the transaction starts

    START_ROWNUMBER

    Row number of Undo space when the transaction starts

    START_INCNONUMBER

    Incarnation number of Undo space when the transaction starts

    SPACENUMBER

    Whether or not the transaction is a space management transaction

    NAMEVARCHAR(256)

    Transaction name

    PTX_USNNUMBER

    Number of Undo segment assigned to the parent transaction

    PTX_SLOTNUMBER

    Number of transaction slot in use by the parent transaction

    PTX_WRAPNUMBER

    The number of times of reusing a transaction slot in use by the parent transaction

    LOG_IONUMBER

    The number of logical io by transactions

    PHY_IONUMBER

    The number of physical io used by transactions

    CR_GETNUMBER

    The number of Consistent block gets by transactions

    RECOVERYVARCHAR(8)

    Recovery status

    - RECOVERY

    - SUSPEND

    USED_BLKNUMBER

    The number of Undo blocks used by transactions

    USED_RECNUMBER

    The number of Undo records used by transactions

    EXP_RB_TIMENUMBER

    Expectation value of rollback time

    TX_TYPEVARCHAR(20)

    Transaction type

    - LOCAL

    - XA

    - XA_RECOVERY

    - DBLINK

4.2.155. V$TSN_TIME

Displays the mapping table of TSN and time.

  • Columns

    Column NameData TypeDescription
    TSNNUMBER

    TSN

    TIMETIMESTAMP(6)

    TIMESTAMP

4.2.156. V$UNDOSTAT

Displays statistics of Undo storage.

  • Columns

    Column NameData TypeDescription
    BEGIN_TIMEDATE

    Start time of statistics

    END_TIMEDATE

    End time of statistics

    UNDO_TSNONUMBER

    Tablespace number

    UNDOBLKSNUMBER

    The number of used blocks

    TXCOUNTNUMBER

    Total number of executed transactions

    MAXCONCURRENCYNUMBER

    The largest number of concurrently executed transactions

    SNAP_TOO_OLD_CNTNUMBER

    The number of errors caused by failing to read old data

    NOSPACEERRCNTNUMBER

    The number of errors caused by lack of Undo storage space

    ACTIVEBLKSNUMBER

    The number of blocks in use

    UNEXPIREDBLKSNUMBER

    The number of non reusable blocks

    EXPIREDBLKSNUMBER

    The number of reusable blocks

4.2.157. V$UNDO_FREE_SPACE

Displays free space in block count for each UNDO tablespace.

  • Columns

    Column NameData TypeDescription
    TS_IDNUMBER

    ID of the UNDO tablespace

    TS_NAMEVARCHAR(128)

    Name of the UNDO tablespace

    TOTAL_BLOCKSNUMBER

    The total number of blocks in the UNDO tablespace

    FREE_BLOCKSNUMBER

    The number of free blocks in the UNDO tablespace

    TOTAL_SIZENUMBER

    The total size of the UNDO tablespace in bytes

    FREE_SIZENUMBER

    The free size of the UNDO tablespace in bytes

4.2.158. V$USGMT_TXENTRY

Displays undo segment transaction entry information.

  • Columns

    Column NameData TypeDescription
    USNNUMBER

    Undo segment number

    SLOTNUMBER

    Slot number of transaction entry

    WRAPNUMBER

    The number of times of reusing a transaction slot

    STATUSVARCHAR(32)

    Status information

    FLAGSVARCHAR(32)

    Other information of transaction entry

    UEA_FILENUMBER

    Number of a file containing undo which a transaction used most recently

    UEA_BLOCKNUMBER

    Number of a block containing undo which a transaction used most recently

    UEA_DBANUMBER

    Starting DBA of a transaction

    UBLKCNTNUMBER

    Used undo block count

4.2.159. V$VERSION

Displays RDBMS version information.

  • Columns

    Column NameData TypeDescription
    NAMEVARCHAR(32)

    Name of the version information

    VALUEVARCHAR(32)

    Value of the version information

    VALUEVARHCAR(256)

    Banner of the version information

4.2.160. V$WAITER_SESSION

Displays information on the sessions that wait for a lock acquisition

  • Columns

    Column NameData TypeDescription
    WAIT_SIDNUMBER

    Session ID that waits for a lock acquisition

    TYPEVARCHAR(25)

    Type of the lock

    ID1NUMBER

    First ID of the lock

    ID2NUMBER

    Second ID of the lock

    MODE_REQNUMBER

    Lock mode by which is requested

    HOLD_SIDNUMBER

    Session ID that owns the requested lock

    MODE_HELDNUMBER

    Lock mode by which is owned

4.2.161. V$WAITSTAT

Displays information on block wait events for each block type and class

  • Columns

    Column NameData TypeDescription
    CLASSVARCHAR(20)

    Block class (Block type)

    COUNTNUMBER

    The number of times waiting for the block class

    TIMENUMBER

    Total time spent waiting for the block class

4.2.162. V$WAITUSE_STAT

Displays information on block wait events

  • Columns

    Column NameData TypeDescription
    CLASSVARCHAR(20)

    Block class (Block type)

    PIN_USEVARCHAR(15)

    The pin usage of the block pin owners

    WAIT_USEVARCHAR(15)

    The pin usage of the block pin waiters

    COUNTNUMBER

    The number of times waiting for the block class and pin usage

    TIMENUMBER

    Total time spent waiting for the block class and pin usage

4.2.163. V$WAITUSE_THR_STAT

Displays information on block wait events for each block type, class, and pin usage

  • Columns

    Column NameData TypeDescription
    CLASSVARCHAR(20)

    Block class (Block type)

    PIN_USEVARCHAR(15)

    The pin usage of the buffer pin owners

    WAIT_USEVARCHAR(15)

    The pin usage of the buffer pin waiters

    COUNTNUMBER

    The number of times waiting for the block class and pin usage

    TIMENUMBER

    Total time spent waiting for the block class and pin usage