Dynamic Performance Tables

Dynamic Performance Tables - V$SORT_USAGE Shows the size of...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Dynamic Performance Tables A number of V$ dynamic performance views are available to help you tune your system and investigate performance problems. They allow you access to memory structures within the SGA. V$FIXED_TABLE Lists the fixed objects present in the release. V$INSTANCE Shows the state of the current instance. V$LATCH Lists statistics for nonparent latches and summary statistics for parent latches. V$LIBRARYCACHE Contains statistics about library cache performance and activity. V$ROLLSTAT Lists the names of all online rollback segments. V$ROWCACHE Shows statistics for data dictionary activity. V$SGA Contains summary information on the system global area. V$SGASTAT Contains detailed information on the system global area.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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.

Page1 / 2

Dynamic Performance Tables - V$SORT_USAGE Shows the size of...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online