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