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@xxxxxxxxxxxxxx> 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