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_FILESTATXS: Datafile Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_FILESTATXS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 FILE#                                  NUMBER

 CREATION_CHANGE#                       NUMBER

 FILENAME                               VARCHAR2(513)

 TS#                                    NUMBER

 TSNAME                                 VARCHAR2(30)

 BLOCK_SIZE                             NUMBER

 PHYRDS                                 NUMBER

 PHYWRTS                                NUMBER

 SINGLEBLKRDS                           NUMBER

 READTIM                                NUMBER

 WRITETIM                               NUMBER

 SINGLEBLKRDTIM                         NUMBER

 PHYBLKRD                               NUMBER

 PHYBLKWRT                              NUMBER

 WAIT_COUNT                             NUMBER

 TIME                                   NUMBER

 

DBA_HIST_INSTANCE_RECOVERY: Instance Recovery Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_INSTANCE_RECOVERY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 RECOVERY_ESTIMATED_IOS                 NUMBER

 ACTUAL_REDO_BLKS                       NUMBER

 TARGET_REDO_BLKS                       NUMBER

 LOG_FILE_SIZE_REDO_BLKS                NUMBER

 LOG_CHKPT_TIMEOUT_REDO_BLKS            NUMBER

 LOG_CHKPT_INTERVAL_REDO_BLKS           NUMBER

 FAST_START_IO_TARGET_REDO_BLK          NUMBER

 TARGET_MTTR                            NUMBER

 ESTIMATED_MTTR                         NUMBER

 CKPT_BLOCK_WRITES                      NUMBER

 OPTIMAL_LOGFILE_SIZE                   NUMBER

 ESTD_CLUSTER_AVAILABLE_TIME            NUMBER

 WRITES_MTTR                            NUMBER

 WRITES_LOGFILE_SIZE                    NUMBER

 WRITES_LOG_CHECKPOINT_SETTING          NUMBER

 WRITES_OTHER_SETTINGS                  NUMBER

 WRITES_AUTOTUNE                        NUMBER

 WRITES_FULL_THREAD_CKPT                NUMBER

 

DBA_HIST_INST_CACHE_TRANSFER: Instance Cache Transfer Historical Statistics

 

iSelfSchooling-SQL> desc DBA_HIST_INST_CACHE_TRANSFER;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 INSTANCE                               NUMBER

 CLASS                                  VARCHAR2(18)

 CR_BLOCK                               NUMBER

 CR_BUSY                                NUMBER

 CR_CONGESTED                           NUMBER

 CURRENT_BLOCK                          NUMBER

 CURRENT_BUSY                           NUMBER

 CURRENT_CONGESTED                      NUMBER

 

DBA_HIST_JAVA_POOL_ADVICE: Java Pool Advice History

 

iSelfSchooling-SQL> desc DBA_HIST_JAVA_POOL_ADVICE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 JAVA_POOL_SIZE_FOR_ESTIMATE   NOT NULL NUMBER

 JAVA_POOL_SIZE_FACTOR                  NUMBER

 ESTD_LC_SIZE                           NUMBER

 ESTD_LC_MEMORY_OBJECTS                 NUMBER

 ESTD_LC_TIME_SAVED                     NUMBER

 ESTD_LC_TIME_SAVED_FACTOR              NUMBER

 ESTD_LC_LOAD_TIME                      NUMBER

 ESTD_LC_LOAD_TIME_FACTOR               NUMBER

 ESTD_LC_MEMORY_OBJECT_HITS             NUMBER

 

DBA_HIST_LATCH: Latch Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_LATCH;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 LATCH_HASH                             NUMBER

 LATCH_NAME                             VARCHAR2(64)

 LEVEL#                                 NUMBER

 GETS                                   NUMBER

 MISSES                                 NUMBER

 SLEEPS                                 NUMBER

 IMMEDIATE_GETS                         NUMBER

 IMMEDIATE_MISSES                       NUMBER

 SPIN_GETS                              NUMBER

 SLEEP1                                 NUMBER

 SLEEP2                                 NUMBER

 SLEEP3                                 NUMBER

 SLEEP4                                 NUMBER

 WAIT_TIME                              NUMBER

 

DBA_HIST_LATCH_CHILDREN: Latch Children Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_LATCH_CHILDREN;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 LATCH_HASH                             NUMBER

 LATCH_NAME                             VARCHAR2(64)

 CHILD#                                 NUMBER

 GETS                                   NUMBER

 MISSES                                 NUMBER

 SLEEPS                                 NUMBER

 IMMEDIATE_GETS                         NUMBER

 IMMEDIATE_MISSES                       NUMBER

 SPIN_GETS                              NUMBER

 SLEEP1                                 NUMBER

 SLEEP2                                 NUMBER

 SLEEP3                                 NUMBER

 SLEEP4                                 NUMBER

 WAIT_TIME                              NUMBER

 

DBA_HIST_LATCH_MISSES_SUMMARY: Latch Misses Summary Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_LATCH_MISSES_SUMMARY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 PARENT_NAME                            VARCHAR2(50)

 WHERE_IN_CODE                          VARCHAR2(64)

 NWFAIL_COUNT                           NUMBER

 SLEEP_COUNT                            NUMBER

 WTR_SLP_COUNT                          NUMBER

 

DBA_HIST_LATCH_NAME: Latch Names

 

iSelfSchooling-SQL> desc DBA_HIST_LATCH_NAME;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DBID                          NOT NULL NUMBER

 LATCH_HASH                    NOT NULL NUMBER

 LATCH_NAME                    NOT NULL VARCHAR2(64)

 

DBA_HIST_LATCH_PARENT: Latch Parent Historical Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_LATCH_PARENT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 LATCH_HASH                             NUMBER

 LATCH_NAME                             VARCHAR2(64)

 LEVEL#                                 NUMBER

 GETS                                   NUMBER

 MISSES                                 NUMBER

 SLEEPS                                 NUMBER

 IMMEDIATE_GETS                         NUMBER

 IMMEDIATE_MISSES                       NUMBER

 SPIN_GETS                              NUMBER

 SLEEP1                                 NUMBER

 SLEEP2                                 NUMBER

 SLEEP3                                 NUMBER

 SLEEP4                                 NUMBER

 WAIT_TIME                              NUMBER

 

DBA_HIST_LIBRARYCACHE: Library Cache Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_LIBRARYCACHE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 NAMESPACE                     NOT NULL VARCHAR2(15)

 GETS                                   NUMBER

 GETHITS                                NUMBER

 PINS                                   NUMBER

 PINHITS                                NUMBER

 RELOADS                                NUMBER

 INVALIDATIONS                          NUMBER

 DLM_LOCK_REQUESTS                      NUMBER

 DLM_PIN_REQUESTS                       NUMBER

 DLM_PIN_RELEASES                       NUMBER

 DLM_INVALIDATION_REQUESTS              NUMBER

 DLM_INVALIDATIONS                      NUMBER

 

DBA_HIST_LOG: Log Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_LOG;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 GROUP#                        NOT NULL NUMBER

 THREAD#                       NOT NULL NUMBER

 SEQUENCE#                     NOT NULL NUMBER

 BYTES                                  NUMBER

 MEMBERS                                NUMBER

 ARCHIVED                               VARCHAR2(3)

 STATUS                                 VARCHAR2(16)

 FIRST_CHANGE#                          NUMBER

 FIRST_TIME                             DATE

 

DBA_HIST_METRIC_NAME: Segment Names

 

iSelfSchooling-SQL> desc DBA_HIST_METRIC_NAME;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DBID                          NOT NULL NUMBER

 GROUP_ID                      NOT NULL NUMBER

 GROUP_NAME                             VARCHAR2(64)

 METRIC_ID                     NOT NULL NUMBER

 METRIC_NAME                   NOT NULL VARCHAR2(64)

 METRIC_UNIT                   NOT NULL VARCHAR2(64)

 

DBA_HIST_MTTR_TARGET_ADVICE: Mean-Time-To-Recover Target Advice History

 

iSelfSchooling-SQL> desc DBA_HIST_MTTR_TARGET_ADVICE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 MTTR_TARGET_FOR_ESTIMATE               NUMBER

 ADVICE_STATUS                          VARCHAR2(5)

 DIRTY_LIMIT                            NUMBER

 ESTD_CACHE_WRITES                      NUMBER

 ESTD_CACHE_WRITE_FACTOR                NUMBER

 ESTD_TOTAL_WRITES                      NUMBER

 ESTD_TOTAL_WRITE_FACTOR                NUMBER

 ESTD_TOTAL_IOS                         NUMBER

 ESTD_TOTAL_IO_FACTOR                   NUMBER

 

DBA_HIST_OPTIMIZER_ENV: Optimizer Environment Information

 

iSelfSchooling-SQL> desc DBA_HIST_OPTIMIZER_ENV;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DBID                          NOT NULL NUMBER

 OPTIMIZER_ENV_HASH_VALUE      NOT NULL NUMBER

 OPTIMIZER_ENV                          RAW(1000)

 

DBA_HIST_OSSTAT: Operating System Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_OSSTAT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 STAT_ID                                NUMBER

 STAT_NAME                              VARCHAR2(64)

 VALUE                                  NUMBER

 

DBA_HIST_OSSTAT_NAME: Operating System Statistic Names

 

iSelfSchooling-SQL> desc DBA_HIST_OSSTAT_NAME;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DBID                          NOT NULL NUMBER

 STAT_ID                       NOT NULL NUMBER

 STAT_NAME                     NOT NULL VARCHAR2(64)

 

DBA_HIST_PARAMETER: Parameter Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_PARAMETER;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 PARAMETER_HASH                         NUMBER

 PARAMETER_NAME                         VARCHAR2(64)

 VALUE                                  VARCHAR2(512)

 ISDEFAULT                              VARCHAR2(9)

 ISMODIFIED                             VARCHAR2(10)

 

DBA_HIST_PARAMETER_NAME: Parameter Names

 

iSelfSchooling-SQL> desc DBA_HIST_PARAMETER_NAME;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DBID                          NOT NULL NUMBER

 PARAMETER_HASH                NOT NULL NUMBER

 PARAMETER_NAME                NOT NULL VARCHAR2(64)

 

DBA_HIST_PGASTAT: PGA Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_PGASTAT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 NAME                          NOT NULL VARCHAR2(64)

 VALUE                                  NUMBER

 

DBA_HIST_PGA_TARGET_ADVICE: PGA Target Advice History

 

iSelfSchooling-SQL> desc DBA_HIST_PGA_TARGET_ADVICE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 PGA_TARGET_FOR_ESTIMATE       NOT NULL NUMBER

 PGA_TARGET_FACTOR                      NUMBER

 ADVICE_STATUS                          VARCHAR2(3)

 BYTES_PROCESSED                        NUMBER

 ESTD_EXTRA_BYTES_RW                    NUMBER

 ESTD_PGA_CACHE_HIT_PERCENTAGE          NUMBER

 ESTD_OVERALLOC_COUNT                   NUMBER

 

DBA_HIST_PROCESS_MEM_SUMMARY: Process Memory Historical Summary Information

 

iSelfSchooling-SQL> desc DBA_HIST_PROCESS_MEM_SUMMARY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 CATEGORY                      NOT NULL VARCHAR2(15)

 NUM_PROCESSES                          NUMBER

 NON_ZERO_ALLOCS                        NUMBER

 USED_TOTAL                             NUMBER

 ALLOCATED_TOTAL                        NUMBER

 ALLOCATED_AVG                          NUMBER

 ALLOCATED_STDDEV                       NUMBER

 ALLOCATED_MAX                          NUMBER

 MAX_ALLOCATED_MAX                      NUMBER

 

DBA_HIST_RESOURCE_LIMIT: Resource Limit Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_RESOURCE_LIMIT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 RESOURCE_NAME                 NOT NULL VARCHAR2(30)

 CURRENT_UTILIZATION                    NUMBER

 MAX_UTILIZATION                        NUMBER

 INITIAL_ALLOCATION                     VARCHAR2(10)

 LIMIT_VALUE                            VARCHAR2(10)

 

DBA_HIST_ROWCACHE_SUMMARY: Row Cache Historical Statistics Information Summary

 

iSelfSchooling-SQL> desc DBA_HIST_ROWCACHE_SUMMARY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 PARAMETER                              VARCHAR2(32)

 TOTAL_USAGE                            NUMBER

 USAGE                                  NUMBER

 GETS                                   NUMBER

 GETMISSES                              NUMBER

 SCANS                                  NUMBER

 SCANMISSES                             NUMBER

 SCANCOMPLETES                          NUMBER

 MODIFICATIONS                          NUMBER

 FLUSHES                                NUMBER

 DLM_REQUESTS                           NUMBER

 DLM_CONFLICTS                          NUMBER

 DLM_RELEASES                           NUMBER

 

DBA_HIST_RULE_SET: Rule sets historical statistics information

 

iSelfSchooling-SQL> desc DBA_HIST_RULE_SET;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 OWNER                         NOT NULL VARCHAR2(30)

 NAME                          NOT NULL VARCHAR2(30)

 STARTUP_TIME                  NOT NULL DATE

 CPU_TIME                               NUMBER

 ELAPSED_TIME                           NUMBER

 EVALUATIONS                            NUMBER

 SQL_FREE_EVALUATIONS                   NUMBER

 SQL_EXECUTIONS                         NUMBER

 RELOADS                                NUMBER

 

DBA_HIST_SEG_STAT: Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_SEG_STAT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 TS#                                    NUMBER

 OBJ#                                   NUMBER

 DATAOBJ#                               NUMBER

 LOGICAL_READS_TOTAL                    NUMBER

 LOGICAL_READS_DELTA                    NUMBER

 BUFFER_BUSY_WAITS_TOTAL                NUMBER

 BUFFER_BUSY_WAITS_DELTA                NUMBER

 DB_BLOCK_CHANGES_TOTAL                 NUMBER

 DB_BLOCK_CHANGES_DELTA                 NUMBER

 PHYSICAL_READS_TOTAL                   NUMBER

 PHYSICAL_READS_DELTA                   NUMBER

 PHYSICAL_WRITES_TOTAL                  NUMBER

 PHYSICAL_WRITES_DELTA                  NUMBER

 PHYSICAL_READS_DIRECT_TOTAL            NUMBER

 PHYSICAL_READS_DIRECT_DELTA            NUMBER

 PHYSICAL_WRITES_DIRECT_TOTAL           NUMBER

 PHYSICAL_WRITES_DIRECT_DELTA           NUMBER

 ITL_WAITS_TOTAL                        NUMBER

 ITL_WAITS_DELTA                        NUMBER

 ROW_LOCK_WAITS_TOTAL                   NUMBER

 ROW_LOCK_WAITS_DELTA                   NUMBER

 GC_CR_BLOCKS_SERVED_TOTAL              NUMBER

 GC_CR_BLOCKS_SERVED_DELTA              NUMBER

 GC_CU_BLOCKS_SERVED_TOTAL              NUMBER

 GC_CU_BLOCKS_SERVED_DELTA              NUMBER

 GC_BUFFER_BUSY_TOTAL                   NUMBER

 GC_BUFFER_BUSY_DELTA                   NUMBER

 GC_CR_BLOCKS_RECEIVED_TOTAL            NUMBER

 GC_CR_BLOCKS_RECEIVED_DELTA            NUMBER

 GC_CU_BLOCKS_RECEIVED_TOTAL            NUMBER

 GC_CU_BLOCKS_RECEIVED_DELTA            NUMBER

 SPACE_USED_TOTAL                       NUMBER

 SPACE_USED_DELTA                       NUMBER

 SPACE_ALLOCATED_TOTAL                  NUMBER

 SPACE_ALLOCATED_DELTA                  NUMBER

 TABLE_SCANS_TOTAL                      NUMBER

 TABLE_SCANS_DELTA                      NUMBER

 

DBA_HIST_SEG_STAT_OBJ: Segment Names

 

iSelfSchooling-SQL> desc DBA_HIST_SEG_STAT_OBJ;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DBID                          NOT NULL NUMBER

 TS#                                    NUMBER

 OBJ#                          NOT NULL NUMBER

 DATAOBJ#                      NOT NULL NUMBER

 OWNER                         NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 SUBOBJECT_NAME                         VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(18)

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

 PARTITION_TYPE                         VARCHAR2(8)

 

DBA_HIST_SERVICE_NAME: Service Names

 

iSelfSchooling-SQL> desc DBA_HIST_SERVICE_NAME;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 DBID                          NOT NULL NUMBER

 SERVICE_NAME_HASH             NOT NULL NUMBER

 SERVICE_NAME                  NOT NULL VARCHAR2(64)

 

DBA_HIST_SERVICE_STAT: Historical Service Statistics

 

iSelfSchooling-SQL> desc DBA_HIST_SERVICE_STAT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 SERVICE_NAME_HASH                      NUMBER

 SERVICE_NAME                           VARCHAR2(64)

 STAT_ID                                NUMBER

 STAT_NAME                              VARCHAR2(64)

 VALUE                                  NUMBER

 

DBA_HIST_SERVICE_WAIT_CLASS: Historical Service Wait Class Statistics

 

iSelfSchooling-SQL> desc DBA_HIST_SERVICE_WAIT_CLASS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 SERVICE_NAME_HASH                      NUMBER

 SERVICE_NAME                           VARCHAR2(64)

 WAIT_CLASS_ID                          NUMBER

 WAIT_CLASS                             VARCHAR2(64)

 TOTAL_WAITS                            NUMBER

 TIME_WAITED                            NUMBER

 

DBA_HIST_SESSMETRIC_HISTORY: System Metrics History

 

iSelfSchooling-SQL> desc DBA_HIST_SESSMETRIC_HISTORY;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 BEGIN_TIME                    NOT NULL DATE

 END_TIME                      NOT NULL DATE

 SESSID                        NOT NULL NUMBER

 SERIAL#                       NOT NULL NUMBER

 INTSIZE                       NOT NULL NUMBER

 GROUP_ID                      NOT NULL NUMBER

 METRIC_ID                     NOT NULL NUMBER

 METRIC_NAME                   NOT NULL VARCHAR2(64)

 VALUE                         NOT NULL NUMBER

 METRIC_UNIT                   NOT NULL VARCHAR2(64)

 

DBA_HIST_SESS_TIME_STATS: CPU and I/O time for interesting (STREAMS) sessions

 

iSelfSchooling-SQL> desc DBA_HIST_SESS_TIME_STATS;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 SESSION_TYPE                  NOT NULL VARCHAR2(64)

 MIN_LOGON_TIME                         DATE

 SUM_CPU_TIME                           NUMBER

 SUM_SYS_IO_WAIT                        NUMBER

 SUM_USER_IO_WAIT                       NUMBER

 

DBA_HIST_SGA: SGA Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_SGA;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 NAME                          NOT NULL VARCHAR2(64)

 VALUE                         NOT NULL NUMBER

 

DBA_HIST_SGASTAT: SGA Pool Historical Statistics Information

 

iSelfSchooling-SQL> desc DBA_HIST_SGASTAT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 NAME                                   VARCHAR2(64)

 POOL                                   VARCHAR2(12)

 BYTES                                  NUMBER

 

DBA_HIST_SGA_TARGET_ADVICE: SGA Target Advice History

 

iSelfSchooling-SQL> desc DBA_HIST_SGA_TARGET_ADVICE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 SGA_SIZE                      NOT NULL NUMBER

 SGA_SIZE_FACTOR               NOT NULL NUMBER

 ESTD_DB_TIME                  NOT NULL NUMBER

 ESTD_PHYSICAL_READS                    NUMBER

 

DBA_HIST_SHARED_POOL_ADVICE: Shared Pool Advice History

 

iSelfSchooling-SQL> desc DBA_HIST_SHARED_POOL_ADVICE;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 SHARED_POOL_SIZE_FOR_ESTIMATE NOT NULL NUMBER

 SHARED_POOL_SIZE_FACTOR                NUMBER

 ESTD_LC_SIZE                           NUMBER

 ESTD_LC_MEMORY_OBJECTS                 NUMBER

 ESTD_LC_TIME_SAVED                     NUMBER

 ESTD_LC_TIME_SAVED_FACTOR              NUMBER

 ESTD_LC_LOAD_TIME                      NUMBER

 ESTD_LC_LOAD_TIME_FACTOR               NUMBER

 ESTD_LC_MEMORY_OBJECT_HITS             NUMBER

 

DBA_HIST_SNAPSHOT: Snapshot Information

 

iSelfSchooling-SQL> desc DBA_HIST_SNAPSHOT;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 STARTUP_TIME                  NOT NULL TIMESTAMP(3)

 BEGIN_INTERVAL_TIME           NOT NULL TIMESTAMP(3)

 END_INTERVAL_TIME             NOT NULL TIMESTAMP(3)

 SNAP_LEVEL                             NUMBER

 ERROR_COUNT                            NUMBER

 

DBA_HIST_SNAP_ERROR: Snapshot Error Information

 

iSelfSchooling-SQL> desc DBA_HIST_SNAP_ERROR;

 Name                          Null?    Type

 ----------------------------- -------- --------------------

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 ERROR_NUMBER                  NOT NULL NUMBER

 

 

 

Google
 
Web web site