单项选择题
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)
相关考题
-
单项选择题
Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?（）
A. Provide a password for the encryption
B. Set up an Oracle wallet for the encryption
C. No setup is required as it is a default encryption method
D. Both Oracle wallet and password must be set up for the encryption -
多项选择题
For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?（）(Choose two.)
A. views
B. fixed tables
C. heap tables
D. external tables
E. temporary tables
F. index-organized tables (IOT) -
单项选择题
After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?（）
A. Opening the database in RESTRICTED mode
B. Opening the database with the RESETLOGS option
C. Setting a new DBID for the newly restored database
D. Restoring the server parameter file (SPFILE) to the new host
