V$ performance Views in Oracle
The V$ views are actually public synonyms for corresponding SYS.V_$ views.
The correct matches are as follows:
- V$SYSSTAT: disk_sorts
- V$SGASTAT: free_memory
- V$SQLAREA: parse_count
- V$LIBRARYCACHE: cache_pins
- V$SESSION_EVENT: event_timeouts
V$ Performance Views
The V$ views are the performance information sources used by all Oracle Database performance tuning tools. The V$ views are based on memory structures initialized at instance startup.
The memory structures, and the views that represent them, are automatically maintained by Oracle Database at the life of the instance.
The V$ views are the performance information sources used by all Oracle performance tuning tools.
The V$ views are based on memory structures initialized at instance startup. The memory structures, and the views that represent them, are automatically maintained by Oracle throughout the life of the instance.
Instance Tuning Steps
These are the main steps in the Oracle performance method for instance tuning:
- Define the Problem
Get candid feedback from users about the scope of the performance problem.
- Examine the Host System and Examine the Oracle Statistics
- After obtaining a full set of operating system, database, and application statistics, examine the data for any evidence of performance problems.
- Consider the list of common performance errors to see whether the data gathered suggests that they are contributing to the problem.
- Build a conceptual model of what is happening on the system using the performance data gathered.
- Implement and Measure Change: Propose changes to be made and the expected result of implementing the changes. Then, implement the changes and measure application performance.
- Determine whether the performance objective defined in step 1 has been met. If not, then repeat steps 2 and 3 until the performance goals are met.