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    |

ALL_  |  DBA_  |  USER_  |  GV$  |  V$  |  Others

2PC... | APP... | CAP... | EXP... | HIS... | HIS... | IND... | LOC... | OPA... | REC... | REP... | SCH... | STR... | TAB...

DBA_EXPORT_OBJECTS: Export INCLUDE and EXCLUDE object type names

iSelfSchooling-SQL> desc DBA_EXPORT_OBJECTS;

 Name                          Null?    Type

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

 HET_TYPE                      NOT NULL VARCHAR2(30)

 OBJECT_PATH                   NOT NULL VARCHAR2(200)

 COMMENTS                               VARCHAR2(2000)

 NAMED                                  CHAR(1)

DBA_EXP_FILES: Description of export files

iSelfSchooling-SQL> desc DBA_EXP_FILES;

 Name                          Null?    Type

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

 EXP_VERSION                   NOT NULL NUMBER(3)

 EXP_TYPE                               VARCHAR2(11)

 FILE_NAME                     NOT NULL VARCHAR2(100)

 USER_NAME                     NOT NULL VARCHAR2(30)

 TIMESTAMP                     NOT NULL DATE

DBA_EXP_OBJECTS: Objects that have been incrementally exported

iSelfSchooling-SQL> desc DBA_EXP_OBJECTS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 OBJECT_NAME                   NOT NULL VARCHAR2(30)

 OBJECT_TYPE                            VARCHAR2(13)

 CUMULATIVE                             DATE

 INCREMENTAL                   NOT NULL DATE

 EXPORT_VERSION                NOT NULL NUMBER(3)

DBA_EXP_VERSION: Version number of the last export session

iSelfSchooling-SQL> desc DBA_EXP_VERSION;

 Name                          Null?    Type

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

 EXP_VERSION                   NOT NULL NUMBER(3)

DBA_EXTENTS: Extents comprising all segments in the database

iSelfSchooling-SQL> desc DBA_EXTENTS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 SEGMENT_NAME                           VARCHAR2(81)

 PARTITION_NAME                         VARCHAR2(30)

 SEGMENT_TYPE                           VARCHAR2(18)

 TABLESPACE_NAME                        VARCHAR2(30)

 EXTENT_ID                              NUMBER

 FILE_ID                                NUMBER

 BLOCK_ID                               NUMBER

 BYTES                                  NUMBER

 BLOCKS                                 NUMBER

 RELATIVE_FNO                           NUMBER

DBA_EXTERNAL_LOCATIONS: Description of the external tables locations accessible to the DBA

iSelfSchooling-SQL> desc DBA_EXTERNAL_LOCATIONS;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 LOCATION                               VARCHAR2(4000)

 DIRECTORY_OWNER                        CHAR(3)

 DIRECTORY_NAME                         VARCHAR2(30)

DBA_EXTERNAL_TABLES: Description of the external tables accessible to the DBA

iSelfSchooling-SQL> desc DBA_EXTERNAL_TABLES;

 Name                          Null?    Type

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

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 TYPE_OWNER                             CHAR(3)

 TYPE_NAME                     NOT NULL VARCHAR2(30)

 DEFAULT_DIRECTORY_OWNER                CHAR(3)

 DEFAULT_DIRECTORY_NAME        NOT NULL VARCHAR2(30)

 REJECT_LIMIT                           VARCHAR2(40)

 ACCESS_TYPE                            VARCHAR2(7)

 ACCESS_PARAMETERS                      VARCHAR2(4000)

 PROPERTY                               VARCHAR2(10)

DBA_FEATURE_USAGE_STATISTICS: Database Feature Usage Statistics

iSelfSchooling-SQL> desc DBA_FEATURE_USAGE_STATISTICS;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 NAME                          NOT NULL VARCHAR2(64)

 VERSION                       NOT NULL VARCHAR2(17)

 DETECTED_USAGES               NOT NULL NUMBER

 TOTAL_SAMPLES                 NOT NULL NUMBER

 CURRENTLY_USED                         VARCHAR2(5)

 FIRST_USAGE_DATE                       DATE

 LAST_USAGE_DATE                        DATE

 AUX_COUNT                              NUMBER

 FEATURE_INFO                           CLOB

 LAST_SAMPLE_DATE                       DATE

 LAST_SAMPLE_PERIOD                     NUMBER

 SAMPLE_INTERVAL                        NUMBER

 DESCRIPTION                            VARCHAR2(128)

DBA_FGA_AUDIT_TRAIL: All fine grained audit event logs

iSelfSchooling-SQL> desc DBA_FGA_AUDIT_TRAIL;

 Name                          Null?    Type

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

 SESSION_ID                    NOT NULL NUMBER

 TIMESTAMP                              DATE

 DB_USER                                VARCHAR2(30)

 OS_USER                                VARCHAR2(255)

 USERHOST                               VARCHAR2(128)

 CLIENT_ID                              VARCHAR2(64)

 ECONTEXT_ID                            VARCHAR2(64)

 EXT_NAME                               VARCHAR2(4000)

 OBJECT_SCHEMA                          VARCHAR2(30)

 OBJECT_NAME                            VARCHAR2(128)

 POLICY_NAME                            VARCHAR2(30)

 SCN                                    NUMBER

 SQL_TEXT                               NVARCHAR2(2000)

 SQL_BIND                               NVARCHAR2(2000)

 COMMENT$TEXT                           VARCHAR2(4000)

 STATEMENT_TYPE                         VARCHAR2(7)

 EXTENDED_TIMESTAMP                     TIMESTAMP(6)

 PROXY_SESSIONID                        NUMBER

 GLOBAL_UID                             VARCHAR2(32)

 INSTANCE_NUMBER                        NUMBER

 OS_PROCESS                             VARCHAR2(16)

 TRANSACTIONID                          RAW(8)

 STATEMENTID                            NUMBER

 ENTRYID                                NUMBER

DBA_FILE_GROUPS: Details about file groups

iSelfSchooling-SQL> desc DBA_FILE_GROUPS;

 Name                          Null?    Type

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

 FILE_GROUP_OWNER              NOT NULL VARCHAR2(30)

 FILE_GROUP_NAME               NOT NULL VARCHAR2(30)

 KEEP_FILES                    NOT NULL VARCHAR2(1)

 MIN_VERSIONS                  NOT NULL NUMBER

 MAX_VERSIONS                  NOT NULL NUMBER

 RETENTION_DAYS                NOT NULL NUMBER

 CREATED                       NOT NULL TIMESTAMP(6)

 COMMENTS                               VARCHAR2(4000)

 DEFAULT_DIRECTORY                      VARCHAR2(30)

DBA_FILE_GROUP_EXPORT_INFO: Details about export information of file group versions

iSelfSchooling-SQL> desc DBA_FILE_GROUP_EXPORT_INFO;

 Name                          Null?    Type

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

 FILE_GROUP_OWNER              NOT NULL VARCHAR2(30)

 FILE_GROUP_NAME               NOT NULL VARCHAR2(30)

 VERSION_NAME                  NOT NULL VARCHAR2(30)

 VERSION                       NOT NULL NUMBER

 EXPORT_VERSION                NOT NULL VARCHAR2(30)

 PLATFORM_NAME                 NOT NULL VARCHAR2(101)

 EXPORT_TIME                   NOT NULL DATE

 EXPORT_SCN                             NUMBER

 SOURCE_GLOBAL_NAME                     VARCHAR2(128)

DBA_FILE_GROUP_FILES: Details about file group files

iSelfSchooling-SQL> desc DBA_FILE_GROUP_FILES;

 Name                          Null?    Type

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

 FILE_GROUP_OWNER              NOT NULL VARCHAR2(30)

 FILE_GROUP_NAME               NOT NULL VARCHAR2(30)

 VERSION_NAME                  NOT NULL VARCHAR2(30)

 VERSION                       NOT NULL NUMBER

 FILE_NAME                     NOT NULL VARCHAR2(512)

 FILE_DIRECTORY                NOT NULL VARCHAR2(30)

 FILE_TYPE                              VARCHAR2(32)

 FILE_SIZE                              NUMBER

 FILE_BLOCK_SIZE                        NUMBER

 COMMENTS                               VARCHAR2(4000)

DBA_FILE_GROUP_TABLES: Details about the tables in the file group repository

iSelfSchooling-SQL> desc DBA_FILE_GROUP_TABLES;

 Name                          Null?    Type

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

 FILE_GROUP_OWNER              NOT NULL VARCHAR2(30)

 FILE_GROUP_NAME               NOT NULL VARCHAR2(30)

 VERSION_NAME                  NOT NULL VARCHAR2(30)

 VERSION                       NOT NULL NUMBER

 OWNER                         NOT NULL VARCHAR2(30)

 TABLE_NAME                    NOT NULL VARCHAR2(30)

 TABLESPACE_NAME                        VARCHAR2(30)

 SCN                                    NUMBER

DBA_FILE_GROUP_TABLESPACES: Details about the transportable tablespaces in the file group repository

iSelfSchooling-SQL> desc DBA_FILE_GROUP_TABLESPACES;

 Name                          Null?    Type

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

 FILE_GROUP_OWNER              NOT NULL VARCHAR2(30)

 FILE_GROUP_NAME               NOT NULL VARCHAR2(30)

 VERSION_NAME                  NOT NULL VARCHAR2(30)

 VERSION                       NOT NULL NUMBER

 TABLESPACE_NAME               NOT NULL VARCHAR2(30)

DBA_FILE_GROUP_VERSIONS: Details about file group versions

iSelfSchooling-SQL> desc DBA_FILE_GROUP_VERSIONS;

 Name                          Null?    Type

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

 FILE_GROUP_OWNER              NOT NULL VARCHAR2(30)

 FILE_GROUP_NAME               NOT NULL VARCHAR2(30)

 VERSION_NAME                  NOT NULL VARCHAR2(30)

 VERSION                       NOT NULL NUMBER

 CREATOR                       NOT NULL VARCHAR2(30)

 CREATED                       NOT NULL TIMESTAMP(6)

 COMMENTS                               VARCHAR2(4000)

 DEFAULT_DIRECTORY                      VARCHAR2(30)

DBA_FREE_SPACE: Free extents in all tablespaces

iSelfSchooling-SQL> desc DBA_FREE_SPACE;

 Name                          Null?    Type

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

 TABLESPACE_NAME                        VARCHAR2(30)

 FILE_ID                                NUMBER

 BLOCK_ID                               NUMBER

 BYTES                                  NUMBER

 BLOCKS                                 NUMBER

 RELATIVE_FNO                           NUMBER

DBA_FREE_SPACE_COALESCED: Statistics on Coalesced Space in Tablespaces

iSelfSchooling-SQL> desc DBA_FREE_SPACE_COALESCED;

 Name                          Null?    Type

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

 TABLESPACE_NAME                        VARCHAR2(30)

 TOTAL_EXTENTS                          NUMBER

 EXTENTS_COALESCED                      NUMBER

 PERCENT_EXTENTS_COALESCED              NUMBER

 TOTAL_BYTES                            NUMBER

 BYTES_COALESCED                        NUMBER

 TOTAL_BLOCKS                           NUMBER

 BLOCKS_COALESCED                       NUMBER

 PERCENT_BLOCKS_COALESCED               NUMBER

DBA_GLOBAL_CONTEXT: Description of all context information accessible globally

iSelfSchooling-SQL> desc DBA_GLOBAL_CONTEXT;

 Name                          Null?    Type

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

 NAMESPACE                     NOT NULL VARCHAR2(30)

 SCHEMA                        NOT NULL VARCHAR2(30)

 PACKAGE                       NOT NULL VARCHAR2(30)

DBA_HIGH_WATER_MARK_STATISTICS: Database High Water Mark Statistics

iSelfSchooling-SQL> desc DBA_HIGH_WATER_MARK_STATISTICS;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 NAME                          NOT NULL VARCHAR2(64)

 VERSION                       NOT NULL VARCHAR2(17)

 HIGHWATER                              NUMBER

 LAST_VALUE                             NUMBER

 DESCRIPTION                            VARCHAR2(128)

DBA_HISTOGRAMS: Synonym for DBA_TAB_HISTOGRAMS

iSelfSchooling-SQL> desc DBA_HISTOGRAMS;

 Name                          Null?    Type

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

 OWNER                                  VARCHAR2(30)

 TABLE_NAME                             VARCHAR2(30)

 COLUMN_NAME                            VARCHAR2(4000)

 ENDPOINT_NUMBER                        NUMBER

 ENDPOINT_VALUE                         NUMBER

 ENDPOINT_ACTUAL_VALUE                  VARCHAR2(1000)

DBA_HIST_ACTIVE_SESS_HISTORY: Active Session Historical Statistics Information

iSelfSchooling-SQL> desc DBA_HIST_ACTIVE_SESS_HISTORY;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 SAMPLE_ID                              NUMBER

 SAMPLE_TIME                            TIMESTAMP(3)

 SESSION_ID                             NUMBER

 SESSION_SERIAL#                        NUMBER

 USER_ID                                NUMBER

 SQL_ID                                 VARCHAR2(13)

 SQL_CHILD_NUMBER                       NUMBER

 SQL_PLAN_HASH_VALUE                    NUMBER

 FORCE_MATCHING_SIGNATURE               NUMBER

 SQL_OPCODE                             NUMBER

 SERVICE_HASH                           NUMBER

 SESSION_TYPE                           VARCHAR2(10)

 SESSION_STATE                          VARCHAR2(7)

 QC_SESSION_ID                          NUMBER

 QC_INSTANCE_ID                         NUMBER

 BLOCKING_SESSION                       NUMBER

 BLOCKING_SESSION_STATUS                VARCHAR2(11)

 BLOCKING_SESSION_SERIAL#               NUMBER

 EVENT                                  VARCHAR2(64)

 EVENT_ID                               NUMBER

 SEQ#                                   NUMBER

 P1TEXT                                 VARCHAR2(64)

 P1                                     NUMBER

 P2TEXT                                 VARCHAR2(64)

 P2                                     NUMBER

 P3TEXT                                 VARCHAR2(64)

 P3                                     NUMBER

 WAIT_CLASS                             VARCHAR2(64)

 WAIT_CLASS_ID                          NUMBER

 WAIT_TIME                              NUMBER

 TIME_WAITED                            NUMBER

 XID                                    RAW(8)

 CURRENT_OBJ#                           NUMBER

 CURRENT_FILE#                          NUMBER

 CURRENT_BLOCK#                         NUMBER

 PROGRAM                                VARCHAR2(64)

 MODULE                                 VARCHAR2(48)

 ACTION                                 VARCHAR2(32)

 CLIENT_ID                              VARCHAR2(64)

DBA_HIST_BASELINE: Baseline Metadata Information

iSelfSchooling-SQL> desc DBA_HIST_BASELINE;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 BASELINE_ID                   NOT NULL NUMBER

 BASELINE_NAME                          VARCHAR2(64)

 START_SNAP_ID                          NUMBER

 START_SNAP_TIME                        TIMESTAMP(3)

 END_SNAP_ID                            NUMBER

 END_SNAP_TIME                          TIMESTAMP(3)

DBA_HIST_BG_EVENT_SUMMARY: Summary of Background Event Historical Statistics Information

iSelfSchooling-SQL> desc DBA_HIST_BG_EVENT_SUMMARY;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 EVENT_ID                      NOT NULL NUMBER

 EVENT_NAME                    NOT NULL VARCHAR2(64)

 WAIT_CLASS_ID                          NUMBER

 WAIT_CLASS                             VARCHAR2(64)

 TOTAL_WAITS                            NUMBER

 TOTAL_TIMEOUTS                         NUMBER

 TIME_WAITED_MICRO                      NUMBER

DBA_HIST_BUFFERED_QUEUES: STREAMS Buffered Queues Historical Statistics Information

iSelfSchooling-SQL> desc DBA_HIST_BUFFERED_QUEUES;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 QUEUE_SCHEMA                  NOT NULL VARCHAR2(30)

 QUEUE_NAME                    NOT NULL VARCHAR2(30)

 STARTUP_TIME                  NOT NULL DATE

 QUEUE_ID                      NOT NULL NUMBER

 NUM_MSGS                               NUMBER

 SPILL_MSGS                             NUMBER

 CNUM_MSGS                              NUMBER

 CSPILL_MSGS                            NUMBER

DBA_HIST_BUFFERED_SUBSCRIBERS: STREAMS Buffered Queue Subscribers Historical Statistics Information

iSelfSchooling-SQL> desc DBA_HIST_BUFFERED_SUBSCRIBERS;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 QUEUE_SCHEMA                  NOT NULL VARCHAR2(30)

 QUEUE_NAME                    NOT NULL VARCHAR2(30)

 SUBSCRIBER_ID                 NOT NULL NUMBER

 SUBSCRIBER_NAME                        VARCHAR2(30)

 SUBSCRIBER_ADDRESS                     VARCHAR2(1024)

 SUBSCRIBER_TYPE                        VARCHAR2(30)

 STARTUP_TIME                  NOT NULL DATE

 NUM_MSGS                               NUMBER

 CNUM_MSGS                              NUMBER

 TOTAL_SPILLED_MSG                      NUMBER

DBA_HIST_BUFFER_POOL_STAT: Buffer Pool Historical Statistics Information

iSelfSchooling-SQL> desc DBA_HIST_BUFFER_POOL_STAT;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 ID                            NOT NULL NUMBER

 NAME                                   VARCHAR2(20)

 BLOCK_SIZE                             NUMBER

 SET_MSIZE                              NUMBER

 CNUM_REPL                              NUMBER

 CNUM_WRITE                             NUMBER

 CNUM_SET                               NUMBER

 BUF_GOT                                NUMBER

 SUM_WRITE                              NUMBER

 SUM_SCAN                               NUMBER

 FREE_BUFFER_WAIT                       NUMBER

 WRITE_COMPLETE_WAIT                    NUMBER

 BUFFER_BUSY_WAIT                       NUMBER

 FREE_BUFFER_INSPECTED                  NUMBER

 DIRTY_BUFFERS_INSPECTED                NUMBER

 DB_BLOCK_CHANGE                        NUMBER

 DB_BLOCK_GETS                          NUMBER

 CONSISTENT_GETS                        NUMBER

 PHYSICAL_READS                         NUMBER

 PHYSICAL_WRITES                        NUMBER

DBA_HIST_COMP_IOSTAT: I/O stats aggregated on component level

iSelfSchooling-SQL> desc DBA_HIST_COMP_IOSTAT;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 COMPONENT                     NOT NULL VARCHAR2(64)

 FILE_TYPE                     NOT NULL VARCHAR2(64)

 IO_TYPE                       NOT NULL CHAR(5)

 OPERATION                     NOT NULL CHAR(5)

 BYTES                         NOT NULL NUMBER

 IO_COUNT                      NOT NULL NUMBER

DBA_HIST_CR_BLOCK_SERVER: Consistent Read Block Server Historical Statistics

iSelfSchooling-SQL> desc DBA_HIST_CR_BLOCK_SERVER;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 CR_REQUESTS                            NUMBER

 CURRENT_REQUESTS                       NUMBER

 DATA_REQUESTS                          NUMBER

 UNDO_REQUESTS                          NUMBER

 TX_REQUESTS                            NUMBER

 CURRENT_RESULTS                        NUMBER

 PRIVATE_RESULTS                        NUMBER

 ZERO_RESULTS                           NUMBER

 DISK_READ_RESULTS                      NUMBER

 FAIL_RESULTS                           NUMBER

 FAIRNESS_DOWN_CONVERTS                 NUMBER

 FAIRNESS_CLEARS                        NUMBER

 FREE_GC_ELEMENTS                       NUMBER

 FLUSHES                                NUMBER

 FLUSHES_QUEUED                         NUMBER

 FLUSH_QUEUE_FULL                       NUMBER

 FLUSH_MAX_TIME                         NUMBER

 LIGHT_WORKS                            NUMBER

 ERRORS                                 NUMBER

DBA_HIST_CURRENT_BLOCK_SERVER: Current Block Server Historical Statistics

iSelfSchooling-SQL> desc DBA_HIST_CURRENT_BLOCK_SERVER;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 PIN1                                   NUMBER

 PIN10                                  NUMBER

 PIN100                                 NUMBER

 PIN1000                                NUMBER

 PIN10000                               NUMBER

 FLUSH1                                 NUMBER

 FLUSH10                                NUMBER

 FLUSH100                               NUMBER

 FLUSH1000                              NUMBER

 FLUSH10000                             NUMBER

 WRITE1                                 NUMBER

 WRITE10                                NUMBER

 WRITE100                               NUMBER

 WRITE1000                              NUMBER

 WRITE10000                             NUMBER

DBA_HIST_DATABASE_INSTANCE: Database Instance Information

iSelfSchooling-SQL> desc DBA_HIST_DATABASE_INSTANCE;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 STARTUP_TIME                  NOT NULL TIMESTAMP(3)

 PARALLEL                      NOT NULL VARCHAR2(3)

 VERSION                       NOT NULL VARCHAR2(17)

 DB_NAME                                VARCHAR2(9)

 INSTANCE_NAME                          VARCHAR2(16)

 HOST_NAME                              VARCHAR2(64)

 LAST_ASH_SAMPLE_ID            NOT NULL NUMBER

DBA_HIST_DATAFILE: Names of Datafiles

iSelfSchooling-SQL> desc DBA_HIST_DATAFILE;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 FILE#                         NOT NULL NUMBER

 CREATION_CHANGE#              NOT NULL NUMBER

 FILENAME                      NOT NULL VARCHAR2(513)

 TS#                           NOT NULL NUMBER

 TSNAME                        NOT NULL VARCHAR2(30)

 BLOCK_SIZE                             NUMBER

DBA_HIST_DB_CACHE_ADVICE: DB Cache Advice History Information

iSelfSchooling-SQL> desc DBA_HIST_DB_CACHE_ADVICE;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 BPID                                   NUMBER

 BUFFERS_FOR_ESTIMATE                   NUMBER

 NAME                                   VARCHAR2(20)

 BLOCK_SIZE                             NUMBER

 ADVICE_STATUS                          VARCHAR2(3)

 SIZE_FOR_ESTIMATE                      NUMBER

 SIZE_FACTOR                            NUMBER

 PHYSICAL_READS                         NUMBER

 BASE_PHYSICAL_READS                    NUMBER

 ACTUAL_PHYSICAL_READS                  NUMBER

DBA_HIST_DLM_MISC: Distributed Lock Manager Miscellaneous Historical Statistics Information

iSelfSchooling-SQL> desc DBA_HIST_DLM_MISC;

 Name                          Null?    Type

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

 SNAP_ID                                NUMBER

 DBID                                   NUMBER

 INSTANCE_NUMBER                        NUMBER

 STATISTIC#                             NUMBER

 NAME                                   VARCHAR2(38)

 VALUE                                  NUMBER

DBA_HIST_ENQUEUE_STAT: Enqueue Historical Statistics Information

iSelfSchooling-SQL> desc DBA_HIST_ENQUEUE_STAT;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 EQ_TYPE                       NOT NULL VARCHAR2(2)

 REQ_REASON                    NOT NULL VARCHAR2(64)

 TOTAL_REQ#                             NUMBER

 TOTAL_WAIT#                            NUMBER

 SUCC_REQ#                              NUMBER

 FAILED_REQ#                            NUMBER

 CUM_WAIT_TIME                          NUMBER

 EVENT#                                 NUMBER

DBA_HIST_EVENT_NAME: Event Names

iSelfSchooling-SQL> desc DBA_HIST_EVENT_NAME;

 Name                          Null?    Type

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

 DBID                          NOT NULL NUMBER

 EVENT_ID                      NOT NULL NUMBER

 EVENT_NAME                    NOT NULL VARCHAR2(64)

 PARAMETER1                             VARCHAR2(64)

 PARAMETER2                             VARCHAR2(64)

 PARAMETER3                             VARCHAR2(64)

 WAIT_CLASS_ID                          NUMBER

 WAIT_CLASS                             VARCHAR2(64)

DBA_HIST_FILEMETRIC_HISTORY: File Metrics History

iSelfSchooling-SQL> desc DBA_HIST_FILEMETRIC_HISTORY;

 Name                          Null?    Type

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

 SNAP_ID                       NOT NULL NUMBER

 DBID                          NOT NULL NUMBER

 INSTANCE_NUMBER               NOT NULL NUMBER

 FILEID                        NOT NULL NUMBER

 CREATIONTIME                  NOT NULL NUMBER

 BEGIN_TIME                    NOT NULL DATE

 END_TIME                      NOT NULL DATE

 INTSIZE                       NOT NULL NUMBER

 GROUP_ID                      NOT NULL NUMBER

 AVGREADTIME                   NOT NULL NUMBER

 AVGWRITETIME                  NOT NULL NUMBER

 PHYSICALREAD                  NOT NULL NUMBER

 PHYSICALWRITE                 NOT NULL NUMBER

 PHYBLKREAD                    NOT NULL NUMBER

 PHYBLKWRITE                   NOT NULL NUMBER