Performance Tuning - Question 088

For which reason would you query V$SYSSTAT?

A. Name of the sort segment.

B. Free space available for a sort segment.

C. Number of disk sorts performed since startup.

D. Number of users active on individual sort segments.

Answer: C

Explanation:

Sort activity can be monitored using the V$SYSSTAT and V$SORT_SEGMENT dynamic data dictionary views, using the output from STATPACK and REPORT.TXT, and using the output from the OEM Performance Manager.

Incorrect Answers

A: This view does not show a name of the sort segment.

B: It is not used to show a free space available for a sort segment.

D: V$SYSSTAT does not provide information about number of users active on individual sort segments.

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 414-415

Chapter 8: Tuning Disk I/O