Tuesday, May 10, 2011

List of Some Important Data Dictionary Views in Oracle 11g

DB Creation
V$SGA
V$INSTANCE
V$DATABASE
V$PROCESS
V$SYSAUX_OCCUPANTS
Users & Resources
DBA_USERS
ALL_USERS
USER_USERS
DBA_TS_QUOTAS
USER_TS_QUOTAS
USER_PASSWORD_LIMITS
USER_RESOURCE_LIMITS
DBA_PROFILES
RESOURCE_COST
V$SESSION
V$SESSTAT
V$STATNAME
RMAN Recovery Catlog
RC_ARCHIVED_LOG
V$ARCHIVED_LOG
RC_BACKUP_CONTROLFILE
V$BACKUP_DATAFILE
RC_BACKUP_DATAFILE
V$BACKUP_DATAFILE
RC_BACKUP_PIECE
V$BACKUP_PIECE
RC_BACKUP_REDOLOG
V$BACKUP_REDOLOG
RC_BACKUP_SET
V$BACKUP_SET
RC_DATABASE
V$DATABASE
RC_DATAFILE
V$DATAFILE
RC_RMAN_CONFIGURATION
V$RMAN_CONFIGURATION
RC_LOG_HISTORY
V$LOG_HISTORY
TBS Management
DBA_TABLESPACES
DBA_TABLESPACE_GROUPS
DBA_DATA_FILES
DBA_FREE_SPACE
V$TABLESPACE
V$DATAFILE
DATABASEE_PROPERTIES
Roles & Privileges
ALL_COL_PRIVS
USER_COL_PRIVS
ALL_TAB_PRIVS
USER_TAB_PRIVS
ALL_TAB_PRIVS_MADE
USER_TAB_PRIVS_MADE
ALL_TAB_PRIVS_RECD
USER_TAB_PRIVS_RECD
DBA_ROLES
DBA_COL_PRIVS
USER_ROLE_PRIVS
DBA_ROLE_PRIVS
USER_SYS_PRIVS
DBA_SYS_PRIVS
COLUMN_PRIVILEGES
DBA_TAB_PRIVS
ROLE_ROLE_PRIVS
ROLE_SYS_PRIVS
SESSION_PRIVS
SESSION_ROLES
Control Files
V$CONTROLFILE
V$CONTROLFILE_RECORD_SECTION
Storage Parameters
DBA_SEGMENTS
DBA_EXTENTS
DBA_TABLES
DBA_INDEXES
DBA_TABLESPACES
DBA_DATA_FILES
DBA_FREE_SPACE
Auditing
STMT_AUDIT_OPTION_MAP
AUDIT_ACTIONS
ALL_DEF_AUDIT_OPTS
DBA_STMT_AUDIT_OPTS
USER_OBJ_AUDIT_OPTS
DBA_OBJ_AUDIT_OPTS
USER_AUDIT_TRAIL
DBA_AUDIT_TRAIL
USER_AUDIT_SESSION
DBA_AUDIT_STATEMENT
USER_AUDIT_OBJECT
DBA_AUDIT_OBJECT
DBA_AUDIT_EXISTS
USER_AUDIT_SESSIONS
DBA_AUDIT_SESSION
USER_TAB_AUDIT_OPTS
Rollback Segments
DBA_SEGMENTS
USER_SEGMENTS
DBA_ROLLBACK_SEGS
V$ROLLSTAT
V$ROLLNAME
Data PUMP
DBA_DATAPUMP_JOBS
USER_DATAPUMP_JOBS
DBA_DIRECTORIES
Dispatchers
V$DISPATCHER_CONFIG
V$MTS
V$DISPATCHER
Redo Log Files
v$LOG
V$LOGFILE
V$LOG_HISTORY
V$LOGHIST
V$RECOVERY_LOG
V$ARCHIVED_LOG
Archived Redo Log Files
V$ARCHIVED_LOG
V$ARCHIVE_DEST
V$ARCHIVE_PROCESSES
Security
DBA_USERS
DBA_USERS_WITH_DEFPWD
Undo Management
DBA_UNDO_EXTENTS
DBA_SEGMENTS
USER_SEGMENTS
V$UNDOSTAT
U$TRANSACTION
Tuning
V$PX_PROCESS
V$PX_SESSION
V$PX_PROCESS_SYSSTAT