You configured your database to use the Oracle Shared Server, but you did not configure the large pool. Where in memory will Oracle store user information?
A. PGA
B. JAVA POOL
C. LARGE POOL
D. SHARED POOL
E. SHARED SQL AREA
F. SHARED POOL RESERVED AREA
Answer: D
Explanation:
It will be stored in SHARED POOL area if it is not LARGE POOL is configured.
Incorrect Answers
A: PGA will not be used for this purpose.
B: SHARED POOL area will be used to store user information, not JAVA POOL.
C: LARGE POOL is not configured as question states.
E: There is no SHARED SQL AREA in Oracle9i.
F: SHARED POOL area will be used to store user information, not SHARED POOL RESERVED AREA.
OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 205-208
Chapter 4: Tuning the Shared Pool
No comments:
Post a Comment