Home » RDBMS Server » Performance Tuning » shared pool doubt..?
shared pool doubt..? [message #153906] Wed, 04 January 2006 15:03 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jan 07 03:44:21 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.