Oracle
1Z0-060 · Question #76
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…
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
New Features for Performance
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.
How the community answered
(38 responses)- A5% (2)
- B8% (3)
- C13% (5)
- D50% (19)
- E24% (9)
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
Topics
#buffer cache CACHE hint#keep pool#table caching#full table scan
Community Discussion
No community discussion yet for this question.