Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: Question about parsing
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