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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

unknown-698157
shared server? dedicated server?

shared server doesn't generate trace files in udump.

---------
Sybrand Bakker
Senior Oracle DBA
609621
Thanks Sybrand

I already refered to your answer on 833655

But In my case , it is a dedicated server


Thanks

Kai
1 - 2
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
386 views