OraFAQ Forum: Performance Tuning » shared pool doubt..?

Home » RDBMS Server » Performance Tuning » shared pool doubt..?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

shared pool doubt..? [message #153906]

Wed, 04 January 2006 15:03

balavignesh
Messages: 180
Registered: March 2005

Senior Member

hi,

while keeping the objects like packages/procedures inside the shared pool using
dbms_shared_pool.keep('name')

the objects are resided in shared pool or reserved shared pool..?

and doing this will increase performance..?

plz guide..

regards
bala

Report message to a moderator

Re: shared pool doubt..? [message #153908 is a reply to message #153906]

Wed, 04 January 2006 15:42

mchadder
Messages: 224
Registered: May 2005
Location: UK

Senior Member

Hi there.

To be honest, pinning of anything is largely unnecessary nowadays due to the introduction of the large_pool. Pinning was introduced to solve a particular problem when the large pool was not available (7.x / 8.x).

For a great discussion on the "un-necessariness" (is that a word? Wink

) of pinning, see http://asktom.oracle.com/pls/ask/f?p=4950:8:1776970162793260413::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:2667245192483

Rgds

Report message to a moderator

Re: shared pool doubt..? [message #154058 is a reply to message #153908]

Thu, 05 January 2006 09:50

JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland

Senior Member

Quote:

For a great discussion on the "un-necessariness" (is that a word? Wink)

No but it should be Smile

Report message to a moderator

Re: shared pool doubt..? [message #154430 is a reply to message #153908]

Sun, 08 January 2006 06:32

SQLAREA
Messages: 21
Registered: January 2006
Location: Belgium

Junior Member

Hi,

Neither I believe pinning objects in the shared pool is worth the effort these days. As far I can remember it was done and relevant in Oracle 7 in order to avoid the terrible ora 4031 messages. I think to know large packages doesn' t need contiguous space in the shared pool anymore but can be loaded in memory in chunks. As well there is the shared_pool_reserved_size -default 5% of the shared_pool- which is there in order to avoid ora 4031 as well.

I am not aware whether the large_pool has anything to do with ora 4031 at the level of the shared_pool assuming you run in dedicated server mode.
I thought the large_pool and the sizing of it are only relevant if you are running shared_server connections or if you are backing up with rman using multiple channels.

Regards
Guy

Report message to a moderator

Previous Topic:	COMPLEX SQL,NESTED
Next Topic:	Poor performance database.. pls help me

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 20:11:44 CDT 2024