You are working in an online transaction processing (OLTP) environment. You received many
complaints from users about degraded performance. Your senior DBA asked you to execute the
following command to improve the performance:
SQL> ALTER TABLE subscribe_log STORAGE(BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table having one
million rows. Which factor could be a reason for this recommendation?
A.
The keep pool is not configured.
B.
The automatic Program Global Area (PGA) is not configured.
C.
The CURSOR_SPACE_FOR_TIME initialization parameter is set to FALSE.
D.
The most of the rows in SUBSCRIBE_LOG table are accessed once a week.
E.
All the queries on the SUBSCRIBE_LOG table are rewritten using a materialized view.
less usage.
D is right