RE: Link procedure to sql statement in v$sqlarea - one comment

...but best of all in my opinion is have the developers put the call to dbms_application_info.set_module at the very beginning of all procedures. This way v$sqlarea.module won't lie.  

I have a procedure named 'XYZ' and inside this procedure I have select statement. When I execute this procedure I can see a entry for procedure 'XYZ' and also a entry for select statement (which is actually inside procedure). How do I know if this select statement has come from this procedure or somebody else fired this statement as standalone (not using procedure)

--
http://www.freelists.org/webpage/oracle-l