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

Sriram,

The statements are referring to the same objects.

Daniel

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: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: