ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_HIST_SQLBIND: SQL Bind Information
iSelfSchooling-SQL> desc DBA_HIST_SQLBIND;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID NUMBER
INSTANCE_NUMBER
NUMBER
SQL_ID
VARCHAR2(13)
NAME
VARCHAR2(30)
POSITION
NUMBER
DUP_POSITION
NUMBER
DATATYPE
NUMBER
DATATYPE_STRING
VARCHAR2(15)
CHARACTER_SID
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
MAX_LENGTH
NUMBER
WAS_CAPTURED
VARCHAR2(3)
LAST_CAPTURED
DATE
VALUE_STRING
VARCHAR2(4000)
VALUE_ANYDATA
ANYDATA
DBA_HIST_SQLSTAT: SQL Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_SQLSTAT;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NUMBER
DBID
NUMBER
INSTANCE_NUMBER
NUMBER
SQL_ID
VARCHAR2(13)
PLAN_HASH_VALUE
NUMBER
OPTIMIZER_COST
NUMBER
OPTIMIZER_MODE
VARCHAR2(10)
OPTIMIZER_ENV_HASH_VALUE
NUMBER
SHARABLE_MEM
NUMBER
LOADED_VERSIONS
NUMBER
VERSION_COUNT
NUMBER
MODULE
VARCHAR2(64)
ACTION
VARCHAR2(64)
SQL_PROFILE
VARCHAR2(64)
FORCE_MATCHING_SIGNATURE
NUMBER
PARSING_SCHEMA_ID
NUMBER
PARSING_SCHEMA_NAME
VARCHAR2(30)
FETCHES_TOTAL
NUMBER
FETCHES_DELTA
NUMBER
END_OF_FETCH_COUNT_TOTAL
NUMBER
END_OF_FETCH_COUNT_DELTA
NUMBER
SORTS_TOTAL
NUMBER
SORTS_DELTA
NUMBER
EXECUTIONS_TOTAL
NUMBER
EXECUTIONS_DELTA
NUMBER
PX_SERVERS_EXECS_TOTAL
NUMBER
PX_SERVERS_EXECS_DELTA
NUMBER
LOADS_TOTAL
NUMBER
LOADS_DELTA
NUMBER
INVALIDATIONS_TOTAL
NUMBER
INVALIDATIONS_DELTA
NUMBER
PARSE_CALLS_TOTAL
NUMBER
PARSE_CALLS_DELTA
NUMBER
DISK_READS_TOTAL
NUMBER
DISK_READS_DELTA
NUMBER
BUFFER_GETS_TOTAL
NUMBER
BUFFER_GETS_DELTA
NUMBER
ROWS_PROCESSED_TOTAL
NUMBER
ROWS_PROCESSED_DELTA
NUMBER
CPU_TIME_TOTAL
NUMBER
CPU_TIME_DELTA
NUMBER
ELAPSED_TIME_TOTAL
NUMBER
ELAPSED_TIME_DELTA
NUMBER
IOWAIT_TOTAL
NUMBER
IOWAIT_DELTA
NUMBER
CLWAIT_TOTAL
NUMBER
CLWAIT_DELTA
NUMBER
APWAIT_TOTAL
NUMBER
APWAIT_DELTA
NUMBER
CCWAIT_TOTAL
NUMBER
CCWAIT_DELTA
NUMBER
DIRECT_WRITES_TOTAL
NUMBER
DIRECT_WRITES_DELTA
NUMBER
PLSEXEC_TIME_TOTAL
NUMBER
PLSEXEC_TIME_DELTA
NUMBER
JAVEXEC_TIME_TOTAL
NUMBER
JAVEXEC_TIME_DELTA
NUMBER
BIND_DATA
RAW(2000)
DBA_HIST_SQLTEXT: SQL Text
iSelfSchooling-SQL> desc DBA_HIST_SQLTEXT;
Name
Null?
Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
SQL_ID
NOT NULL VARCHAR2(13)
SQL_TEXT
CLOB
COMMAND_TYPE
NUMBER
DBA_HIST_SQL_BIND_METADATA: SQL Bind Metadata Information
iSelfSchooling-SQL> desc DBA_HIST_SQL_BIND_METADATA;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT
NULL NUMBER
SQL_ID
NOT NULL VARCHAR2(13)
NAME
VARCHAR2(30)
POSITION
NOT NULL NUMBER
DUP_POSITION
NUMBER
DATATYPE
NUMBER
DATATYPE_STRING
VARCHAR2(15)
CHARACTER_SID
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
MAX_LENGTH
NUMBER
DBA_HIST_SQL_PLAN: SQL Plan Information
iSelfSchooling-SQL> desc DBA_HIST_SQL_PLAN;
Name
Null? Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
SQL_ID
NOT
NULL VARCHAR2(13)
PLAN_HASH_VALUE
NOT NULL NUMBER
ID
NOT NULL NUMBER
OPERATION
VARCHAR2(30)
OPTIONS
VARCHAR2(30)
OBJECT_NODE
VARCHAR2(128)
OBJECT#
NUMBER
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(31)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_TYPE
VARCHAR2(20)
OPTIMIZER
VARCHAR2(20)
PARENT_ID
NUMBER
DEPTH
NUMBER
POSITION
NUMBER
SEARCH_COLUMNS
NUMBER
COST
NUMBER
CARDINALITY
NUMBER
BYTES
NUMBER
OTHER_TAG
VARCHAR2(35)
PARTITION_START
VARCHAR2(5)
PARTITION_STOP
VARCHAR2(5)
PARTITION_ID
NUMBER
OTHER
VARCHAR2(4000)
DISTRIBUTION
VARCHAR2(20)
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(31)
REMARKS
VARCHAR2(4000)
TIMESTAMP
DATE
OTHER_XML
CLOB
DBA_HIST_SQL_SUMMARY: Summary of SQL Statistics
iSelfSchooling-SQL> desc DBA_HIST_SQL_SUMMARY;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
TOTAL_SQL
NOT NULL NUMBER
TOTAL_SQL_MEM
NOT NULL NUMBER
SINGLE_USE_SQL
NOT NULL NUMBER
SINGLE_USE_SQL_MEM
NOT NULL NUMBER
DBA_HIST_SQL_WORKAREA_HSTGRM:
SQL
Workarea Histogram History
iSelfSchooling-SQL> desc DBA_HIST_SQL_WORKAREA_HSTGRM;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
LOW_OPTIMAL_SIZE
NOT NULL NUMBER
HIGH_OPTIMAL_SIZE
NOT NULL NUMBER
OPTIMAL_EXECUTIONS
NUMBER
ONEPASS_EXECUTIONS
NUMBER
MULTIPASSES_EXECUTIONS
NUMBER
TOTAL_EXECUTIONS
NUMBER
DBA_HIST_STAT_NAME: Statistic Names
iSelfSchooling-SQL> desc DBA_HIST_STAT_NAME;
Name
Null?
Type
----------------------------- -------- --------------------
DBID
NOT NULL NUMBER
STAT_ID
NOT NULL NUMBER
STAT_NAME
NOT NULL VARCHAR2(64)
DBA_HIST_STREAMS_APPLY_SUM: STREAMS Apply Historical Statistics Information
iSelfSchooling-SQL> desc DBA_HIST_STREAMS_APPLY_SUM;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
APPLY_NAME
NOT NULL VARCHAR2(30)
STARTUP_TIME
NOT NULL DATE
READER_TOTAL_MESSAGES_DEQUEUE NUMBER
READER_LAG
NUMBER
COORD_TOTAL_RECEIVED
NUMBER
COORD_TOTAL_APPLIED
NUMBER
COORD_TOTAL_ROLLBACKS
NUMBER
COORD_TOTAL_WAIT_DEPS
NUMBER
COORD_TOTAL_WAIT_CMTS
NUMBER
COORD_LWM_LAG
NUMBER
SERVER_TOTAL_MESSAGES_APPLIED NUMBER
SERVER_ELAPSED_DEQUEUE_TIME NUMBER
SERVER_ELAPSED_APPLY_TIME
NUMBER
DBA_HIST_STREAMS_CAPTURE: STREAMS Capture Historical Statistics
Information
iSelfSchooling-SQL> desc DBA_HIST_STREAMS_CAPTURE;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT
NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
CAPTURE_NAME
NOT NULL VARCHAR2(30)
STARTUP_TIME
NOT NULL DATE
LAG
NUMBER
TOTAL_MESSAGES_CAPTURED
NUMBER
TOTAL_MESSAGES_ENQUEUED
NUMBER
ELAPSED_RULE_TIME
NUMBER
ELAPSED_ENQUEUE_TIME
NUMBER
ELAPSED_REDO_WAIT_TIME
NUMBER
ELAPSED_PAUSE_TIME
NUMBER
DBA_HIST_STREAMS_POOL_ADVICE:
Streams
Pool Advice History
iSelfSchooling-SQL> desc DBA_HIST_STREAMS_POOL_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
SNAP_ID
NOT NULL NUMBER
DBID
NOT NULL NUMBER
INSTANCE_NUMBER
NOT NULL NUMBER
SIZE_FOR_ESTIMATE
NOT NULL NUMBER
SIZE_FACTOR
NUMBER
ESTD_SPILL_COUNT
NUMBER
ESTD_SPILL_TIME
NUMBER
ESTD_UNSPILL_COUNT
NUMBER
ESTD_UNSPILL_TIME &nbs |