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

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

Нашёл полезную картину вот тут:List of Some Important Data Dictionary Views in Oracle 11g. Решил утащить к себе тоже.
Вот:
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_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
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
 
Top.Mail.Ru
Recent changes RSS feed Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki Donate