4 Replies Latest reply: Apr 20, 2013 4:50 AM by Aman.... RSS

    oracle trace on events

    951290
      hi gurus..


      please anybody explain me what is the difference between event based trace (eg 10046,10053) and a normal trace using alter session ?

      At what condition it is recommended to use?


      is it still using as latest dbms_monitor package is available ?


      any help is appreciated.

      Thanks in advance
        • 1. Re: oracle trace on events
          Amar_Singh
          All 3 are related to monitoring the sql executions and get detailed information about sql, how many current reads,consistent reads etc were needed during the execution of sql.

          10053 is more advanced version of 10046 and shows more details like what all execution plans were looked on by optimizer and which plan was finally choosen. The information provided is not plain simple English and hence is mainly used by people doing advanced tuning or by oracle support.
          • 2. Re: oracle trace on events
            951290
            ok, but at what circumstance they are useful?

            still it is using along with alter session ??


            is there is any equivalent option in dbms_monitor or any other packages ??
            • 3. Re: oracle trace on events
              Osama_Mustafa
              Check the below document
              http://docs.oracle.com/cd/A58617_01/server.804/a58246/otrace.htm
              • 4. Re: oracle trace on events
                Aman....
                10046 is the trace event to find out the wait happening at different steps of the execution whereas 10053 is going to bring out the details of the optimizer's working. So two different trace events for two different purposes.

                Aman....