单项选择题
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）
相关考题
-
多项选择题
Using the LIST command in Recovery Manager (RMAN), which two pieces of information from the RMANrepository can be listed?（）
A. Stored scripts in the recovery catalog
B. Backups that can be deleted from disk
C. Backup sets and images copies that are obsolete
D. Backups that do not have the AVAILABLE status in the RMAN repository -
单项选择题
Examine the following PL/SQL block： DECLARE my_plans pls_integer； BEGIN my_plans ：= DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE （sql_id=> ？9twu5t2dn5xd？； END； Which statement is true about the plan being loaded into the SQL plan 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. -
单项选择题
Examine the following commands and their output: View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?（）
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
