|
Explanation: You can define a SWITCH_TIME for a plan in the Resource Manager to reduce the impact of long running operations on other users without aborting the long running operations. Incorrect Answers: 1: You cannot do this with CPU_PER_CALL limit. 3: You don’t need to use a batch job to check V$SESSION_LONGOPS for this purpose. 4: It can be done with a SWITCH_TIME for a plan in the Resource Manager, you don’t need to monitor V$SESSION_LONGOPS. Reference: OCP Oracle9i Database: New Features for Administrators, Daniel Benjamin, p. 122-129 Chapter 3: Manageability Enhancements
|