A senior DBA asked you to execute the following command to improve 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 containing one million rows. What could be a reason for this recommendation?()
A:The keep pool is not configured.
B:Automatic Workarea Management is not configured.
C:Automatic Shared Memory Management is not enabled.
D:The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
E:All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view
出自:Oracle认证