OraFAQ Forum: Performance Tuning » Need help with shared pool sizing

Home » RDBMS Server » Performance Tuning » Need help with shared pool sizing (8.0.6, windows 2000 server)

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

Need help with shared pool sizing [message #468815]

Mon, 02 August 2010 04:36

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

HI,

Could someone please tell me how to increase the library cache size as there is lot of free space in shared pool.

I guess incresing the size of shared pool is one option. Since, there is atleast 180-210MB free space, is the above option a good one?

Please advice.


SQL> select * from v$sga;

NAME                     VALUE
-------------------- ---------
Fixed Size               52144
Variable Size        346710016
Database Buffers     701235200
Redo Buffers           4104192

Report message to a moderator

Re: Need help with shared pool sizing [message #468864 is a reply to message #468815]

Mon, 02 August 2010 05:41

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Could someone please tell me how to increase the library cache size as there is lot of free space in shared pool.

Why do you think you need to increase it and not another part of SGA?

Regards
Michel

Report message to a moderator

Re: Need help with shared pool sizing [message #468873 is a reply to message #468864]

Mon, 02 August 2010 06:20

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

I have been observing since last few days that the library cache miss rate is increasing slowly all day. I guess this might be the problem. Please advice ..

Report message to a moderator

Re: Need help with shared pool sizing [message #468896 is a reply to message #468873]

Mon, 02 August 2010 08:00

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Insufficient data to compute.

Regards
Michel

Report message to a moderator

Re: Need help with shared pool sizing [message #468912 is a reply to message #468896]

Mon, 02 August 2010 08:38

ultgnp
Messages: 106
Registered: May 2010
Location: Germany

Senior Member

Please tell me if its possible to make shared pool use the available free space (180MB) for other parts of shared pool.

Report message to a moderator

Re: Need help with shared pool sizing [message #468920 is a reply to message #468912]

Mon, 02 August 2010 08:48

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is automatic you have nothing (although you have a so old version that I don't remember exactly what is the algorithm in this version).
Anyway, you still don't know if you have any REAL problem.

Regards
Michel

Report message to a moderator