tracing events

[sona]

hi,

I want to trace the requests ie stored procedure calls from other sources like from vb or java etc.. to ORacle.
Is there any utility just like sql profiler in SQL2000.


Then another one,
i am using oracle8.1.7.
diagnostic pack is not available.I tried to install it, but it is not found in the OEM.

what shall i do for oracle trace manager?

[anandkl]

Just execute 'alter session set sql trace=true;'
for the user calling this procedure.

once u finished tracing stop the trace.


regards
anandkl

[Edited by anandkl on 05-16-2002 at 09:46 AM]

[pando]

dbms_profiler