What could be a reason for this recommendation?

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 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.

Explanation:
The most of the rows in SUBSCRIBE_LOG table are accessed once a week.



Leave a Reply 2

Your email address will not be published. Required fields are marked *