iSelfSchooling.com  Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...

 

. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |

 

Complete Syntax  |  Oracle Functions  |  PL/SQL Syntax  |  SQL Syntax  |  Tables

 

Oracle Dictionary Tables

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