Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SHARED_POOL_SIZE and CURSOR_SHARING

SHARED_POOL_SIZE and CURSOR_SHARING

From: Denys van Kempen <dvkempen_at_gmail.com>
Date: Thu, 15 Sep 2005 18:17:59 +0200
Message-ID: <f424bce905091509171d2f055e@mail.gmail.com>


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-l
Received on Thu Sep 15 2005 - 11:20:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US