
	René Nyffenegger's collection of things on the web
	René Nyffenegger on Oracle - Most wanted - Feedback - Follow @renenyffenegger

Oracle dynamic views

RMAN related

v$rman_configuration
v$rman_status
v$rman_output
v$rman_backup_subjob_details
v$rman_backup_job_details
v$rman_backup_type

SQL related

v$sqlarea
v$sql
v$sqlarea_plan_hash
v$sql_shared_memory
v$sqltext
v$sqltext_with_newlines
v$sql_cursor
v$sql_bind_metadata
v$sql_shared_cursor
v$sql_bind_data
v$sql_workarea
v$sql_workarea_active
v$sql_workarea_histogram
v$sql_optimizer_env
v$sql_plan
v$sql_plan_statistics
v$sql_plan_statistics_all
v$sql_redirection
v$sql_join_filter
v$sqlstats

Tuning related

v$event_name
v$session_event
v$session_wait
v$session_wait_class
v$session_wait_history
v$system_event

Resource Manager related

v$rsrc_cons_group_history
v$rsrc_consumer_group
v$rsrc_consumer_group_cpu_mth
v$rsrcmgrmetric
v$rsrcmgrmetric_history
v$rsrc_plan
v$rsrc_plan_cpu_mth
v$rsrc_plan_history
v$rsrc_session_info