Oracle Parameter (SGA_MAX_SIZE / SGA_TARGET)

[christian_laber2]

Hello together,

since yesterday we have a new oracle database on X64 (64BIT on Windows) with SAP R/3 4.7.

The server have 24GB ram and 2x quad Core CPU.

How can give me a good value for this parameters (for oracle)

SGA_MAX_SIZE

SGA_TARGET

I don't know what is a good size for such a hugh physikal memory!

Thank you

Christian

[stefan_koehler]

Hello Christian,

the parameter SGA_TARGET is "not longer" supported by SAP.

Take a look at sapnote #828268

At the beginning of oracle 10g we have activated the ASMM ... but there is still a bug with oracle 10g which results in a hang situation (solved in 11g ... no backport planned)

For more information regarding to the bug... take a look at bugnotes on metalink 4466399/4472338

SGA_MAX_SIZE should be a little bit higher than the sum of all your memory pools (SGA), because of you can extend some areas dynamically on the fly (if you are using a spfile).

Regards

Stefan

[christian_laber2]

Hello Stefan,

thank you for the note.

From my side this would be a great idea that ORACLE manage all his pools automaticly (depending on demand)

But ok.............!!

Can you give me an advice about the SGA settings??

I want to give Oracle (sga_max_size=7516192768) 7GB!!

DB_CACHE_SIZE??

SHARED_POOL_SIZE??

other one????

Thank you!

Christian

[former_member204746]

I use:

db_cache_size=3221225472

pga_aggregate_target=629146000

shared_pool_size=1610612736

sga_max_size is not set

just read SAP note 830576 to get a good idea.

[stefan_koehler]

Hello Christian,

>> Can you give me an advice about the SGA settings??

It is difficult to give you an advice without knowing something about the system / users / workload.

Monitor your buffer cache hit ratio / library cache hits and parses .... and increase the sizes accordingly.

Regards

Stefan

[christian_laber2]

Of course you're totally right!!!

For me I want to have ONLY a good starting value not a fine tuned system.......

Therefore I hope somebody can give me some experiences....

Thank you to all for helping me.

Christian