• Description:Performance Tuning
• Passing Score:75%
• Practice Test - Number of questions:156 questions
• Simulation Test - Number of questions:156 questions
• Simulation Test Duration:90 minutes
• Has explanations:No

You have objects that have a variable reference pattern. These are referenced vigorously for some time, and then not referenced at all for a long time. As a result, these objects are being aged out from Oracle memory buffers frequently. Which two strategies would you recommend to avoid aging out of erratically accessed objects? (Choose two.)

Answer(s)

1. increasing PGA size
2. increasing large pool size
3. increasing buffer cache size
4. creating RECYCLE cache using the DB_RECYCLE_CACHE_SIZE parameter
5. creating a KEEP cache using the DB_KEEP_CACHE_SIZE parameter and altering theobjects to that cache

increasing buffer cache size

creating a KEEP cache using the DB_KEEP_CACHE_SIZE parameter and altering theobjects to that cache