You are working in an online transaction processing (OLTP) environment. You received many complaints from users about degraded performance. Your senior DBA asked you to execute the following command to improve the 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 having one million rows. Which factor could be a reason for this recommendation?

Question

You are working in an online transaction processing (OLTP) environment. You received many complaints from users about degraded performance. Your senior DBA asked you to execute the following command to improve the 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 having one million rows. Which factor could be a reason for this recommendation?

Accepted Answer

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

Answer

A. The keep pool is not configured.

Answer

B. The automatic Program Global Area (PGA) is not configured.

Answer

C. The CURSOR_SPACE_FOR_TIME initialization parameter is set to FALSE.

Answer

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

You are working in an online transaction processing (OLTP) environment. You received many complaints from users about degraded performance. Your senior DBA asked you to execute the following command…

Question

Options

How the community answered

Community Discussion