VIEW: SYS.V_$SQL_MONITOR

Source

View Text - Preformatted

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 v$sql_monitor

View Text - HTML Formatted

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 V$SQL_MONITOR