2 Replies Latest reply: Nov 2, 2011 10:31 PM by meser RSS

    Hi

    890405
      What will Library cache contains? Is that Parsed SQL statement and Execution Plan? When aged out happens which one will be flushed out first..is that parsed sql statement or execution plan?

      Please help me with this.

      Edited by: 887402 on Sep 29, 2011 6:27 AM
        • 1. Re: Hi
          mseberg
          Hello;

          Welcome to the forums.

          This simple paper can explain much better than I :

          http://www.sagelogix.com/idc/groups/public/documents/sagelogix-whitepaper/sage015052.pdf

          Best Regards

          mseberg
          • 2. Re: Hi
            meser
            why does it matter ?

            If parsed statements are gone first, then you have to deal with the over-parsing issue.
            If execution plans are gone first, then oracle has to come up a new execution plan each time.

            I don't think the algorithm behind the curtains favors either of them.
            They must have been placed on the same linked list.