Shared_Pool_Size

All posts relating to Oracle database administration.

Moderator: Tim...

Shared_Pool_Size

Postby Guest » Mon Nov 01, 2004 6:09 pm

I installed a server with two processors and 4 GB of RAM, I used the Red Hat Advanced server 2,1 and Oracle 9.2.0.1 In the hour to create the init.ora appeared the following doubts. - as to change the following parametrers, it follows the values that I placed.


db_cache_size=32
shared_pool_size=1260M
sga_max_size=1700M


The result is the following one:

Connected to an idle instance.
ORACLE instance started.

Total System Global Area 1796282304 bytes
Fixed Size 452544 bytes
Variable Size 1761607680 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
Disconnected from Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production


It would like to understand this, to see if these values are correct. Obs.: I tried to make a procedure of oracle of tuning, that to modify the value of ksms.o (genksms - s 0x15000000 ksms.s) ai I noticed that the instancia does not go up will be with shared_pool_size with more than 500M, when I come back the value of ksms.o toward 0x50000000 and make relink again it leaves I to more than go up the instancia with 500MB that is mine in case that I am going up with 1260M.


Or either which the best value of my parameters of the init.ora?


Tank´s
William Pardal - Brazil
Guest
 

RE:Shared_Pool_Size

Postby Tim... » Mon Nov 01, 2004 6:09 pm

Hi.

That is a seriously big shared pool!. I think you would be better server setting it to about 1 tenth the size and using the space for the db cache like:

db_cache_size=1100M
shared_pool_size=150M
sga_max_size=1700M

The db cache holds the cached data so it generally needs more space than the shared pool. Making the shared pool too big can reduce performance as the cleanup algorithms can become less efficient. Experiment from this base.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17936
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 7 guests

cron