Re: shared pool evictions

FYI I wrote a blog entry about the item #1 above - a shared pool recreatable chunk's LRU list position:

https://tanelpoder.com/posts/oracle-shared-pool-list-chunk-position-in-lru-list/

Tanel.

On Tue, Mar 3, 2020 at 11:27 PM Tanel Poder <tanel_at_tanelpoder.com> wrote:

> Btw these are different things:
>
> 1) Shared pool chunk position in the LRU list (transient vs recurrent) -
> moved around after 2nd exec (after 3rd unpin)
> 2) Whether a cursor is cached in session cursor cache - cursor kept open
> after 3rd exec
>
> Yes, agreed, Oracle-L is a good place to hang out at! :-)
>
> --
> Tanel Poder
> https://tanelpoder.com/conference
>
>>
>>

--
http://www.freelists.org/webpage/oracle-l