问题:
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
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?()
● 参考解析
本题暂无解析