Oracle Database Components list and associated data dictionary views

Component Data Dictionary tables and views

DatabaseV$database, V$version, v$instance
Shared ServerV$queue, V$dispatcher, V$shared_server
Connection PoolingDba_cpool_info, V$cpool_stat, V$cpool_cc_stats
tablespacesUser_free_space, Dba_free_space, V$tempfile, Dba_users, Dba_ts_quotas
Control FilesV$controlfile, V$parameter, v$controlfile_record_section
datafilesV$datafile, V$datafile_header, Dba_data_files, Dba_extents, user_extents
SegmentsDba_segments, User_segments
extentsDba_extents, User_extents
Redo LogsV$thread, V$log, V$logfile, v$log_history
UndoV$undostat, V$rollstat, v$transaction
Archiving StatusV$database, V$log, V$archived_log, v$archive_dest
Database InstanceV$instance, V$parameter, V$system_parameter
Memory StructureV$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 MemoryV$pgastat, V$sysstat
ProcessesV$process, V$bgprocess, v$session
AlertingDba_thresholds, Dba_outstanding_alerts, Dba_alert_history, V$alert_types,
V$metric
Performance MonitoringV$lock, Dba_lock, v$session_wait, V$sqlarea, V$latch
RMAN RecoveryV$recover_file
User PasswordsV$pwfile_users
TablesDba_tables, All_tables, User_tables
IndexesDba_indexes, All_indexes, user_indexes
Data DictionaryDba_objects, All_objects, user_objects

Oracle Database Components list and associated data dictionary views