On Dec 1, 11:32 pm, DA Morgan <damor..._at_psoug.org> wrote:
>
> A statement used once will age out quickly if there is any need for the
> space.
Thank you sir - all responses have been very useful. Not sure how
the aging of V$SQLAREA is done, but sometimes I do see it drop from
1000+ rows to 700+ rows, but sometimes it just stay for a long time at
1600+. Could be due to user sessions logout? Anyway, now I have a
new question....in another new thread. Thanks again.
Received on Sat Dec 01 2007 - 18:02:52 CST
