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