Date: Fri, 13 Mar 2009 08:45:56 -0700 (PDT)
> I'm confusing on which part of memory affected by
> session_cached_cursors....SGA or PGA ?
Session cursor cache exists in UGA. It stores the addresses of child cursors that exist in shared pool. The idea is that once you have the addresses (pointers), you go straight to where the child cursors are without scanning shared pool. It also implies the child cursors are not supposed to be removed as easily as if you didn't have those pointers in session cursor cache.
I did some research on this. See
Yong HuangReceived on Fri Mar 13 2009 - 10:45:56 CDT