Документ создан: 19.04.2019

Некоторые полезные view.

Нашёл полезную картину вот тут: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
Control Files	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_STATEMENT
	DBA_AUDIT_STATEMENT
	USER_AUDIT_OBJECT
	DBA_AUDIT_OBJECT
	DBA_AUDIT_EXISTS
	USER_AUDIT_SESSION
	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
Security	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