Re: A Tale of Two SQLs

  • From: Daniel Fink <Daniel.Fink@xxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 04 May 2004 07:50:31 -0600


The statements are referring to the same objects.


k.sriramkumar@xxxxxxxxxxxxxxxxxx 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:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: