|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_SCHEDULER_WINDOW_LOG: Logged information for all scheduler windows
iSelfSchooling-SQL> desc DBA_SCHEDULER_WINDOW_LOG;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NOT NULL NUMBER
LOG_DATE
TIMESTAMP(6)
WINDOW_NAME
VARCHAR2(65)
OPERATION
VARCHAR2(30)
STATUS
VARCHAR2(30)
USER_NAME
VARCHAR2(30)
CLIENT_ID
VARCHAR2(64)
GLOBAL_UID
VARCHAR2(32)
ADDITIONAL_INFO
CLOB
DBA_SCHEDULER_WINGROUP_MEMBERS:
Members
of all scheduler window groups in the database
iSelfSchooling-SQL> desc DBA_SCHEDULER_WINGROUP_MEMBERS;
Name
Null? Type
----------------------------- -------- --------------------
WINDOW_GROUP_NAME
NOT NULL VARCHAR2(30)
WINDOW_NAME
NOT NULL VARCHAR2(30)
DBA_SECONDARY_OBJECTS: All secondary objects for domain indexes
iSelfSchooling-SQL> desc DBA_SECONDARY_OBJECTS;
Name
Null? Type
----------------------------- -------- --------------------
INDEX_OWNER
NOT NULL VARCHAR2(30)
INDEX_NAME
NOT NULL VARCHAR2(30)
SECONDARY_OBJECT_OWNER
NOT NULL VARCHAR2(30)
SECONDARY_OBJECT_NAME
NOT NULL VARCHAR2(30)
DBA_SEC_RELEVANT_COLS: Security Relevant columns of all VPD policies in
the database
iSelfSchooling-SQL> desc DBA_SEC_RELEVANT_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OBJECT_OWNER
NOT NULL VARCHAR2(30)
OBJECT_NAME
NOT
NULL VARCHAR2(30)
POLICY_GROUP
NOT NULL VARCHAR2(30)
POLICY_NAME
NOT NULL VARCHAR2(30)
SEC_REL_COLUMN
NOT NULL VARCHAR2(30)
COLUMN_OPTION
VARCHAR2(8)
DBA_SEGMENTS: Storage allocated for all database segments
iSelfSchooling-SQL> desc DBA_SEGMENTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
SEGMENT_NAME
VARCHAR2(81)
PARTITION_NAME
VARCHAR2(30)
SEGMENT_TYPE
VARCHAR2(18)
TABLESPACE_NAME
VARCHAR2(30)
HEADER_FILE
NUMBER
HEADER_BLOCK
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
EXTENTS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
RELATIVE_FNO
NUMBER
BUFFER_POOL
VARCHAR2(7)
DBA_SEGMENTS_OLD: Storage allocated for all database segments
iSelfSchooling-SQL> desc DBA_SEGMENTS_OLD;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
VARCHAR2(30)
SEGMENT_NAME
VARCHAR2(81)
PARTITION_NAME
VARCHAR2(30)
SEGMENT_TYPE
VARCHAR2(18)
TABLESPACE_NAME
VARCHAR2(30)
HEADER_FILE
NUMBER
HEADER_BLOCK
NUMBER
BYTES
NUMBER
BLOCKS
NUMBER
EXTENTS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
RELATIVE_FNO
NUMBER
BUFFER_POOL
VARCHAR2(7)
DBA_SEQUENCES: Description of all SEQUENCEs in the database
iSelfSchooling-SQL> desc DBA_SEQUENCES;
Name
Null? Type
----------------------------- -------- --------------------
SEQUENCE_OWNER
NOT NULL VARCHAR2(30)
SEQUENCE_NAME
NOT NULL VARCHAR2(30)
MIN_VALUE
NUMBER
MAX_VALUE
NUMBER
INCREMENT_BY
NOT NULL NUMBER
CYCLE_FLAG
VARCHAR2(1)
ORDER_FLAG
VARCHAR2(1)
CACHE_SIZE
NOT NULL NUMBER
LAST_NUMBER
NOT NULL NUMBER
DBA_SERVER_REGISTRY
iSelfSchooling-SQL> desc DBA_SERVER_REGISTRY;
Name
Null? Type
----------------------------- -------- --------------------
COMP_ID
NOT NULL VARCHAR2(30)
COMP_NAME
VARCHAR2(255)
VERSION
VARCHAR2(30)
STATUS
VARCHAR2(11)
MODIFIED
VARCHAR2(20)
CONTROL
NOT NULL VARCHAR2(30)
SCHEMA
NOT NULL VARCHAR2(30)
PROCEDURE
VARCHAR2(61)
STARTUP
VARCHAR2(8)
PARENT_ID
VARCHAR2(30)
OTHER_SCHEMAS
VARCHAR2(4000)
DBA_SNAPSHOTS: All snapshots in the database
iSelfSchooling-SQL> desc DBA_SNAPSHOTS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
MASTER_VIEW
VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
MASTER_LINK
VARCHAR2(128)
CAN_USE_LOG
VARCHAR2(3)
UPDATABLE
VARCHAR2(3)
REFRESH_METHOD
VARCHAR2(11)
LAST_REFRESH
DATE
ERROR
NUMBER
FR_OPERATIONS
VARCHAR2(10)
CR_OPERATIONS
VARCHAR2(10)
TYPE
VARCHAR2(8)
NEXT
VARCHAR2(200)
START_WITH
DATE
REFRESH_GROUP
NUMBER
UPDATE_TRIG
VARCHAR2(30)
UPDATE_LOG
VARCHAR2(30)
QUERY
LONG
MASTER_ROLLBACK_SEG
VARCHAR2(30)
STATUS
VARCHAR2(7)
REFRESH_MODE
VARCHAR2(8)
PREBUILT
VARCHAR2(3)
DBA_SNAPSHOT_LOGS: All snapshot logs in the database
iSelfSchooling-SQL> desc DBA_SNAPSHOT_LOGS;
Name
Null? Type
----------------------------- -------- --------------------
LOG_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LOG_TABLE
VARCHAR2(30)
LOG_TRIGGER
VARCHAR2(30)
ROWIDS
VARCHAR2(3)
PRIMARY_KEY
VARCHAR2(3)
OBJECT_ID
VARCHAR2(3)
FILTER_COLUMNS
VARCHAR2(3)
SEQUENCE
VARCHAR2(3)
INCLUDE_NEW_VALUES
VARCHAR2(3)
CURRENT_SNAPSHOTS
DATE
SNAPSHOT_ID
NUMBER(38)
DBA_SNAPSHOT_LOG_FILTER_COLS:
Synonym
for DBA_MVIEW_LOG_FILTER_COLS
iSelfSchooling-SQL> desc DBA_SNAPSHOT_LOG_FILTER_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
DBA_SNAPSHOT_REFRESH_TIMES: Synonym for DBA_MVIEW_REFRESH_TIMES
iSelfSchooling-SQL> desc DBA_SNAPSHOT_REFRESH_TIMES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
NAME
NOT
NULL VARCHAR2(30)
MASTER_OWNER
VARCHAR2(30)
MASTER
VARCHAR2(30)
LAST_REFRESH
DATE
DBA_SOURCE: Source of all stored objects in the database
iSelfSchooling-SQL> desc DBA_SOURCE;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
TYPE
VARCHAR2(12)
LINE
NUMBER
TEXT
VARCHAR2(4000)
DBA_SOURCE_TABLES: Source tables available for Change Data Capture
iSelfSchooling-SQL> desc DBA_SOURCE_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
|