-
Does Oracle 9i support trace event 10046?
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
-
-
...and older version too.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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
-
Dear All,
Thanks for all your responses. It was my stupid typo mistake causing the problem. It is solved.
Regards,
-- Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|