單項(xiàng)選擇題

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.
How would you accomplish this task?（）

A. Set metric threshold
B. Implement Database Resource Manager
C. Enable resumable timeout for user sessions
D. Add directives to Automatic Database Diagnostic Monitor (ADDM)

你可能感興趣的試題

單項(xiàng)選擇題

Which statement is true about the plan being loaded into the SQL baseline by the above command?（）

A. It is loaded with the FIXED status.
B. It is loaded with the ACCEPTED status.
C. It is not loaded with the ENABLED status.
D.It is not loaded with the ACCEPTED status.

單項(xiàng)選擇題

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.

Which statement describes the consequence?（）

A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.
B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.
C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.
D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）

你可能感興趣的試題

Which statement is true about the plan being loaded into the SQL baseline by the above command?（）

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks. Which statement describes the consequence?（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.
How would you accomplish this task?（）

View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.

Which statement describes the consequence?（）