ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
2PC...
| APP...
| CAP...
| EXP...
| HIS...
| HIS...
| IND...
| LOC...
| OPA...
| REC...
| REP...
| SCH...
| STR...
| TAB...
DBA_STREAMS_NEWLY_SUPPORTED: List of tables that are newly supported by
Streams
iSelfSchooling-SQL> desc DBA_STREAMS_NEWLY_SUPPORTED;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
REASON
VARCHAR2(39)
COMPATIBLE
CHAR(4)
DBA_STREAMS_RENAME_COLUMN: Rename column transformations
iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_COLUMN;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
SCHEMA_NAME
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
FROM_COLUMN_NAME
VARCHAR2(4000)
TO_COLUMN_NAME
VARCHAR2(4000)
VALUE_TYPE
VARCHAR2(3)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_RENAME_SCHEMA: Rename schema transformations
iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_SCHEMA;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
FROM_SCHEMA_NAME
VARCHAR2(30)
TO_SCHEMA_NAME
VARCHAR2(30)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_RENAME_TABLE: Rename table transformations
iSelfSchooling-SQL> desc DBA_STREAMS_RENAME_TABLE;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
FROM_SCHEMA_NAME
VARCHAR2(30)
TO_SCHEMA_NAME
VARCHAR2(30)
FROM_TABLE_NAME
VARCHAR2(30)
TO_TABLE_NAME
VARCHAR2(30)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_RULES: Rules used by Streams processes
iSelfSchooling-SQL> desc DBA_STREAMS_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_TYPE
VARCHAR2(11)
STREAMS_NAME
VARCHAR2(30)
RULE_SET_OWNER VARCHAR2(30)
RULE_SET_NAME
VARCHAR2(30)
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
RULE_CONDITION
CLOB
RULE_SET_TYPE CHAR(8)
STREAMS_RULE_TYPE
VARCHAR2(6)
SCHEMA_NAME
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
SUBSETTING_OPERATION
VARCHAR2(6)
DML_CONDITION
VARCHAR2(4000)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_TYPE
VARCHAR2(3)
MESSAGE_TYPE_OWNER
VARCHAR2(30)
MESSAGE_TYPE_NAME
VARCHAR2(30)
MESSAGE_RULE_VARIABLE
VARCHAR2(30)
ORIGINAL_RULE_CONDITION
VARCHAR2(4000)
SAME_RULE_CONDITION
VARCHAR2(3)
DBA_STREAMS_SCHEMA_RULES: Schema rules created by streams administrative
APIs
iSelfSchooling-SQL> desc DBA_STREAMS_SCHEMA_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
SCHEMA_NAME
VARCHAR2(30)
RULE_TYPE
VARCHAR2(7)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_NAME
VARCHAR2(30)
RULE_OWNER
VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
DBA_STREAMS_TABLE_RULES: Table rules created by streams administrative
APIs
iSelfSchooling-SQL> desc DBA_STREAMS_TABLE_RULES;
Name
Null? Type
----------------------------- -------- --------------------
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(11)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
RULE_TYPE
VARCHAR2(7)
DML_CONDITION
VARCHAR2(4000)
SUBSETTING_OPERATION
VARCHAR2(6)
INCLUDE_TAGGED_LCR
VARCHAR2(3)
SOURCE_DATABASE
VARCHAR2(128)
RULE_NAME
VARCHAR2(30)
RULE_OWNER
VARCHAR2(30)
RULE_CONDITION
VARCHAR2(4000)
DBA_STREAMS_TRANSFORMATIONS: Transformations defined on rules
iSelfSchooling-SQL> desc DBA_STREAMS_TRANSFORMATIONS;
Name
Null? Type
----------------------------- -------- --------------------
RULE_OWNER
VARCHAR2(30)
RULE_NAME
VARCHAR2(30)
TRANSFORM_TYPE
VARCHAR2(26)
FROM_SCHEMA_NAME
VARCHAR2(30)
TO_SCHEMA_NAME
VARCHAR2(30)
FROM_TABLE_NAME
VARCHAR2(30)
TO_TABLE_NAME
VARCHAR2(30)
SCHEMA_NAME
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
FROM_COLUMN_NAME
VARCHAR2(4000)
TO_COLUMN_NAME
VARCHAR2(4000)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_VALUE
ANYDATA
COLUMN_TYPE
VARCHAR2(4000)
COLUMN_FUNCTION
VARCHAR2(30)
VALUE_TYPE
VARCHAR2(3)
USER_FUNCTION_NAME
VARCHAR2(4000)
SUBSETTING_OPERATION
VARCHAR2(6)
DML_CONDITION
VARCHAR2(4000)
DECLARATIVE_TYPE
VARCHAR2(13)
PRECEDENCE
NUMBER
STEP_NUMBER
NUMBER
DBA_STREAMS_TRANSFORM_FUNCTION:
Rules-based
transform functions used by Streams
iSelfSchooling-SQL> desc DBA_STREAMS_TRANSFORM_FUNCTION;
Name
Null?
Type
----------------------------- -------- --------------------
RULE_OWNER
NOT NULL VARCHAR2(30)
RULE_NAME
NOT NULL VARCHAR2(30)
VALUE_TYPE
VARCHAR2(4000)
TRANSFORM_FUNCTION_NAME
VARCHAR2(4000)
CUSTOM_TYPE
VARCHAR2(11)
DBA_STREAMS_UNSUPPORTED: List of all the tables that are not supported by
Streams in this release
iSelfSchooling-SQL> desc DBA_STREAMS_UNSUPPORTED;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
REASON
VARCHAR2(39)
AUTO_FILTERED
VARCHAR2(3)
DBA_SUBPARTITION_TEMPLATES
iSelfSchooling-SQL> desc DBA_SUBPARTITION_TEMPLATES;
Name
Null? Type
----------------------------- -------- --------------------
USER_NAME
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
SUBPARTITION_NAME
NOT NULL VARCHAR2(34)
SUBPARTITION_POSITION
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
HIGH_BOUND
LONG
DBA_SUBPART_COL_STATISTICS
iSelfSchooling-SQL> desc DBA_SUBPART_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL
VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
HISTOGRAM
VARCHAR2(15)
DBA_SUBPART_HISTOGRAMS
iSelfSchooling-SQL> desc DBA_SUBPART_HISTOGRAMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(4000)
BUCKET_NUMBER
NUMBER
ENDPOINT_VALUE
NUMBER
ENDPOINT_ACTUAL_VALUE
VARCHAR2(1000)
DBA_SUBPART_KEY_COLUMNS
iSelfSchooling-SQL> desc DBA_SUBPART_KEY_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
NAME
VARCHAR2(30)
OBJECT_TYPE
CHAR(5)
COLUMN_NAME
VARCHAR2(4000)
COLUMN_POSITION
NUMBER
DBA_SUBSCRIBED_COLUMNS: Change Data Capture subscribed columns
iSelfSchooling-SQL> desc DBA_SUBSCRIBED_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
HANDLE
NOT NULL NUMBER
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
SUBSCRIPTION_NAME
NOT NULL VARCHAR2(30)
DBA_SUBSCRIBED_TABLES: Change Data Capture subscribed tables
iSelfSchooling-SQL> desc DBA_SUBSCRIBED_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
HANDLE
NOT NULL NUMBER
SOURCE_SCHEMA_NAME
NOT NULL VARCHAR2(30)
SOURCE_TABLE_NAME
NOT NULL VARCHAR2(30)
VIEW_NAME
VARCHAR2(30)
CHANGE_SET_NAME
NOT NULL VARCHAR2(30)
SUBSCRIPTION_NAME
NOT NULL VARCHAR2(30)
DBA_SUBSCRIPTIONS: Change Data Capture subscriptions
iSelfSchooling-SQL> desc DBA_SUBSCRIPTIONS;
Name
Null? Type
----------------------------- -------- --------------------
HANDLE
NOT NULL NUMBER
SET_NAME
NOT NULL VARCHAR2(30)
USERNAME
NOT NULL VARCHAR2(30)
CREATED
NOT NULL DATE
STATUS
NOT NULL VARCHAR2(1)
EARLIEST_SCN
NOT NULL NUMBER
LATEST_SCN
NOT NULL NUMBER
DESCRIPTION
VARCHAR2(255)
LAST_PURGED
DATE
LAST_EXTENDED
DATE
SUBSCRIPTION_NAME
NOT NULL VARCHAR2(30)
DBA_SUMMARIES: Description of the summaries accessible to dba
iSelfSchooling-SQL> desc DBA_SUMMARIES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
SUMMARY_NAME
NOT NULL VARCHAR2(30)
CONTAINER_OWNER
NOT
NULL VARCHAR2(30)
CONTAINER_NAME
VARCHAR2(30)
LAST_REFRESH_SCN
NUMBER
LAST_REFRESH_DATE
DATE
REFRESH_METHOD
VARCHAR2(11)
SUMMARY
VARCHAR2(1)
FULLREFRESHTIM
NUMBER
INCREFRESHTIM
NUMBER
CONTAINS_VIEWS
VARCHAR2(1)
UNUSABLE
VARCHAR2(1)
RESTRICTED_SYNTAX
VARCHAR2(1)
INC_REFRESHABLE
VARCHAR2(1)
KNOWN_STALE
VARCHAR2(1)
QUERY_LEN
NUMBER
QUERY
LONG
DBA_SYNONYMS: All synonyms in the database
iSelfSchooling-SQL> desc DBA_SYNONYMS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
SYNONYM_NAME
NOT NULL VARCHAR2(30)
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
DB_LINK
VARCHAR2(128)
DBA_SYS_PRIVS: System privileges granted to users and roles
iSelfSchooling-SQL> desc DBA_SYS_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
ADMIN_OPTION
VARCHAR2(3)
DBA_TABLES: Description of all relational tables in the
database
iSelfSchooling-SQL> desc DBA_TABLES;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
VARCHAR2(30)
CLUSTER_NAME
VARCHAR2(30)
IOT_NAME
VARCHAR2(30)
STATUS
VARCHAR2(8)
PCT_FREE
NUMBER
PCT_USED
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(3)
BACKED_UP
VARCHAR2(1)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
AVG_SPACE_FREELIST_BLOCKS
NUMBER
NUM_FREELIST_BLOCKS
NUMBER
DEGREE
VARCHAR2(10)
INSTANCES
VARCHAR2(10)
CACHE
VARCHAR2(5)
TABLE_LOCK
VARCHAR2(8)
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
PARTITIONED
VARCHAR2(3)
IOT_TYPE
VARCHAR2(12)
TEMPORARY
VARCHAR2(1)
SECONDARY
VARCHAR2(1)
NESTED
VARCHAR2(3)
BUFFER_POOL
VARCHAR2(7)
ROW_MOVEMENT
VARCHAR2(8)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
DURATION
VARCHAR2(15)
SKIP_CORRUPT
VARCHAR2(8)
MONITORING
VARCHAR2(3)
CLUSTER_OWNER
VARCHAR2(30)
DEPENDENCIES
VARCHAR2(8)
COMPRESSION
VARCHAR2(8)
DROPPED
VARCHAR2(3)
DBA_TABLESPACES: Description of all tablespaces
iSelfSchooling-SQL> desc DBA_TABLESPACES;
Name
Null? Type
-----------------------------
-------- --------------------
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
BLOCK_SIZE
NOT NULL NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENTS
NOT NULL NUMBER
MAX_EXTENTS
NUMBER
PCT_INCREASE
NUMBER
MIN_EXTLEN
NUMBER
STATUS
VARCHAR2(9)
CONTENTS
VARCHAR2(9)
LOGGING
VARCHAR2(9)
FORCE_LOGGING
VARCHAR2(3)
EXTENT_MANAGEMENT
VARCHAR2(10)
ALLOCATION_TYPE
VARCHAR2(9)
PLUGGED_IN
VARCHAR2(3)
SEGMENT_SPACE_MANAGEMENT
VARCHAR2(6)
DEF_TAB_COMPRESSION
VARCHAR2(8)
RETENTION
VARCHAR2(11)
BIGFILE
VARCHAR2(3)
DBA_TABLESPACE_GROUPS: Description of all tablespace groups
iSelfSchooling-SQL> desc DBA_TABLESPACE_GROUPS;
Name
Null? Type
----------------------------- -------- --------------------
GROUP_NAME
NOT NULL VARCHAR2(30)
TABLESPACE_NAME
NOT NULL VARCHAR2(30)
DBA_TABLESPACE_USAGE_METRICS:
Description
of all tablespace space usage metrics
iSelfSchooling-SQL> desc DBA_TABLESPACE_USAGE_METRICS;
Name
Null? Type
-----------------------------
-------- --------------------
TABLESPACE_NAME
VARCHAR2(30)
USED_SPACE
NUMBER
TABLESPACE_SIZE
NUMBER
USED_PERCENT
NUMBER
DBA_TAB_COLS: Columns of user's tables, views and clusters
iSelfSchooling-SQL> desc DBA_TAB_COLS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT
NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(106)
DATA_TYPE_MOD
VARCHAR2(3)
DATA_TYPE_OWNER
VARCHAR2(30)
DATA_LENGTH
NOT NULL NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
NULLABLE
VARCHAR2(1)
COLUMN_ID
NUMBER
DEFAULT_LENGTH
NUMBER
DATA_DEFAULT
LONG
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
LAST_ANALYZED
DATE
SAMPLE_SIZE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
CHAR_COL_DECL_LENGTH
NUMBER
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
CHAR_LENGTH
NUMBER
CHAR_USED
VARCHAR2(1)
V80_FMT_IMAGE
VARCHAR2(3)
DATA_UPGRADED
VARCHAR2(3)
HIDDEN_COLUMN
VARCHAR2(3)
VIRTUAL_COLUMN
VARCHAR2(3)
SEGMENT_COLUMN_ID NUMBER
INTERNAL_COLUMN_ID
NOT NULL NUMBER
HISTOGRAM
VARCHAR2(15)
QUALIFIED_COL_NAME
VARCHAR2(4000)
DBA_TAB_COLUMNS: Columns of user's tables, views and clusters
iSelfSchooling-SQL> desc DBA_TAB_COLUMNS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
COLUMN_NAME
NOT NULL VARCHAR2(30)
DATA_TYPE
VARCHAR2(106)
DATA_TYPE_MOD
VARCHAR2(3)
DATA_TYPE_OWNER
VARCHAR2(30)
DATA_LENGTH
NOT NULL NUMBER
DATA_PRECISION
NUMBER
DATA_SCALE
NUMBER
NULLABLE
VARCHAR2(1)
COLUMN_ID
NUMBER
DEFAULT_LENGTH
NUMBER
DATA_DEFAULT
LONG
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
LAST_ANALYZED
DATE
SAMPLE_SIZE
NUMBER
CHARACTER_SET_NAME
VARCHAR2(44)
CHAR_COL_DECL_LENGTH
NUMBER
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
CHAR_LENGTH
NUMBER
CHAR_USED
VARCHAR2(1)
V80_FMT_IMAGE
VARCHAR2(3)
DATA_UPGRADED
VARCHAR2(3)
HISTOGRAM
VARCHAR2(15)
DBA_TAB_COL_STATISTICS: Columns of user's tables, views and clusters
iSelfSchooling-SQL> desc DBA_TAB_COL_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COLUMN_NAME
VARCHAR2(30)
NUM_DISTINCT
NUMBER
LOW_VALUE
RAW(32)
HIGH_VALUE
RAW(32)
DENSITY
NUMBER
NUM_NULLS
NUMBER
NUM_BUCKETS
NUMBER
LAST_ANALYZED
DATE
SAMPLE_SIZE
NUMBER
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
AVG_COL_LEN
NUMBER
HISTOGRAM
VARCHAR2(15)
DBA_TAB_COMMENTS: Comments on all tables and views in the database
iSelfSchooling-SQL> desc DBA_TAB_COMMENTS;
Name
Null? Type
-----------------------------
-------- --------------------
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
TABLE_TYPE
VARCHAR2(11)
COMMENTS
VARCHAR2(4000)
DBA_TAB_HISTOGRAMS: Histograms on columns of all tables
iSelfSchooling-SQL> desc DBA_TAB_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_TAB_MODIFICATIONS: Information regarding modifications to tables
iSelfSchooling-SQL> desc DBA_TAB_MODIFICATIONS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_NAME
VARCHAR2(30)
INSERTS
NUMBER
UPDATES
NUMBER
DELETES
NUMBER
TIMESTAMP
DATE
TRUNCATED
VARCHAR2(3)
DROP_SEGMENTS
NUMBER
DBA_TAB_PARTITIONS
iSelfSchooling-SQL> desc DBA_TAB_PARTITIONS;
Name
Null? Type
----------------------------- -------- --------------------
TABLE_OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
COMPOSITE
VARCHAR2(3)
PARTITION_NAME
VARCHAR2(30)
SUBPARTITION_COUNT
NUMBER
HIGH_VALUE
LONG
HIGH_VALUE_LENGTH
NUMBER
PARTITION_POSITION
NUMBER
TABLESPACE_NAME
VARCHAR2(30)
PCT_FREE
NUMBER
PCT_USED
NUMBER
INI_TRANS
NUMBER
MAX_TRANS
NUMBER
INITIAL_EXTENT
NUMBER
NEXT_EXTENT
NUMBER
MIN_EXTENT
NUMBER
MAX_EXTENT
NUMBER
PCT_INCREASE
NUMBER
FREELISTS
NUMBER
FREELIST_GROUPS
NUMBER
LOGGING
VARCHAR2(7)
COMPRESSION
VARCHAR2(8)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
BUFFER_POOL
VARCHAR2(7)
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
DBA_TAB_PRIVS: All grants on objects in the database
iSelfSchooling-SQL> desc DBA_TAB_PRIVS;
Name
Null? Type
----------------------------- -------- --------------------
GRANTEE
NOT NULL VARCHAR2(30)
OWNER
NOT NULL VARCHAR2(30)
TABLE_NAME
NOT NULL VARCHAR2(30)
GRANTOR
NOT NULL VARCHAR2(30)
PRIVILEGE
NOT NULL VARCHAR2(40)
GRANTABLE
VARCHAR2(3)
HIERARCHY
VARCHAR2(3)
DBA_TAB_STATISTICS: Optimizer statistics for all tables in the
database
iSelfSchooling-SQL> desc DBA_TAB_STATISTICS;
Name
Null? Type
----------------------------- -------- --------------------
OWNER
VARCHAR2(30)
TABLE_NAME
VARCHAR2(30)
PARTITION_NAME
VARCHAR2(30)
PARTITION_POSITION
NUMBER
SUBPARTITION_NAME
VARCHAR2(30)
SUBPARTITION_POSITION
NUMBER
OBJECT_TYPE
VARCHAR2(12)
NUM_ROWS
NUMBER
BLOCKS
NUMBER
EMPTY_BLOCKS
NUMBER
AVG_SPACE
NUMBER
CHAIN_CNT
NUMBER
AVG_ROW_LEN
NUMBER
AVG_SPACE_FREELIST_BLOCKS
NUMBER
NUM_FREELIST_BLOCKS
NUMBER
AVG_CACHED_BLOCKS
NUMBER
AVG_CACHE_HIT_RATIO
NUMBER
SAMPLE_SIZE
NUMBER
LAST_ANALYZED
DATE
GLOBAL_STATS
VARCHAR2(3)
USER_STATS
VARCHAR2(3)
STATTYPE_LOCKED
VARCHAR2(5)
STALE_STATS
VARCHAR2(3)
|