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


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.

Affects:

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)

Fixed:

This issue is fixed in

Symptoms:

Related To:

Description

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

Workaround:
 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.

References

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s