[Home] [Help] [Dependency Information]
Object Name: | GV_$SQL_PLAN_MONITOR |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
CON_ID | NUMBER | |||
KEY | NUMBER | |||
STATUS | VARCHAR2 | (19) | ||
FIRST_REFRESH_TIME | DATE | |||
LAST_REFRESH_TIME | DATE | |||
FIRST_CHANGE_TIME | DATE | |||
LAST_CHANGE_TIME | DATE | |||
REFRESH_COUNT | NUMBER | |||
SID | NUMBER | |||
PROCESS_NAME | VARCHAR2 | (5) | ||
SQL_ID | VARCHAR2 | (13) | ||
SQL_EXEC_START | DATE | |||
SQL_EXEC_ID | NUMBER | |||
SQL_PLAN_HASH_VALUE | NUMBER | |||
SQL_CHILD_ADDRESS | RAW | (8) | ||
PLAN_PARENT_ID | NUMBER | |||
PLAN_LINE_ID | NUMBER | |||
PLAN_OPERATION | VARCHAR2 | (30) | ||
PLAN_OPTIONS | VARCHAR2 | (30) | ||
PLAN_OBJECT_OWNER | VARCHAR2 | (30) | ||
PLAN_OBJECT_NAME | VARCHAR2 | (30) | ||
PLAN_OBJECT_TYPE | VARCHAR2 | (20) | ||
PLAN_DEPTH | NUMBER | |||
PLAN_POSITION | NUMBER | |||
PLAN_COST | NUMBER | |||
PLAN_CARDINALITY | NUMBER | |||
PLAN_BYTES | NUMBER | |||
PLAN_TIME | NUMBER | |||
PLAN_PARTITION_START | VARCHAR2 | (64) | ||
PLAN_PARTITION_STOP | VARCHAR2 | (64) | ||
PLAN_CPU_COST | NUMBER | |||
PLAN_IO_COST | NUMBER | |||
PLAN_TEMP_SPACE | NUMBER | |||
STARTS | NUMBER | |||
OUTPUT_ROWS | NUMBER | |||
IO_INTERCONNECT_BYTES | NUMBER | |||
PHYSICAL_READ_REQUESTS | NUMBER | |||
PHYSICAL_READ_BYTES | NUMBER | |||
PHYSICAL_WRITE_REQUESTS | NUMBER | |||
PHYSICAL_WRITE_BYTES | NUMBER | |||
WORKAREA_MEM | NUMBER | |||
WORKAREA_MAX_MEM | NUMBER | |||
WORKAREA_TEMPSEG | NUMBER | |||
WORKAREA_MAX_TEMPSEG | NUMBER | |||
OTHERSTAT_GROUP_ID | NUMBER | |||
OTHERSTAT_1_ID | NUMBER | |||
OTHERSTAT_1_TYPE | NUMBER | |||
OTHERSTAT_1_VALUE | NUMBER | |||
OTHERSTAT_2_ID | NUMBER | |||
OTHERSTAT_2_TYPE | NUMBER | |||
OTHERSTAT_2_VALUE | NUMBER | |||
OTHERSTAT_3_ID | NUMBER | |||
OTHERSTAT_3_TYPE | NUMBER | |||
OTHERSTAT_3_VALUE | NUMBER | |||
OTHERSTAT_4_ID | NUMBER | |||
OTHERSTAT_4_TYPE | NUMBER | |||
OTHERSTAT_4_VALUE | NUMBER | |||
OTHERSTAT_5_ID | NUMBER | |||
OTHERSTAT_5_TYPE | NUMBER | |||
OTHERSTAT_5_VALUE | NUMBER | |||
OTHERSTAT_6_ID | NUMBER | |||
OTHERSTAT_6_TYPE | NUMBER | |||
OTHERSTAT_6_VALUE | NUMBER | |||
OTHERSTAT_7_ID | NUMBER | |||
OTHERSTAT_7_TYPE | NUMBER | |||
OTHERSTAT_7_VALUE | NUMBER | |||
OTHERSTAT_8_ID | NUMBER | |||
OTHERSTAT_8_TYPE | NUMBER | |||
OTHERSTAT_8_VALUE | NUMBER | |||
OTHERSTAT_9_ID | NUMBER | |||
OTHERSTAT_9_TYPE | NUMBER | |||
OTHERSTAT_9_VALUE | NUMBER | |||
OTHERSTAT_10_ID | NUMBER | |||
OTHERSTAT_10_TYPE | NUMBER | |||
OTHERSTAT_10_VALUE | NUMBER | |||
OTHER_XML | CLOB | (4000) | ||
PLAN_OPERATION_INACTIVE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, CON_ID
, KEY
, STATUS
, FIRST_REFRESH_TIME
, LAST_REFRESH_TIME
, FIRST_CHANGE_TIME
, LAST_CHANGE_TIME
, REFRESH_COUNT
, SID
, PROCESS_NAME
, SQL_ID
, SQL_EXEC_START
, SQL_EXEC_ID
, SQL_PLAN_HASH_VALUE
, SQL_CHILD_ADDRESS
, PLAN_PARENT_ID
, PLAN_LINE_ID
, PLAN_OPERATION
, PLAN_OPTIONS
, PLAN_OBJECT_OWNER
, PLAN_OBJECT_NAME
, PLAN_OBJECT_TYPE
, PLAN_DEPTH
, PLAN_POSITION
, PLAN_COST
, PLAN_CARDINALITY
, PLAN_BYTES
, PLAN_TIME
, PLAN_PARTITION_START
, PLAN_PARTITION_STOP
, PLAN_CPU_COST
, PLAN_IO_COST
, PLAN_TEMP_SPACE
, STARTS
, OUTPUT_ROWS
, IO_INTERCONNECT_BYTES
, PHYSICAL_READ_REQUESTS
, PHYSICAL_READ_BYTES
, PHYSICAL_WRITE_REQUESTS
, PHYSICAL_WRITE_BYTES
, WORKAREA_MEM
, WORKAREA_MAX_MEM
, WORKAREA_TEMPSEG
, WORKAREA_MAX_TEMPSEG
, OTHERSTAT_GROUP_ID
, OTHERSTAT_1_ID
, OTHERSTAT_1_TYPE
, OTHERSTAT_1_VALUE
, OTHERSTAT_2_ID
, OTHERSTAT_2_TYPE
, OTHERSTAT_2_VALUE
, OTHERSTAT_3_ID
, OTHERSTAT_3_TYPE
, OTHERSTAT_3_VALUE
, OTHERSTAT_4_ID
, OTHERSTAT_4_TYPE
, OTHERSTAT_4_VALUE
, OTHERSTAT_5_ID
, OTHERSTAT_5_TYPE
, OTHERSTAT_5_VALUE
, OTHERSTAT_6_ID
, OTHERSTAT_6_TYPE
, OTHERSTAT_6_VALUE
, OTHERSTAT_7_ID
, OTHERSTAT_7_TYPE
, OTHERSTAT_7_VALUE
, OTHERSTAT_8_ID
, OTHERSTAT_8_TYPE
, OTHERSTAT_8_VALUE
, OTHERSTAT_9_ID
, OTHERSTAT_9_TYPE
, OTHERSTAT_9_VALUE
, OTHERSTAT_10_ID
, OTHERSTAT_10_TYPE
, OTHERSTAT_10_VALUE
, OTHER_XML
, PLAN_OPERATION_INACTIVE
FROM SYS.GV_$SQL_PLAN_MONITOR;
|
|
|