Does Oracle 9i support trace event 10046?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Does Oracle 9i support trace event 10046?

  1. #1
    Join Date
    Jan 2003
    Location
    hong kong
    Posts
    29

    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    it works in 9i

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    ...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.

  4. #4
    Join Date
    Jan 2003
    Location
    hong kong
    Posts
    29
    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

  5. #5
    Join Date
    Jan 2003
    Location
    hong kong
    Posts
    29
    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
  •  



Click Here to Expand Forum to Full Width