1 2 3 Previous Next 33 Replies Latest reply: May 18, 2008 9:31 PM by Aman.... Go to original post RSS
      • 30. Re: performance(statspack) related problem
        Jonathan Lewis
        Hi,

        Let's format this to make it easy to read:

        ******************************************************
        ***
        STATSPACK report for

        DB Name DB Id Instance Inst Num Release Cluster Host
        ------------ ----------- ------------ --------
        ----------- ------- ------------
        ..
        {unreadable report removed}
        undo_retention 10800
        undo_tablespace UNDOTBS1
        user_dump_dest F:\oracle\admin\neosoft\udump
        ------------------------------------------------------
        -------

        End of Report
        It takes a little more than just a couple of tags when you're copying an existing post.


        Jonathan Lewis
        http://jonathanlewis.wordpress.com
        http://www.jlcomp.demon.co.uk
        • 31. Re: performance(statspack) related problem
          Jonathan Lewis
          Aman,


          I think Charles has explained this,

          > COLLECTION ITERATOR (PICKLER FETCH) OF 'DISPLAY'

          I just happened to know that the picker fetch relates to the table() operator, and as you can see, the display function of dbms_xplan is the thing being accesed:

          > select * from table(dbms_xplan.display);


          Regards
          Jonathan Lewis
          http://jonathanlewis.wordpress.com
          http://www.jlcomp.demon.co.uk
          • 32. Re: performance(statspack) related problem
            108476
            It takes a little more than just a couple of tags when you're copying an existing post.
            No. Sometimes, the tabs are retained . . . .
            • 33. Re: performance(statspack) related problem
              Aman....
              Hi sir,
              Yes Charles explained it well.
              Sir what exactly this pickler fetch mean?And I have seen this message coming up some times simply with dbms_xplan without the use of autotrace too in 10201.
              Thanks and regards
              Aman....
              1 2 3 Previous Next