[Home] [Help] [Dependency Information]
Object Name: | WRI$_ADV_SQLT_PLAN_STATS |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000469284C00014$$ | LOB | UNIQUE | SYSAUX | |
SYS_IL0000469284C00023$$ | LOB | UNIQUE | SYSAUX | |
WRI$_ADV_SQLT_PLAN_STATS_PK | NORMAL | UNIQUE | SYSAUX | PLAN_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PLAN_ID | NUMBER | Yes | ||
PARSE_TIME | NUMBER | |||
EXEC_TIME | NUMBER | |||
CPU_TIME | NUMBER | |||
USER_IO_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 | |||
OTHER | CLOB | (4000) | ||
IO_INTERCONNECT_BYTES | NUMBER | |||
SPARE_N1 | NUMBER | |||
SPARE_N2 | NUMBER | |||
SPARE_N3 | NUMBER | |||
SPARE_N4 | NUMBER | |||
SPARE_N5 | NUMBER | |||
SPARE_C1 | VARCHAR2 | (4000) | ||
SPARE_C2 | VARCHAR2 | (4000) | ||
SPARE_C3 | CLOB | (4000) | ||
TESTEXEC_TOTAL_EXECS | NUMBER | |||
FLAGS | NUMBER | |||
SPARE_N6 | NUMBER | |||
SPARE_N7 | NUMBER | |||
SPARE_N8 | NUMBER | |||
SPARE_N9 | NUMBER | |||
SPARE_N10 | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PLAN_ID
, PARSE_TIME
, EXEC_TIME
, CPU_TIME
, USER_IO_TIME
, BUFFER_GETS
, DISK_READS
, DIRECT_WRITES
, ROWS_PROCESSED
, FETCHES
, EXECUTIONS
, END_OF_FETCH_COUNT
, OPTIMIZER_COST
, OTHER
, IO_INTERCONNECT_BYTES
, SPARE_N1
, SPARE_N2
, SPARE_N3
, SPARE_N4
, SPARE_N5
, SPARE_C1
, SPARE_C2
, SPARE_C3
, TESTEXEC_TOTAL_EXECS
, FLAGS
, SPARE_N6
, SPARE_N7
, SPARE_N8
, SPARE_N9
, SPARE_N10
FROM SYS.WRI$_ADV_SQLT_PLAN_STATS;
SYS.WRI$_ADV_SQLT_PLAN_STATS does not reference any database object
SYS.WRI$_ADV_SQLT_PLAN_STATS is referenced by following:
|
|
|