high paging slowing down ERP6 on Oracle solaris

[Former Member]

Hello expert

we are having a problem with the oracle system (i think) as there is too much paging at OS level.We are running oracle 10.0.2.4 on Sun zones,Sun 10g.We check ed the parameters as per note 724713 and it seems to be ok

the allocated mem is :16G ,swap is 130GB,

If i run prstat it shows that orasid and sidadm is using 35GB of ram yet the total ram is 16gb.

the sizes for sga_max_size=317108517437

shared_pool_reservered_size=1855425871

shared_pool_size=18554258718

is there anywhere i need to adjust

[Former Member]

Hi,

Am I reading that right you sga_max_size is 31GB ? an why when you have only got 16GB

what's you db_cahe set to ?

Mark

[Former Member]

thanx Markus

db_cache_size=18554258718

[Former Member]

sorry Mark not Markus

[Former Member]

Hi,

That;s 18GB ! no wonder you swapping....

With only 16Gb to play with I waould do the following

db_cache_size=2097152000 = 2GB

sga_max_size=3338665984 = 3GB

and see how that runs...

Mark

[Former Member]

LOL do not mistake me for the wise old sage...!

[Former Member]

so should i edit the init.ora file with the new values or use the alter command.may you just confirm the commands so that i am sure if iam doing it right

[Former Member]

Hi,

You will need to edit the init<SID.ora or Spfile.ora......But note if you are running the Spfile youwill need to alter that throught sqlplus as commands do not do it directly.

Restart the database.

Mark

[Former Member]

LOL looks like we have too many names with Mark..... here!!!!

[Former Member]

i have changed it with the following comand :

sqlplus

connect / as sysdba

alter system set sga_target = 3338665984;

then it said system altered.

but still its picking up 35GB

[Former Member]

Restart the database

[Former Member]

i did restart the database stopsap all;startsap all and then rebooted the server

i dont know if i was suppossed to use shutdown in sqlplus

[Former Member]

That should be enough, especailly if you rebooted the server...

Your memory should look much healthier now!

Mark

[Former Member]

no luck its still picking memory size

[Former Member]

Hi,

Sorry you must have not done it right...

Check the physical files Spfile will be read in init<SID>.ora will only be used if SPffile is not their.

did you change the db_cache size as well ???

Mark

[Former Member]

what is the command line to use as i think its using the spfile.if i check init,ora there is no sga parameter,initsid.ora and spfile the entries are there.

if i can alter the spfile i think it might work

[Former Member]

Also look at your SAP profile parameters.

You may want to set the PHYS_MEMSIZE parameter in your instance profile:

By default SAP tries to utilize all the resources on teh server it installed on. If Oracle is also expecting to have these resources, one or the other will be hogging memory and causing paging.

I would set the PHYS_MEMSIZE parameter to be half the system physical memory, in MB, so if you have 16GB I would set it like this:

PHYS_MEMSIZE = 8192

[Former Member]

i reinstalled and fixed the problem