This discussion is archived
1 2 3 Previous Next 33 Replies Latest reply: May 18, 2008 7:31 PM by Aman.... Go to original post RSS
  • 30. Re: performance(statspack) related problem
    Jonathan Lewis Oracle ACE Director
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Journeyer
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    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