单项选择题
You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）
A. Set a threshold for the default system-defined moving window baseline.
B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).
C. Modify the profile for the targeted users for which control needs to be imposed.
D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.
相关考题
-
单项选择题
View the Exhibit to examine the parameters set for your database instance.You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command: Which statement describes the consequence?（）
A. The command produces an error.
B. The calibration process runs successfully and populates all the bind variables.
C. The calibration process runs successfully but the latency time is not computed.
D. The calibration process runs successfully but only the latency time is computed.Only users with the SYSDBA privilege can run this procedure. Qualified users must also turn on timed_statistics, and ensure asynch_io is enabled for datafiles. -
单项选择题
View the Exhibit for the object interdependency diagram. How does this impact the status of the dependent objects?（）
A. All dependent objects remain valid.
B. Only the procedure and function become invalid and must be recompiled.
C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
D. Only the procedure and function become invalid and get automatically revalidated the next time they are called. -
多项选择题
Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMANrepository can be listed?（）
A. stored scripts in the recovery catalog
B. backups that can be deleted from disk
C. backup sets and image copies are obsolete
D. backups that do not have the AVAILABLE status in the RMAN repository RMAN
