Performace Tuning

V$FIXED_TABLES  --> Gives list of all tables/views including x$
V$FIXED_VIEW_DEFINITION --> Gives info about view definitions

------------------------------------------------------------------------------------------------------
Some important View of Oracle 11g:

1.1 General
v$database
v$db_cache_advice
v$db_object_cache
v$metric
v$resource
v$resource_limit
v$services
v$spparameter
v$statistics_level
v$type_size
1.2 System
v$sys_optimizer_env
v$sys_time_model
v$sysmetric
v$sysstat
v$system_cursor_cache
v$system_event
v$system_wait_class
1.3 Process
v$process
v$process_memory
1.4 File IO
v$filestat
v$io_calibration_status
v$iostat_file
v$segment_statistics
v$segstat
1.5 Session
v$ses_optimizer_env
v$sess_io
v$sess_time_model
v$session
v$session_connect_info
v$session_cursor_cache
v$session_event
v$session_longops
v$session_object_cache
v$session_wait
v$session_wait_class
v$session_wait_history
2.1 Memory
v$open_cursor
v$java_library_cache_memory
v$library_cache_memory
v$librarycache
v$memory_current_resize_ops
v$memory_dynamic_components
v$memory_resize_ops
v$memory_target_advice
2.2 PGA
v$pga_target_advice
v$pga_target_advice_histogram
v$pgastat
2.3 SGA
v$sga
v$sga_current_resize_ops
v$sga_dynamic_components
v$sga_dynamic_free_memory
v$sga_resize_ops
v$sga_target_advice
v$sgainfo
v$sgastat
2.4 Shared Pool
v$shared_pool_advice
v$shared_pool_reserved
3.1 SQL
v$sql
v$sql_bind_capture
v$sql_bind_data
v$sql_bind_metadata
v$sql_cursor
v$sql_hint
v$sql_optimizer_env
v$sql_plan
v$sql_plan_statistics
v$sql_plan_statistics_all
v$sqlarea
v$sqlstats
v$sqltext
v$sqltext_with_newlines
3.2 Event
v$event_histogram
v$event_name
v$eventmetric
v$wait_chains
v$waitstat
3.3 Lock
v$lock
v$lock_activity
v$locks_with_collisions