RE: Link procedure to sql statement in v$sqlarea - one comment
From: "Alvaro Jose Fernandez" <alvaro.fernandez@xxxxxxxxx>
To: <Ajay_Thotangare@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Date: Tue, 2 Oct 2007 22:14:35 +0200
...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)
