Robert, You can try
select sql_text from v$sql t, v$session s, v$px_session p where t.address=s.sql_address and s.sid = p.sid and s.serial# = p.serial# and p.sid = p.qcsid / HTH. Arup ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, January 21, 2003 1:54 PM > Has anyone got a handy bit of 9iSQL to extract the parent SQL statement from > v$sqlarea that has kicked off several parallel slaves? I have some code that > is supposed to be doing that, but there is this one statement that it > extracts and then tries to perform an explain plan on that keeps crashing... > So I can only think that somehow I'm not getting the right statement or it's > somehow coming across corrupted. I've also tried to lookup this SQL in the > v$sql_plan table and extract the plan from there and I get disconnected from > the session when I try. This is application generated code, so I don't have > access to the original SQL. > > Help please :-)) > > RF > > Robert G. Freeman > Technical Management Consultant > TUSC - The Oracle Experts www.tusc.com > 904.708.5076 Cell (it's everywhere that I am!) > Author of several books you can find on Amazon.com! > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Freeman Robert - IL > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).