Performance Tuning - Question 094

Which dynamic view is most useful for determining the current number of blocks allocated to a buffer pool?

A. V$CACHE

B. V$SESS_IO

C. V$SYSSTAT

D. V$BUFFER_POOL

Answer: D

Explanation:

The V$BYUFFER_POOL dynamic performance view contains information about the configuration of the multiple Buffer Pools themselves. You can monitor the performance of the Buffer Pools using the V$BUFFER_POOL and V$BUFFER_POOL_STATISTICS dynamic performance views.

Incorrect Answers

A: V$CACHE dynamic view is an Oracle9i Real Application Clusters view. This view contains information from the block header of each block in the SGA of the current instance as related to particular database objects.

B: This view lists I/O statistics for each user session.

C: 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.

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

Chapter 5: Tuning the Database Buffer Cache