To effectively diagonse performance problems, statistics must be available. Oracle generates many types of cumulative statistics for the system, sessions, and individual SQL statements. The Oracle database also tracks cumulative statistics oln segments and services.
Waite events statistics
V$EVENT_NAME: all the possible wait events are cataloged here.
V$SYSTEM_EVENT: Cumulative statistics for all sessions are stored here and showthe total waits for a particular event since instance startup.
Systemwide statistics
V$STATNAME: all the systemwide statistics are cataloged here and Oracle 10g has about 330 statistics.
V$SYSSTAT: The server displays all calculated system statistics here. The view can be used to find cumulative totals since the instance started.
V$SYSTEM_WAIT_CLASS: all wait events for a particular wait class class.
SGA global statistics
V$SGASTAT: all caculated memory statistics. The view can be queried to find cumulative totals of detailed SGA usage since the instance started.
Oracle data dictionary views
Oracle dynamic performance views
Sunday, October 12, 2008
Oracle system statistics
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment