Modified 08-OCT-2010 Type PATCH Status ARCHIVED
Bug 5403150 ORA-603 when cannot get lock within Resource Manager “switch_time” in RAC
This note gives a brief overview of bug 5403150.
The content was last updated on: 03-APR-2008
Click here for details of each of the sections below.
||Oracle Server (Rdbms)
|Range of versions believed to be affected
||Versions < 11
|Versions confirmed as being affected
||Generic (all / most platforms affected)
If Resource Manager directives are being used in a RAC environment
then an ORA-603 is returned (when the switch group is 'KILL_SESSION')
when a query cannot get access to a resource within the switch time limit
as defined by the resource manager directives.
eg: As set by RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE
Instead of using KILL_SESSION switch group one can use the CANCEL_SQL switch
group which will just terminate the current query and return a ORA-40 to the
the user session.
|Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. Always consult with Oracle Support for advice.
Bug:5403150 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article