Re: A Tale of Two SQLs

From: Daniel Fink <Daniel.Fink_at_Sun.COM>
Date: Tue, 04 May 2004 07:50:31 -0600
Message-id: <40979FA7.94F03AD2@sun.com>

Sriram,

The statements are referring to the same objects.

Daniel

k.sriramkumar_at_iflexsolutions.com wrote:

> Hi Daniel,
>
> Looking at the statements
>
> PARSING IN CURSOR #10(bad) len=295 dep=1 uid=86 oct=3 lid=86 and PARSING IN CURSOR #7(good) len=295 dep=1 uid=63 oct=3 lid=63
>
> They are being owned and parsed by diffrent id's(63 for bad and 86 for good). Are they refering to diffrent objects by any chance?
>
> Best Regards
>
> Sriram Kumar
>

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 04 2004 - 08:48:10 CDT