静态数据字典
| 字段名 | 描述 |
|---|---|
| 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 |