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.
Automatic Shared Memory Management is not enabled.

B.
The data blocks in the SUBSCRIBE_LOG table are rarely accessed.

C.
Automatic Workarea Management is not configured.

D.
The keep pool is not configured.

E.
All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.



Leave a Reply 1

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