Query stuck on null state
Posted by:
Eric Coll
Date: May 07, 2013 04:50PM
We have a query that executes in less than a second.
The same query executed dynamically from a store procedures that is run by an external java process gets stuck holding locks with state null and no progress.
We found a related bug around the query cache, but setting it to zero makes no difference.
Is this a know bug? any work arounds?
Subject
Views
Written By
Posted
Query stuck on null state
3674
May 07, 2013 04:50PM
1423
May 08, 2013 08:46PM
1639
June 10, 2013 09:39AM
1422
June 10, 2013 10:00PM
1526
June 11, 2013 01:22AM
1313
August 09, 2013 02:17PM
1121
August 09, 2013 07:52PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.