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
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.