單項(xiàng)選擇題

There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）

A.Define user profiles and set the CPU_PER_CALL limit.
B.Define a SWITCH_TIME for a plan in the Resource Manager.
C.Create a batch job that checks V$SESSION_LONGOPS；the batch job alters the session priority of the long running operations.
D.Create a user defined event in the Oracle Enterprise Manager， which monitors V$SESSION_LONGOPS.

你可能感興趣的試題

多項(xiàng)選擇題

he Dynamic SGA feature allows the SGA to grow and shrink dynamically according to an ALTER SYSTEM command. This avoids the previous need of shutting down the instance in order to modify the components of the SGA， namely the buffer cache and shared pool components.
Which three statements are true for the Dynamic SGA feature？（）

A.A
B.B
C.C
D.D
E.E

單項(xiàng)選擇題

Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）

A.No literal value is substituted for a shared cursor.
B.Different execution plans are generated for substituted literal values.
C.The substitution of a literal value will produce different execution plans.
D.The substitution of any literal value will produce exactly the same execution plan.

There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）

你可能感興趣的試題

Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）

There is more than one way to set the server to detect and affect long running operations automatically. What is the best choice of you want to reduce the impact of long running operations on other users without aborting the long running operations？（）

Oracle9i extends the cursor sharing functionality with the new value of SIMILAR for the CURSOR_SHARING parameter. With CURSOR_SHARING = SIMILAR， cursors are shared for safe literals only. What is meant by ‘safe literals only’？（）