Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> SHARED_POOL_SIZE and CURSOR_SHARING
List,
I was asked if the shared pool could be configured smaller with cursor sharing on. The argument is that there are less execution plans to store. Makes sense, however I've never seen this relation documented anywhere. Has anyone has come across some doc that explains the relation between the actual size of the shared pool and the cursor sharing facility?
Thanks
Denys
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 15 2005 - 11:20:05 CDT
![]() |
![]() |