Re: Question about parsing

"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 Tue Jan 22 2002 - 14:48:19 CST