Friday, 14 August 2009

Performance Tuning - Question 036

What does the result of this query indicate? SELECT * FROM V$SGASTATWHERE POOL LIKE '%java%'

A . The number of Java session memory structures allocated

B. The amount of Java pool free memory and memory in use

C . The size of each Java session memory structure



Explanation:

Answer B: V$SGASTAT has two entries for the Java pool: 'free memory' and 'memory in use'. The sum of these two values is equal to the java_pool_size.

No comments:

Post a Comment