Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SUPPORT- Trace files not generated

609621May 7 2009 — edited May 7 2009
Dear all,


DB : 10.2.0.4.0

OS : Solaris 5.10

I need to trace a forms session which is connected to the DB

I did the below :

1) Started the forms session
2) In one more session, as sys user note down the sid and serial#
3) in the same session 'alter session set sql_trace=TRUE
4)
EXEC DBMS_SUPPORT.start_trace_in_session(sid=>1054, serial=>20493, waits=>TRUE, binds=>FALSE);
5) did all the activities in forms session
6) stopped the trace
 EXEC DBMS_SUPPORT.stop_trace_in_session(sid=>1054, serial=>20493);
but there is no trace files generated in udump

Am I missing something ?

Please guide


Kai
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 4 2009
Added on May 7 2009
2 comments
426 views