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
正确答案:D
答案解析:有
![](/editor/images/201705/qrcode_for_gh_573e2a458573_258.jpg)
微信扫一扫手机做题