Oracle Views with some examples

Oracle Views

Some useful Oracle views

dba_cons_columns	dba_constraints	dba_data_files
dba_ddl_locks	dba_errors	dba_extents
dba_free_space	dba_indexes	dba_jobs
dba_lock	dba_objects	dba_role_privs
dba_roles	dba_rollback_segs	dba_segments
dba_source	dba_tab_columns	dba_tables
dba_temp_files	dba_triggers	dba_ts_quotas
dba_undo_extents	dba_users	dba_mview_logs
dba_mview_refresh_times	dba_mviews	v$archived_log
v$asm_disk	v$backup_datafile	v$controlfile
v$database	v$datafile	v$db_cache_advice
v$filestat	v$instance	v$lock
v$locked_object	v$log	v$logfile
v$parameter	v$process	v$segment_statistics
v$session	v$session_longops	v$session_wait
v$sesstat	v$sort_usage	v$sqlarea
v$statname	v$sysstat	v$system_event
v$tempfile	v$transaction	dba_part_tables
dba_queues	dba_resumable	dba_tab_partitions