工作中 Oracle 常用数据字典集锦

DBA工作中数据字典就等同于我们本和笔，时时刻刻也分不开的，不管是看状态，还是监控，都需要数据字典的支持，本文整理出来常用的数据字典系列，帮助大家来记住和汇总以便查询利用

ALL_CATALOG All tables, views, synonyms, sequences accessible to the user  

ALL_COL_COMMENTS Comments on columns of accessible tables and views  

ALL_COL_GRANTS_MADE Grants on columns for which the user is owner or grantor  

ALL_COL_GRANTS_RECD Grants on columns for which the user 

                    or PUBLIC is the grantee  

ALL_COL_PRIVS Grants on columns for which the user is the grantor, grantee,

               owner, or an enabled role or PUBLIC is the grantee  

ALL_COL_PRIVS_MADE Grants on columns for which the user is owner or grantor  

ALL_COL_PRIVS_RECD Grants on columns for which the user, 

                   PUBLIC or enabled role is the grantee  

ALL_CONSTRAINTS Constraint definitions on accessible tables  

ALL_CONS_COLUMNS Information about accessible columns 

                 in constraint definitions  

ALL_DB_LINKS Database links accessible to the user  

ALL_DEF_AUDIT_OPTS Auditing options for newly created objects  

ALL_DEPENDENCIES Dependencies to and from objects accessible to the user  

ALL_ERRORS Current errors on stored objects that user is allowed to create  

ALL_INDEXES Descriptions of indexes on tables accessible to the user  

ALL_IND_COLUMNS COLUMNs comprising INDEXes on accessible TABLES  

ALL_OBJECTS Objects accessible to the user  

ALL_REFRESH All the refresh groups that the user can touch  

ALL_REFRESH_CHILDREN All the objects in refresh groups, 

                     where the user can touch the group  

ALL_SEQUENCES Description of SEQUENCEs accessible to the user  

ALL_SNAPSHOTS Snapshots the user can look at  

ALL_SOURCE Current source on stored objects that user is allowed to create  

ALL_SYNONYMS All synonyms accessible to the user  

ALL_TABLES Description of tables accessible to the user  

ALL_TAB_COLUMNS Columns of all tables, views and clusters  

ALL_TAB_COMMENTS Comments on tables and views accessible to the user  

ALL_TAB_GRANTS_MADE User's grants and grants on user's objects  

ALL_TAB_GRANTS_RECD Grants on objects for which the user or PUBLIC 

                     is the grantee  

ALL_TAB_PRIVS Grants on objects for which the user is the grantor, 

             grantee, owner, or an enabled role or PUBLIC is the grantee  

ALL_TAB_PRIVS_MADE User's grants and grants on user's objects  

ALL_TAB_PRIVS_RECD Grants on objects for which the user, 

                    PUBLIC or enabled role is the grantee  

ALL_TRIGGERS Triggers accessible to the current user  

ALL_TRIGGER_COLS Column usage in user's triggers or in 

                        triggers on user's tables  

ALL_USERS Information about all users of the database  

ALL_VIEWS Text of views accessible to the user  

USER_AUDIT_CONNECT Audit trail entries for user logons/logoffs  

USER_AUDIT_OBJECT Audit trail records for statements concerning objects, 

                  specifically: table, cluster, view, index, sequence, 

                  [public] database link, [public] synonym, procedure, trigger,

                   rollback segment, tablespace, role, user  

USER_AUDIT_SESSION 　  

USER_AUDIT_STATEMENT Audit trail records concerning grant, 

                     revoke, audit, noaudit and alter system  

USER_AUDIT_TRAIL Audit trail entries relevant to the user  

USER_CATALOG Tables, Views, Synonyms and Sequences owned by the user  

USER_CLUSTERS Descriptions of user's own clusters  

USER_CLU_COLUMNS Mapping of table columns to cluster columns  

USER_COL_COMMENTS Comments on columns of user's tables and views  

USER_COL_GRANTS Grants on columns for which the user 

                 is the owner, grantor or grantee  

USER_COL_GRANTS_MADE All grants on columns of objects owned by the user  

USER_COL_GRANTS_RECD Grants on columns for which the user is the grantee  

USER_COL_PRIVS Grants on columns for which the user 

                is the owner, grantor or grantee  

USER_COL_PRIVS_MADE All grants on columns of objects owned by the user  

USER_COL_PRIVS_RECD Grants on columns for which the user is the grantee  

USER_CONSTRAINTS Constraint definitions on user's own tables  

USER_CONS_COLUMNS Information about accessible columns 

                  in constraint definitions  

USER_CROSS_REFS Cross references for user's views and synonyms  

USER_DB_LINKS Database links owned by the user  

USER_DEPENDENCIES Dependencies to and from a users objects  

USER_ERRORS Current errors on stored objects owned by the user  

USER_EXTENTS Extents comprising segments owned by the user  

USER_FREE_SPACE Free extents in tablespaces accessible to the user  

USER_INDEXES Description of the user's own indexes  

USER_IND_COLUMNS COLUMNs comprising user's 

                        INDEXes or on user's TABLES  

USER_JOBS All jobs owned by this user  

USER_OBJECTS Objects owned by the user  

USER_OBJECT_SIZE Sizes, in bytes, of various pl/sql objects  

USER_OBJ_AUDIT_OPTS Auditing options for user's own tables and views  

USER_REFRESH All the refresh groups  

USER_REFRESH_CHILDREN All the objects in refresh groups, 

                       where the user owns the refresh group  

USER_RESOURCE_LIMITS Display resource limit of the user  

USER_ROLE_PRIVS Roles granted to current user  

USER_SEGMENTS Storage allocated for all database segments  

USER_SEQUENCES Description of the user's own SEQUENCEs  

USER_SNAPSHOTS Snapshots the user can look at  

USER_SNAPSHOT_LOGS All snapshot logs owned by the user  

USER_SOURCE Source of stored objects accessible to the user  

USER_SYNONYMS The user's private synonyms  

USER_SYS_PRIVS System privileges granted to current user  

USER_TABLES Description of the user's own tables  

USER_TABLESPACES Description of accessible tablespaces  

USER_TAB_AUDIT_OPTS Auditing options for user's own tables and views  

USER_TAB_COLUMNS Columns of user's tables, views and clusters  

USER_TAB_COMMENTS Comments on the tables and views owned by the user  

USER_TAB_GRANTS Grants on objects for which the user 

                is the owner, grantor or grantee  

USER_TAB_GRANTS_MADE All grants on objects owned by the user  

USER_TAB_GRANTS_RECD Grants on objects for which the user is the grantee  

USER_TAB_PRIVS Grants on objects for which the user is the owner, grantor or grantee  

USER_TAB_PRIVS_MADE All grants on objects owned by the user  

USER_TAB_PRIVS_RECD Grants on objects for which the user is the grantee  

USER_TRIGGERS Triggers owned by the user  

USER_TRIGGER_COLS Column usage in user's triggers  

USER_TS_QUOTAS Tablespace quotas for the user  

USER_USERS Information about the current user  

USER_VIEWS Text of views owned by the user  

AUDIT_ACTIONS Description table for audit trail action type codes. 

                 Maps action type numbers to action type names  

COLUMN_PRIVILEGES Grants on columns for which the user is the grantor, 

              grantee, owner, or an enabled role or PUBLIC is the grantee  

DICTIONARY Description of data dictionary tables and views  

DICT_COLUMNS Description of columns in data dictionary tables and views  

DUAL 　  

GLOBAL_NAME global database name  

INDEX_HISTOGRAM statistics on keys with repeat count  

INDEX_STATS statistics on the b-tree  

RESOURCE_COST Cost for each resource  

ROLE_ROLE_PRIVS Roles which are granted to roles  

ROLE_SYS_PRIVS System privileges granted to roles  

ROLE_TAB_PRIVS Table privileges granted to roles  

SESSION_PRIVS Privileges which the user currently has set  

SESSION_ROLES Roles which the user currently has enabled.  

TABLE_PRIVILEGES Grants on objects for which the user is the grantor, 

                 grantee, owner, or an enabled role or PUBLIC is the grantee  

ACCESSIBLE_COLUMNS Synonym for ALL_TAB_COLUMNS  

ALL_COL_GRANTS Synonym for COLUMN_PRIVILEGES  

ALL_JOBS Synonym for USER_JOBS  

ALL_TAB_GRANTS Synonym for TABLE_PRIVILEGES  

CAT Synonym for USER_CATALOG  

CLU Synonym for USER_CLUSTERS  

COLS Synonym for USER_TAB_COLUMNS  

DBA_AUDIT_CONNECT Synonym for USER_AUDIT_CONNECT  

DBA_AUDIT_RESOURCE Synonym for USER_AUDIT_RESOURCE  

DBA_REFRESH_CHILDREN Synonym for USER_REFRESH_CHILDREN  

DICT Synonym for DICTIONARY  

IND Synonym for USER_INDEXES  

OBJ Synonym for USER_OBJECTS  

SEQ Synonym for USER_SEQUENCES  

SM$VERSION Synonym for SM_$VERSION  

SYN Synonym for USER_SYNONYMS  

TABS Synonym for USER_TABLES  

V$ACCESS Synonym for V_$ACCESS  

V$ARCHIVE Synonym for V_$ARCHIVE  

V$BACKUP Synonym for V_$BACKUP  

V$BGPROCESS Synonym for V_$BGPROCESS  

V$CIRCUIT Synonym for V_$CIRCUIT  

V$COMPATIBILITY Synonym for V_$COMPATIBILITY  

V$COMPATSEG Synonym for V_$COMPATSEG  

V$CONTROLFILE Synonym for V_$CONTROLFILE  

V$DATABASE Synonym for V_$DATABASE  

V$DATAFILE Synonym for V_$DATAFILE  

V$DBFILE Synonym for V_$DBFILE  

V$DBLINK Synonym for V_$DBLINK  

V$DB_OBJECT_CACHE Synonym for V_$DB_OBJECT_CACHE  

V$DISPATCHER Synonym for V_$DISPATCHER  

V$ENABLEDPRIVS Synonym for V_$ENABLEDPRIVS  

V$FILESTAT Synonym for V_$FILESTAT  

V$FIXED_TABLE Synonym for V_$FIXED_TABLE  

V$LATCH Synonym for V_$LATCH  

V$LATCHHOLDER Synonym for V_$LATCHHOLDER  

V$LATCHNAME Synonym for V_$LATCHNAME  

V$LIBRARYCACHE Synonym for V_$LIBRARYCACHE  

V$LICENSE Synonym for V_$LICENSE  

V$LOADCSTAT Synonym for V_$LOADCSTAT  

V$LOADTSTAT Synonym for V_$LOADTSTAT  

V$LOCK Synonym for V_$LOCK  

V$LOG Synonym for V_$LOG  

V$LOGFILE Synonym for V_$LOGFILE  

V$LOGHIST Synonym for V_$LOGHIST  

V$LOG_HISTORY Synonym for V_$LOG_HISTORY  

V$MLS_PARAMETERS Synonym for V_$MLS_PARAMETERS  

V$MTS Synonym for V_$MTS  

V$NLS_PARAMETERS Synonym for V_$NLS_PARAMETERS  

V$NLS_VALID_VALUES Synonym for V_$NLS_VALID_VALUES  

V$OPEN_CURSOR Synonym for V_$OPEN_CURSOR  

V$OPTION Synonym for V_$OPTION  

V$PARAMETER Synonym for V_$PARAMETER  

V$PQ_SESSTAT Synonym for V_$PQ_SESSTAT  

V$PQ_SLAVE Synonym for V_$PQ_SLAVE  

V$PQ_SYSSTAT Synonym for V_$PQ_SYSSTAT  

V$PROCESS Synonym for V_$PROCESS  

V$QUEUE Synonym for V_$QUEUE  

V$RECOVERY_LOG Synonym for V_$RECOVERY_LOG  

V$RECOVER_FILE Synonym for V_$RECOVER_FILE  

V$REQDIST Synonym for V_$REQDIST  

V$RESOURCE Synonym for V_$RESOURCE  

V$ROLLNAME Synonym for V_$ROLLNAME  

V$ROLLSTAT Synonym for V_$ROLLSTAT  

V$ROWCACHE Synonym for V_$ROWCACHE  

V$SESSION Synonym for V_$SESSION  

V$SESSION_CURSOR_CACHE Synonym for V_$SESSION_CURSOR_CACHE  

V$SESSION_EVENT Synonym for V_$SESSION_EVENT  

V$SESSION_WAIT Synonym for V_$SESSION_WAIT  

V$SESSTAT Synonym for V_$SESSTAT  

V$SESS_IO Synonym for V_$SESS_IO  

V$SGA Synonym for V_$SGA  

V$SGASTAT Synonym for V_$SGASTAT  

V$SHARED_SERVER Synonym for V_$SHARED_SERVER  

V$SQLAREA Synonym for V_$SQLAREA  

V$STATNAME Synonym for V_$STATNAME  

V$SYSSTAT Synonym for V_$SYSSTAT  

V$SYSTEM_CURSOR_CACHE Synonym for V_$SYSTEM_CURSOR_CACHE  

V$SYSTEM_EVENT Synonym for V_$SYSTEM_EVENT  

V$THREAD Synonym for V_$THREAD  

V$TIMER Synonym for V_$TIMER  

V$TRANSACTION Synonym for V_$TRANSACTION  

V$TYPE_SIZE Synonym for V_$TYPE_SIZE  

V$VERSION Synonym for V_$VERSION  

V$WAITSTAT Synonym for V_$WAITSTAT  

V$_LOCK Synonym for V_$_LOCK 

Leonarding 

2013.08.02

北京&summer

分享技术~成就梦想

Blog：www.leonarding.com

©著作权归作者所有：来自51CTO博客作者leonarding1的原创作品，如需转载，请注明出处，否则将追究法律责任

Oracle数据字典all_ dba_ user_数据库管理