detect parallel queries that have been serialized

  • From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 22 Jun 2013 03:13:18 +0000

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

--
//www.freelists.org/webpage/oracle-l


Other related posts: