This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: V$SORT_USAGE Shows the size of the temporary segments and the session creating them. This information can help you identify which processes are doing disk sorts. V$SQLAREA Lists statistics on shared SQL area; contains one row per SQL string. Provides statistics on SQL statements that are in memory, parsed, and ready for execution. Text limited to 1000 characters; full text is available in 64 byte chunks from V$SQLTEXT. V$SQLTEXT Contains the text of SQL statements belonging to shared SQL cursors in the SGA. V$SYSSTAT Contains basic instance statistics. V$SYSTEM_EVENT Contains information on total waits for an event. V$WAITSTAT Lists block contention statistics. Updated only when timed statistics are enabled....
View Full Document
This note was uploaded on 02/25/2010 for the course MAT 443 taught by Professor Roberts during the Winter '10 term at University of Arizona- Tucson.
- Winter '10