Oracle
1Z0-060 · Question #76
1Z0-060 Question #76: Real Exam Question with Answer & Explanation
The correct answer is D: The data blocks in the SUBSCRIBE_LOG table are rarely accessed.. You can configure a RECYCLE buffer pool for blocks belonging to those segments that you do not want to keep in memory. The purpose of the RECYCLE pool is to retain segments that are scanned rarely or are not
Question
A senior DBA asked you to execute the following command to improve performance: You checked the data in the table and found that it is a large table containing SUBSCRIBE_LOG one million rows. What could be a reason for this recommendation?
Options
- AThe keep pool is not configured.
- BAutomatic Workarea Management is not configured.
- CAutomatic Shared Memory Management is not enabled.
- DThe data blocks in the SUBSCRIBE_LOG table are rarely accessed.
- EAll the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
Explanation
You can configure a RECYCLE buffer pool for blocks belonging to those segments that you do not want to keep in memory. The purpose of the RECYCLE pool is to retain segments that are scanned rarely or are not
Community Discussion
No community discussion yet for this question.