In an online transaction processing (OLTP) system, which is configured in shared server mode, you execute the following query to examine the sort performance:

SQL> SELECT d.value "Disk", m.value "Mem", (d.value/m.value)*100 "Ratio" FROM v$sysstat m, v$sysstat d WHERE m.name='sorts (memory)' and d.name='sorts (disk)'; Disk Mem Ratio ---------- ---------- --------- 23 206 11.165049 What action would you take after observing the output?

Question

In an online transaction processing (OLTP) system, which is configured in shared server mode, you execute the following query to examine the sort performance:

SQL> SELECT d.value "Disk", m.value "Mem", (d.value/m.value)*100 "Ratio" FROM v$sysstat m, v$sysstat d WHERE m.name='sorts (memory)' and d.name='sorts (disk)'; Disk Mem Ratio ---------- ---------- --------- 23 206 11.165049 What action would you take after observing the output?

Accepted Answer

A. increase the value of SORT_AREA_SIZE

Answer

B. increase the size of the temporary tablespace

Answer

C. increase the value of PGA_AGGREGATE_TARGET

Answer

D. no action required because the ratio is perfect for an OLTP system

In an online transaction processing (OLTP) system, which is configured in shared server mode, you execute the following query to examine the sort performance: SQL> SELECT d.value "Disk", m.value…

Question

Options

How the community answered

Community Discussion