Oracle Memory related parameter values..

[Former Member]

Hi experts,

I have installed SAP on Oracle 10G 10.2.0.4 patch level.

i want to know How can i set the oracle memory parameter? any calculation behind it or other techninque.

server Memory around 32 GB

oracle installed on 16 GB + 16 GB for SAP instance.

because currents

SAG_MAX_SIZE=3GB

DB_CACHE_SIZE=1 GB

Shared_POO=500 MB

Due to which Buffer Quality hit ration not more then 74%.

Please guide & thanks in advance.

Regards

Vivek

[Former Member]

You can monitor SGA and PGA related details in DBACOCKPIT transaction: Performance->Statistical Information->SGA Monitor (PGA Monitor). In SGA Monitor:

1) check Cache advisory stat -> Size for estimation to adjust db_cache_size

2) check Shared pool advice -> Size for estimation to adjust shared_pool_size

In PGA Monitor check PGA Advice tab

For more detail about adjust these parameters see oracle documentation

Regards

Roman

[Former Member]

Hi Vivek,

As a rule of thumb, 1/3 of physical memory should be reserved to the Oracle. I suggest you plan to reserve 8 GB to Oracle, 4 GB to OS and 20 GB to SAP on physical memory.

You can configure dynamic storage management (Dynamic SGA) by the Oracle 9i and the further releases. You can find the further information, below;

Note 617416 - Oracle9i: Dynamic SGA

If you use dynamic SGA, you don't need to configure DB_CACHE_SIZE, SHARED_POOL_SIZE and LARGE_POOL_SIZE parameters.

If you are planning to set static values, I suggest you reserve 6GB to db_cache_size and 500MB to shared_pool_size. Of coursei you need to monitor the numbers and revise the configuration, periodically.

>> Due to which Buffer Quality hit ration not more then 74%.

There can be many reasons to have low buffer quality, for example not enough memory reserved to database cache or executing different select statements not in the SQL cache or so on. It needs to be investigated, in more detail.

Best regards,

Orkun Gedik

[former_member185257]

please check sapnote 1166258 and 830576.

[Former Member]

I read both of notes but not got any thing regarding memory parameter tuning.

Please help