DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.V_$SQL_MONITOR

Object Details
Object Name: V_$SQL_MONITOR
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
KEY NUMBER

REPORT_ID NUMBER

STATUS VARCHAR2 (19)
USER# NUMBER

USERNAME VARCHAR2 (30)
MODULE VARCHAR2 (64)
ACTION VARCHAR2 (64)
SERVICE_NAME VARCHAR2 (64)
CLIENT_IDENTIFIER VARCHAR2 (64)
CLIENT_INFO VARCHAR2 (64)
PROGRAM VARCHAR2 (48)
PLSQL_ENTRY_OBJECT_ID NUMBER

PLSQL_ENTRY_SUBPROGRAM_ID NUMBER

PLSQL_OBJECT_ID NUMBER

PLSQL_SUBPROGRAM_ID NUMBER

FIRST_REFRESH_TIME DATE

LAST_REFRESH_TIME DATE

REFRESH_COUNT NUMBER

DBOP_EXEC_ID NUMBER

DBOP_NAME VARCHAR2 (30)
SID NUMBER

PROCESS_NAME VARCHAR2 (5)
SQL_ID VARCHAR2 (13)
SQL_TEXT VARCHAR2 (2000)
IS_FULL_SQLTEXT VARCHAR2 (1)
SQL_EXEC_START DATE

SQL_EXEC_ID NUMBER

SQL_PLAN_HASH_VALUE NUMBER

SQL_FULL_PLAN_HASH_VALUE NUMBER

EXACT_MATCHING_SIGNATURE NUMBER

FORCE_MATCHING_SIGNATURE NUMBER

SQL_CHILD_ADDRESS RAW (8)
SESSION_SERIAL# NUMBER

PX_IS_CROSS_INSTANCE VARCHAR2 (1)
PX_MAXDOP NUMBER

PX_MAXDOP_INSTANCES NUMBER

PX_SERVERS_REQUESTED NUMBER

PX_SERVERS_ALLOCATED NUMBER

PX_SERVER# NUMBER

PX_SERVER_GROUP NUMBER

PX_SERVER_SET NUMBER

PX_QCINST_ID NUMBER

PX_QCSID NUMBER

ERROR_NUMBER VARCHAR2 (40)
ERROR_FACILITY VARCHAR2 (4)
ERROR_MESSAGE VARCHAR2 (256)
BINDS_XML CLOB (4000)
OTHER_XML CLOB (4000)
ELAPSED_TIME NUMBER

QUEUING_TIME NUMBER

CPU_TIME NUMBER

FETCHES NUMBER

BUFFER_GETS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

IO_INTERCONNECT_BYTES NUMBER

PHYSICAL_READ_REQUESTS NUMBER

PHYSICAL_READ_BYTES NUMBER

PHYSICAL_WRITE_REQUESTS NUMBER

PHYSICAL_WRITE_BYTES NUMBER

APPLICATION_WAIT_TIME NUMBER

CONCURRENCY_WAIT_TIME NUMBER

CLUSTER_WAIT_TIME NUMBER

USER_IO_WAIT_TIME NUMBER

PLSQL_EXEC_TIME NUMBER

JAVA_EXEC_TIME NUMBER

RM_LAST_ACTION VARCHAR2 (48)
RM_LAST_ACTION_REASON VARCHAR2 (30)
RM_LAST_ACTION_TIME DATE

RM_CONSUMER_GROUP VARCHAR2 (30)
CON_ID NUMBER

CON_NAME VARCHAR2 (30)
ECID VARCHAR2 (64)
IS_ADAPTIVE_PLAN VARCHAR2 (1)
IS_FINAL_PLAN VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT KEY
,      REPORT_ID
,      STATUS
,      USER#
,      USERNAME
,      MODULE
,      ACTION
,      SERVICE_NAME
,      CLIENT_IDENTIFIER
,      CLIENT_INFO
,      PROGRAM
,      PLSQL_ENTRY_OBJECT_ID
,      PLSQL_ENTRY_SUBPROGRAM_ID
,      PLSQL_OBJECT_ID
,      PLSQL_SUBPROGRAM_ID
,      FIRST_REFRESH_TIME
,      LAST_REFRESH_TIME
,      REFRESH_COUNT
,      DBOP_EXEC_ID
,      DBOP_NAME
,      SID
,      PROCESS_NAME
,      SQL_ID
,      SQL_TEXT
,      IS_FULL_SQLTEXT
,      SQL_EXEC_START
,      SQL_EXEC_ID
,      SQL_PLAN_HASH_VALUE
,      SQL_FULL_PLAN_HASH_VALUE
,      EXACT_MATCHING_SIGNATURE
,      FORCE_MATCHING_SIGNATURE
,      SQL_CHILD_ADDRESS
,      SESSION_SERIAL#
,      PX_IS_CROSS_INSTANCE
,      PX_MAXDOP
,      PX_MAXDOP_INSTANCES
,      PX_SERVERS_REQUESTED
,      PX_SERVERS_ALLOCATED
,      PX_SERVER#
,      PX_SERVER_GROUP
,      PX_SERVER_SET
,      PX_QCINST_ID
,      PX_QCSID
,      ERROR_NUMBER
,      ERROR_FACILITY
,      ERROR_MESSAGE
,      BINDS_XML
,      OTHER_XML
,      ELAPSED_TIME
,      QUEUING_TIME
,      CPU_TIME
,      FETCHES
,      BUFFER_GETS
,      DISK_READS
,      DIRECT_WRITES
,      IO_INTERCONNECT_BYTES
,      PHYSICAL_READ_REQUESTS
,      PHYSICAL_READ_BYTES
,      PHYSICAL_WRITE_REQUESTS
,      PHYSICAL_WRITE_BYTES
,      APPLICATION_WAIT_TIME
,      CONCURRENCY_WAIT_TIME
,      CLUSTER_WAIT_TIME
,      USER_IO_WAIT_TIME
,      PLSQL_EXEC_TIME
,      JAVA_EXEC_TIME
,      RM_LAST_ACTION
,      RM_LAST_ACTION_REASON
,      RM_LAST_ACTION_TIME
,      RM_CONSUMER_GROUP
,      CON_ID
,      CON_NAME
,      ECID
,      IS_ADAPTIVE_PLAN
,      IS_FINAL_PLAN
FROM SYS.V_$SQL_MONITOR;

Dependencies

[top of page]

SYS.V_$SQL_MONITOR references the following:

SYS.V_$SQL_MONITOR is referenced by following:

SchemaPUBLIC
SynonymV$SQL_MONITOR