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

VIEW: SYS._ALL_SQLSET_STATISTICS_ONLY

Object Details
Object Name: _ALL_SQLSET_STATISTICS_ONLY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SQLSET_ID NUMBER
Yes
CON_DBID NUMBER
Yes
SQL_SEQ NUMBER
Yes
PLAN_HASH_VALUE NUMBER
Yes
ELAPSED_TIME NUMBER

CPU_TIME NUMBER

BUFFER_GETS NUMBER

DISK_READS NUMBER

DIRECT_WRITES NUMBER

ROWS_PROCESSED NUMBER

FETCHES NUMBER

EXECUTIONS NUMBER

END_OF_FETCH_COUNT NUMBER

OPTIMIZER_COST NUMBER

FIRST_LOAD_TIME VARCHAR2 (19)
STAT_PERIOD NUMBER

ACTIVE_STAT_PERIOD NUMBER

PLAN_TIMESTAMP DATE

BINDS_CAPTURED CHAR (1)
Query Text

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


SELECT SQLSET_ID
,      CON_DBID
,      SQL_SEQ
,      PLAN_HASH_VALUE
,      ELAPSED_TIME
,      CPU_TIME
,      BUFFER_GETS
,      DISK_READS
,      DIRECT_WRITES
,      ROWS_PROCESSED
,      FETCHES
,      EXECUTIONS
,      END_OF_FETCH_COUNT
,      OPTIMIZER_COST
,      FIRST_LOAD_TIME
,      STAT_PERIOD
,      ACTIVE_STAT_PERIOD
,      PLAN_TIMESTAMP
,      BINDS_CAPTURED
FROM SYS._ALL_SQLSET_STATISTICS_ONLY;

Dependencies

[top of page]

SYS._ALL_SQLSET_STATISTICS_ONLY references the following:

SchemaSYS
TableWRI$_SQLSET_DEFINITIONS
TableWRI$_SQLSET_PLANS
TableWRI$_SQLSET_STATEMENTS
TableWRI$_SQLSET_STATISTICS
SYS._ALL_SQLSET_STATISTICS_ONLY is referenced by following:

SchemaPUBLIC
Synonym_ALL_SQLSET_STATISTICS_ONLY
SchemaSYS
Package BodyPRVT_SQLPA - show dependent code