eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.GV_$SQL_PLAN_MONITOR

Object Details

Object Name:	GV_$SQL_PLAN_MONITOR
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
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

Query Text

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;

Dependencies

[top of page]

SYS.GV_$SQL_PLAN_MONITOR references the following:

SYS.GV_$SQL_PLAN_MONITOR is referenced by following:

PUBLIC: GV$SQL_PLAN_MONITOR