cancel
Showing results for 
Search instead for 
Did you mean: 

SGA Parameter Setting

former_member182034
Active Contributor
0 Kudos

hi all,

I want to set the value of below parameters against ECC6, Oracle 10205, Window server 2008 with( Processor Xeon 8C E7-2820 & 32GB Ram).

sga_max_size=

db_cache_size=

shared_pool_size=

pga_aggregate_target=

would you suggest me the value of these parameters.

and

which other parameter i have to set with respect to above parameter?

Regards,

View Entire Topic
Former Member
0 Kudos

Hi Majmali,

Please go through below link for oracle parameter recommendations.

[http://venkata-pagolu.blogspot.com/2011/07/server-parameters-for-oracle-9i-and-10g.html]

Regards,

Venkata S Pagolu