Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> RE: Question about parsing

RE: Question about parsing

From: Julio German Rojas Pelaez <jgrp_at_tid.es>
Date: Wed, 23 Jan 2002 09:48:39 +0100
Message-ID: <a2lta1$a6l3@tid.tid.es>


Users are the same, I guess the two rows are there because module, module_hash and action_hash have different values. The big question is still why is the query locked every time it is executed? Any idea about where to start looking for?

Bass Chorng <bchorng_at_yahoo.com> escribió en el mensaje de noticias bd9a9a76.0201221248.2c123fbd_at_posting.google.com...
> "Julio German Rojas Pelaez" <jgrp_at_tid.es> wrote in message
news:<a2jilg$4jc1_at_tid.tid.es>...
> > In short:
> > I have exactly same query once executed though jdbc once executed from
> > sqlplus.
> > I got two different rows in v_$sql.
> >
> > Should't they be registered as two executions of the same query instead
of
> > two
> > different ones?
> >
> >
>
> Are the objects owned by the same owner ? Two identical SQLs won't
> be shared if the objects referred to are owned by different users.
>
> If user joe issues 'select * from emp' and if emp is a table owned
> by joe, and if john also issues 'select * from emp' and this emp
> is owned by john, then these two SQLs, although having the same
> hash value, still won't get shared. The answer is simple, the
> object_id's are different and so the parse trees are different.
> If there are a list of objects invovled, then every single object
> has to be the same to get the SQL shared.
Received on Wed Jan 23 2002 - 02:48:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US