Database Administration (MOSC)

MOSC Banner

Does dbms_system.set_sql_trace_in_session work in 10.2.0.4 database?

edited Nov 30, 2009 5:58AM in Database Administration (MOSC) 7 commentsAnswered
 I have tried to trace a session in a 10G database using:

"exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,true)" and it says the pl/sql executed successfully however it does not generate a dump file in my udump directory. 

Is this procedure still supported in 10G (I use it all of the time in another 8i environment) or is there a new/different procedure that I should be using?

I need to trace a session that is different from my current session and yes, I am issuing the corresponding "exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,false)"  statement to turn off the tracing.  And I have verified that the parameter user_dump_dest is pointing to the correct directory.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center