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
|