Does Oracle 9i support trace event 10046?

[cleegt]

Hi,

I ran the following dbms_system procedures:

exec sys.dbms_system.set_bool_param_in_session(39, 89,'timed_statistics',true);
exec sys.dbms_system.set_int_param_in_session (39, 89, 'max_dump_file_size',10000000);
exec sys.dbms_system.set_ev(39, 89, 10046, 12, ' ');

But I could not get the trace file. I would like to know whether trace event 10046 is only supported on oracle 10g and up. Is that correct?

Thanks a lot,

-- Chris

[pando]

it works in 9i

[PAVB]

...and older version too.

[cleegt]

Hmm... that 's strange. When I used DBMS_SYSTEM.set_sql_trace_in_session, I could get the trace file. But when I used 10046 with the above setting, I couldn't get the trace file. Did I missing any setup for it?

Regards,

-- Chris

[cleegt]

Dear All,

Thanks for all your responses. It was my stupid typo mistake causing the problem. It is solved.

Regards,

-- Chris