Saturday 3 May 2014

DIFFERENT V$VIEW:

v$sga
v$sgastat
v$sgainfo
v$sga_current_resize_ops
v$sga_resize_ops
v$sga_dynamic_components
v$sga_dynamic_free_memory
v$pgastat
v$sql_workarea_histogram
v$pga_target_advice_histogram                                              
v$pga_target_advice
v$memory_current_resize_ops
v$memory_resize_ops
v$memory_dynamic_components
v$library_cache_memory
v$shared_pool_advice
v$java_library_cache_memory
v$java_pool_advice
v$streams_pool_advice

v$lock
v$sql
v$sqlarea
v$sesstat
v$mystat
v$sess_io
v$sysstat
v$statname
v$osstat
v$active_session_history
v$active_sess_pool_mth
v$session_wait
v$session_wait_class
v$system_wait_class
v$transaction
v$locked_object
v$latch
v$latch_children
v$latch_parent
v$latchname
v$latchholder
v$latch_misses
v$enqueue_lock
v$transaction_enqueue
v$sys_optimizer_env
v$ses_optimizer_env
v$sql_optimizer_env
v$sql_plan
v$sql_plan_statistics
v$sql_plan_statistics_all

v$rman_backup_subjob_details
v$rman_backup_job_details
v$backup_set_details
v$backup_piece_details
v$backup_copy_details
$backup
v$recovery_status
v$recovery_file_status
v$backup_set
v$backup_piece
v$backup_datafile
v$backup_redolog
v$backup_corruption
v$backup_device
v$backup_spfile
v$backup_sync_io
v$backup_async_io
v$recover_file
v$rman_status
v$rman_output
v$backup_datafile_details
v$backup_controlfile_details
v$backup_archivelog_details
v$backup_spfile_details
v$backup_datafile_summary
v$backup_controlfile_summary
v$backup_archivelog_summary
v$backup_spfile_summary
v$backup_set_summary
v$recovery_progress
v$rman_backup_type
v$rman_configuration
 

No comments:

Post a Comment