Performance Tuning - Question 124

Which two statements are valid settings for the initialization parameter ‘USE_STORED_OUTLINES’? (Choose two)

A. SQL> alter session set USE_STORED_OUTLINES = TRUE;

B. SQL> alter session set USE_STORED_OUTLINES = PUBLIC;

C. SQL> alter session set USE_STORED_OUTLINES = PRIVATE;

D. SQL> alter session set USE_STORED_OUTLINES = DEFAULT;

E. SQL> alter session set USE_STORED_OUTLINES = ;

F. SQL> alter session set USE_STORED_OUTLINES = ;

Answer: A, F

Explanation:

There are two valid settings for the initialization parameter USE_STORED_OUTLINES: TRUE or category name.

Incorrect Answers

B: This statement is incorrect.

C: This statement is incorrect.

D: This statement is incorrect.

E: This initialization can use category name, not outline name.

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

Chapter 3: SQL Application Tuning and Design