Friday, August 9, 2013

Some Very usefull Oracle Views


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





No comments:

Post a Comment