detect parallel queries that have been serialized
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Sat, 22 Jun 2013 03:13:18 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E58095_at_M1EXCHMB11.mmi.local>
11.2.0.2 linux 64 bit.
I have a problem with some parallel queries being serialized. I am trying to determine which queries where serialized after the fact. Short of catching the query in the act via v$px_session, is there a way to identify queries that have been serialized over a longer period of time? Perhaps a query against the AWR. I have been wracking my brain on this one.
Date: Sat, 22 Jun 2013 03:13:18 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E58095_at_M1EXCHMB11.mmi.local>
11.2.0.2 linux 64 bit.
I have a problem with some parallel queries being serialized. I am trying to determine which queries where serialized after the fact. Short of catching the query in the act via v$px_session, is there a way to identify queries that have been serialized over a longer period of time? Perhaps a query against the AWR. I have been wracking my brain on this one.
Thanks for your help,
Josh
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Jun 22 2013 - 05:13:18 CEST