Databases Reference
In-Depth Information
Component
Data dictionary tables and views
Archiving status
V$DATABASE, V$LOG, V$ARCHIVED_LOG, V$ARCHIVE_DEST
Database instance
V$INSTANCE, V$PARAMETER, V$SYSTEM_PARAMETER
Memory structure
V$SGA, V$SGASTAT, V$SGAINFO, V$SGA_DYNAMIC_COMPONENTS, V
$SGA_DYNAMIC_FREE_MEMORY, V$SGA_RESIZE_OPS, V$SGA_RESIZE_CURRENT_OPS, V
$MEMORY_TARGET_ADVICE, V$SGA_TARGET_ADVICE, V$PGA_TARGET_ADVICE
Work area memory
V$PGASTAT, V$SYSSTAT
Processes
V$PROCESS, V$BGPROCESS, V$SESSION
Alerting
DBA_THRESHOLDS, DBA_OUTSTANDING_ALERTS, DBA_ALERT_HISTORY, V$ALERT_TYPES, V$METRIC
Performance monitoring
V$LOCK, DBA_LOCK, V$SESSION_WAIT, V$SQLAREA, V$LATCH
RMAN recovery
V$RECOVER_FILE
User passwords
V$PWFILE_USERS
Tables
DBA_TABLES, ALL_TABLES, USER_TABLES
Indexes
DBA_INDEXES, ALL_INDEXES, USER_INDEXES
Data dictionary
DBA_OBJECTS, ALL_OBJECTS, USER_OBJECTS
