The Dynamic Performance Tables Dynamic performance views are useful for identifying instance-level performance problems. This chapter describes views which are of the greatest use for both performance tuning and ad hoc investigation, as when users report a sudden deterioration in response time.
Cumulative statistics are from startup.
Lists the fixed objects present in the release. Contains detailed information on the System Global Area. Provides statistics on SQL statements that are in memory, parsed, and ready for execution. Contains information on total waits for an event. Only updated when timed statistics are enabled.