システムテーブル

列

ALL_CONSTRAINT、USER_CONSTRAINTS、DBA_CONSTRAINTS

R_CONSTRAINT_NAME

ALL_DEPENDENCIES、USER_DEPENDENCIES、DBA_DEPENDENCIES

REFERENCED_LINK_NAME

ALL_INDEXES、USER_INDEXES、DBA_INDEXES

PREFIX_LENGTH
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENT
MAX_EXTENTS
PCT_INCREASE
PCT_FREE
BLEVEL
LEAF_BLOCKS
AVG_LEAF_BLOCKS_PER_KEY
AVG_DATA_BLOCKS_PER_KEY
CLUSTERING_FACTOR
NUM_ROWS
SAMPLE_SIZE
LAST_ANALYZED
DEGREE
INSTANCES
BUFFER_POOL
DUARTION
PCT_DIRECT_ACCESS
ITYP_OWNER
ITYP_NAME
PARAMETERS
GLOBAL_STATS

ALL_OBJECTS、USER_OBJECTS、DBA_OBJECTS

SUBOBJECT_NAME
DATA_OBJECT_ID

ALL_SYNONYMS、USER_SYNONYMS、DBA_SYNONYMS

DB_LINK

ALL_TABLES、USER_TABLES、DBA_TABLES

CLUSTER_NAME
IOT_NAME
PCT_FREE
PCT_USED
INI_TRANS
MAX_TRANS
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENT
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
BLOCKS
EMPTY_BLOCKS
AVG_SPACE
CHAIN_CNT
AVG_ROW_LEN
AVG_SPACE_FREELIST_BLOCKS
NUM_FREELIST_BLOCKS
DEGREE
INSTANCES
IOT_TYPE
BUFFER_POOL
ROW_MOVEMENT
GLOBAL_STATS
DUARTION
SKIP_CORRUPT
MONITORING

ALL_TAB_COLUMNS、USER_TAB_COLUMNS、DBA_TAB_COLUMNS

DATA_TYPE_MOD
DATA_TYPE_OWNER
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
LAST_ANALYZED
SAMPLE_SIZE
GLOBAL_STATS
AVG_COL_LENGTH

ALL_TRIGGERS、USER_TRIGGERS、DBA_TRIGGERS

COLUMN_NAME
REFERENCING_NAME
WHEN_CLAUSE
ACTION_TYPE

ALL_VIEWS、USER_VIEWS、DBA_VIEWS

TYPE_TEXT_LENGTH
TYPE_TEXT
OID_TEXT_LENGTH
OID_TEXT
VIEW_TYPE_OWNER
VIEW_TYPE

DBA_IND_COLUMNS

COLUMN_EXPRESSION

USER_FREE_SPACE、DBA_FREE_SPACE

RELATIVE_FNO

USER_RESOURCE_LIMITS

RESOURCE_NAME
LIMIT

USER_SEGMENTS、DBA_SEGMENTS

BYTES
BLOCKS
EXTENTS
INITIAL_EXTENT
NEXT_EXTENT
IN_EXTENT
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
BUFFER_POOL
RESOURCE_NAME

USER_SYS_PRIVS

PRIVILEGE

USER_USERS、DBA_USERS

ACCOUNT_STATUS
LOCK_DATE
EXPIRY_DATE
PROFILE
INITIAL_RSRC_CONSUMER_GROUP
EXTERNAL_NAME