Performance Tuning - Question 091

Which three types of statistics are reported in report.txt after running UTLESTAT SQL? (Choose three)

A. Locking statistics.

B. Memory usage statistics.

C. Explain plan statistics.

D. Library cache statistics.

E. Buffer busy wait statistics.

F. Rollback contention statistics.

Answer: D, E, F

Explanation:

There are three types of statistics reported in the REPORT.TXT file after running UTLESTAT.SQL: library cache statistics, buffer busy wait statistics, rollback contention statistics.

Incorrect Answers

A: Locking statistics are not reported in REPORT.TXT file.

B: There is no memory usage statistics in REPORT.TXT after running UTLESTAT.SQL.

C: Explain plan statistics are not reported in REPORT.TXT file.

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

Chapter 2: Sources of Tuning Information