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

VIEW: SYS.V_$ADVISOR_CURRENT_SQLPLAN

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TIMESTAMP DATE

OPERATION VARCHAR2 (64)
OPTIONS VARCHAR2 (64)
OBJECT_NODE VARCHAR2 (128)
OBJECT# NUMBER

OBJECT_OWNER VARCHAR2 (30)
OBJECT_NAME VARCHAR2 (30)
OBJECT_ALIAS VARCHAR2 (65)
OBJECT_TYPE VARCHAR2 (64)
OPTIMIZER VARCHAR2 (64)
ID NUMBER

PARENT_ID NUMBER

DEPTH NUMBER

POSITION NUMBER

SEARCH_COLUMNS NUMBER

COST NUMBER

CARDINALITY NUMBER

BYTES NUMBER

OTHER_TAG VARCHAR2 (64)
PARTITION_START VARCHAR2 (64)
PARTITION_STOP VARCHAR2 (64)
PARTITION_ID NUMBER

OTHER VARCHAR2 (4000)
DISTRIBUTION VARCHAR2 (64)
CPU_COST NUMBER

IO_COST NUMBER

TEMP_SPACE NUMBER

ACCESS_PREDICATES VARCHAR2 (4000)
FILTER_PREDICATES VARCHAR2 (4000)
PROJECTION VARCHAR2 (4000)
TIME NUMBER

QBLOCK_NAME VARCHAR2 (30)
REMARKS VARCHAR2 (4000)
OTHER_XML CLOB (4000)
CON_ID NUMBER

Query Text

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


SELECT TIMESTAMP
,      OPERATION
,      OPTIONS
,      OBJECT_NODE
,      OBJECT#
,      OBJECT_OWNER
,      OBJECT_NAME
,      OBJECT_ALIAS
,      OBJECT_TYPE
,      OPTIMIZER
,      ID
,      PARENT_ID
,      DEPTH
,      POSITION
,      SEARCH_COLUMNS
,      COST
,      CARDINALITY
,      BYTES
,      OTHER_TAG
,      PARTITION_START
,      PARTITION_STOP
,      PARTITION_ID
,      OTHER
,      DISTRIBUTION
,      CPU_COST
,      IO_COST
,      TEMP_SPACE
,      ACCESS_PREDICATES
,      FILTER_PREDICATES
,      PROJECTION
,      TIME
,      QBLOCK_NAME
,      REMARKS
,      OTHER_XML
,      CON_ID
FROM SYS.V_$ADVISOR_CURRENT_SQLPLAN;

Dependencies

[top of page]

SYS.V_$ADVISOR_CURRENT_SQLPLAN references the following:

SYS.V_$ADVISOR_CURRENT_SQLPLAN is referenced by following:

SchemaPUBLIC
SynonymV$ADVISOR_CURRENT_SQLPLAN