SQL> shutdown abort .com

About DBA Queries DBA Scripts Quick Guides Nooleus Other Stuff Contact
Andy only 
 

Oracle Views

Some useful Oracle views with examples showing how to use them.

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
Copyright© 2007-2010 Andrew Barry