Re: Oracle 10g
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <Waleed.Khedr@xxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 26 Nov 2005 18:32:01 -0600
MessageHi,
I don't have a chance to check it but is the "main" SQL shown in v$sql because
it is what the underlying X$KGLCURSOR reports or is it just a hack in V$SQL
which reports QC session SQL instead?
Alternatively, if you set 10046 trace in QC before running parallel operation,
do you see the "main" SQL parsed in slave processes? If yes, then Oracle
probably has changed the PX cursor handling, meaning that no layer is hidden,
it's just how it works now (or Oracle has been very thorough with hiding this
layer ;)
Tanel.
----- Original Message -----
From: Khedr, Waleed
To: oracle list
Sent: Friday, November 25, 2005 10:41 AM
Subject: Oracle 10g
Hi guys,
Just for the first time I was asked to take a look at an Oracle 10g database.
The first thing I was upset about is the inability to get the exact sql being
executed by the parallel slaves.
Now all the salves are pointing to the main sql being run by the coordinator.
I did not research this yet, but was wondering if there is quick workaround.
Thanks
Waleed
Other related posts:
