downgrades in v$sql_monitor
- From: Josh Collier <Josh.Collier@xxxxxxxxxxxx>
- To: Randolf Geist <info@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 9 Jul 2013 16:07:33 +0000
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
