静态数据字典
字段名 | 描述 |
---|---|
all_indexes | 索引的表 |
all_ind_columns | 索引列的表 |
user_users | 用户 |
字段名 | 描述 |
---|---|
USERNAMEUSER_ID | |
ACCOUNT_STATUS | |
LOCK_DATE | |
EXPIRY_DATE | |
DEFAULT_TABLESPACE | |
TEMPORARY_TABLESPACE | |
CREATED | |
INITIAL_RSRC_CONSUMER_GROUP | |
EXTERNAL_NAME |
字段名 | 描述 |
---|---|
TABLE_NAME | |
TABLESPACE_NAME | |
CLUSTER_NAME | |
IOT_NAME | |
PCT_FREE | |
PCT_USED | |
INI_TRANS | |
MAX_TRANS | |
INITIAL_EXTENT | |
NEXT_EXTENT | |
MIN_EXTENTS | |
MAX_EXTENTS | |
PCT_INCREASE | |
FREELISTS | |
FREELIST_GROUPS | |
LOGGING | |
BACKED_UP | |
NUM_ROWS | |
BLOCKS | |
EMPTY_BLOCKS | |
AVG_SPACE | |
CHAIN_CNT | |
AVG_ROW_LEN | |
AVG_SPACE_FREELIST_BLOCKS | |
NUM_FREELIST_BLOCKS | |
DEGREE | |
INSTANCES | |
CACHE | |
TABLE_LOCK | |
SAMPLE_SIZE | |
LAST_ANALYZED | |
PARTITIONED | |
IOT_TYPE | |
TEMPORARY | |
SECONDARY | |
NESTED | |
BUFFER_POOL | |
ROW_MOVEMENT | |
GLOBAL_STATS | |
USER_STATS | |
DURATION | |
SKIP_CORRUPT | |
MONITORING | |
CLUSTER_OWNER | |
DEPENDENCIES |
包含视图及表的字段说明。
字段名 | 描述 |
---|---|
OBJECT_NAME | |
SUBOBJECT_NAME | |
OBJECT_ID | |
DATA_OBJECT_ID | |
OBJECT_TYPE | |
CREATED | |
LAST_DDL_TIME | |
TIMESTAMP | |
STATUS | |
TEMPORARY | |
GENERATED | |
SECONDARY |
字段名 | 描述 |
---|---|
GRANTEE | |
OWNER | |
TABLE_NAME | |
GRANTOR | |
PRIVILEGE | |
GRANTABLE | |
HIERARCHY |
字段名 | 描述 |
---|---|
SID | |
OWNER | |
OBJECT | |
TYPE |
字段名 | 描述 |
---|---|
SADDR | |
SID | |
SERIAL# | |
AUDSID | |
PADDR | |
USER# | |
USERNAME | |
COMMAND | |
OWNERID | |
TADDR | |
LOCKWAIT | |
STATUS | |
SERVER | |
SCHEMA# | |
SCHEMANAME | |
OSUSER | |
PROCESS | |
MACHINE | |
TERMINAL | |
PROGRAM | |
TYPE | |
SQL_ADDRESS | |
SQL_HASH_VALUE | |
PREV_SQL_ADDR | |
PREV_HASH_VALUE | |
MODULE | |
MODULE_HASH | |
ACTION | |
ACTION_HASH | |
CLIENT_INFO | |
FIXED_TABLE_SEQUENCE | |
ROW_WAIT_OBJ# | |
ROW_WAIT_FILE# | |
ROW_WAIT_BLOCK# | |
ROW_WAIT_ROW# | |
LOGON_TIME | |
LAST_CALL_ET | |
PDML_ENABLED | |
FAILOVER_TYPE | |
FAILOVER_METHOD | |
FAILED_OVER | |
RESOURCE_CONSUMER_GROUP | |
PDML_STATUS | |
PDDL_STATUS | |
PQ_STATUS | |
CURRENT_QUEUE_DURATION | |
CLIENT_IDENTIFIER |
字段名 | 描述 |
---|---|
INSTANCE_NUMBER | |
INSTANCE_NAME | |
HOST_NAME | |
VERSION | |
STARTUP_TIME | |
STATUS | |
PARALLEL | |
THREAD# | |
ARCHIVER | |
LOG_SWITCH_WAIT | |
LOGINS | |
SHUTDOWN_PENDING | |
DATABASE_STATUS | |
INSTANCE_ROLE | |
ACTIVE_STATE |
字段名 | 描述 |
---|---|
NAMESPACE | |
ATTRIBUTE | |
VALUE |
表名 | 意义 | 存在条件 | 权限 |
---|---|---|---|
V$INSTANCE | 实例运行状态 | ||
V$datafile | 数据库使用的数据文件信息 | ||
V$librarycache | 共享池中sql语句的管理信息 | ||
V$lock | 锁的相关信息 | ||
V$log | 从控制文件中提取有关重做日志组的信息 | ||
V$logfile | 日志组文件的相关信息 | ||
V$parameter | 参数 | ||
V$process | 当前进程信息 | ||
V$rollname | 回滚段信息 | ||
V$rollstat | 连机回滚段统计信息 | ||
V$rowcache | 内存中数据字典活动/性能信息 | ||
V$session | 有关活动会话的信息 | ||
V$sesstat | 在V$session中报告当前会话的统计信息 | ||
V$sqlarea | 共享池中使用当前光标的信息 | ||
V$statname | 在V$sesstat中报告的各统计的含义 | ||
V$sysstat | 基于当前操作会话进行的系统统计 | ||
V$waitstat | 等待的相关信息 |
字段名 | 描述 | 示例值 |
---|---|---|
OWNER | SYS | |
INDEX_NAME | I_SYSTEM_PRIVILEGE_MAP | |
INDEX_TYPE | NORMAL | |
TABLE_OWNER | SYS | |
TABLE_NAME | 表名 | SYSTEM_PRIVILEGE_MAP |
TABLE_TYPE | TABLE | |
UNIQUENESS | 唯一索引 | UNIQUE |
COMPRESSION | DISABLED | |
PREFIX_LENGTH | ||
TABLESPACE_NAME | SYSTEM | |
INI_TRANS | 2 | |
MAX_TRANS | 255 | |
INITIAL_EXTENT | 65536 | |
NEXT_EXTENT | ||
MIN_EXTENTS | 1 | |
MAX_EXTENTS | 2147483645 | |
PCT_INCREASE | ||
PCT_THRESHOLD | ||
INCLUDE_COLUMN | ||
FREELISTS | 1 | |
FREELIST_GROUPS | 1 | |
PCT_FREE | 10 | |
LOGGING | YES | |
BLEVEL | ||
LEAF_BLOCKS | ||
DISTINCT_KEYS | ||
AVG_LEAF_BLOCKS_PER_KEY | ||
AVG_DATA_BLOCKS_PER_KEY | ||
CLUSTERING_FACTOR | ||
STATUS | VALID | |
NUM_ROWS | ||
SAMPLE_SIZE | ||
LAST_ANALYZED | ||
DEGREE | 1 | |
INSTANCES | 1 | |
PARTITIONED | NO | |
TEMPORARY | N | |
GENERATED | N | |
SECONDARY | N | |
BUFFER_POOL | DEFAULT | |
USER_STATS | NO | |
DURATION | ||
PCT_DIRECT_ACCESS | ||
ITYP_OWNER | ||
ITYP_NAME | ||
PARAMETERS | ||
GLOBAL_STATS | NO | |
DOMIDX_STATUS | ||
DOMIDX_OPSTATUS | ||
FUNCIDX_STATUS | ||
JOIN_INDEX | NO |
字段名 | 描述 | 示例值 |
---|---|---|
INDEX_OWNER | SYS | |
INDEX_NAME | 索引名 | I_SYSTEM_PRIVILEGE_MAP |
TABLE_OWNER | SYS | |
TABLE_NAME | 表名 | SYSTEM_PRIVILEGE_MAP |
COLUMN_NAME | 字段名 | PRIVILEGE |
COLUMN_POSITION | 1 | |
COLUMN_LENGTH | 22 | |
CHAR_LENGTH | 0 | |
DESCEND | ASC |