Bug 5403150 ORA-603 when cannot get lock within Resource Manager “switch_time” in RAC

 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.


Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 11
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)


This issue is fixed in


Related To:


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.

 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


One thought on “Bug 5403150 ORA-603 when cannot get lock within Resource Manager “switch_time” in RAC

  1. My spouse and I absolutely love your blog and find nearly all of
    your post’s to be precisely what I’m looking for. Do you offer guest writers to write content for yourself?
    I wouldn’t mind creating a post or elaborating on a number of the subjects you write in relation to here. Again, awesome web site!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s