downgrades in v$sql_monitor
From: Josh Collier <Josh.Collier_at_banfield.net>
Date: Tue, 9 Jul 2013 16:07:33 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E5DD61_at_M1EXCHMB11.mmi.local>
Hi,
I set up a job to capture the contents of v$sql_monitor once a minute during my ETL run last night. I am having a hard time writing a query to find evidence of queries downgraded to serial. My other queries indicate that there were operations downgraded, but I cannot find them in my version of V$sql_monitor. All the px_servers_requested contents have the same value in px_server_allocated.
Date: Tue, 9 Jul 2013 16:07:33 +0000
Message-ID: <D0534F8D31056242BE8E38FA9413FDA817E5DD61_at_M1EXCHMB11.mmi.local>
Hi,
I set up a job to capture the contents of v$sql_monitor once a minute during my ETL run last night. I am having a hard time writing a query to find evidence of queries downgraded to serial. My other queries indicate that there were operations downgraded, but I cannot find them in my version of V$sql_monitor. All the px_servers_requested contents have the same value in px_server_allocated.
Thanks for your time,
Josh C.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 09 2013 - 18:07:33 CEST