Home » RDBMS Server » Server Administration » sga & pga optimum settings (Database, Oracle 10g rel 2 10.2.0.1.0, windows server 2003)
sga & pga optimum settings [message #314723] Thu, 17 April 2008 10:55 Go to next message
joemcglynn
Messages: 3
Registered: November 2007
Junior Member
Hi all,

I am having trouble identifying the optimum SGA and PGA settings for a data-warehouse style application.

We have a 10g rel2 database running on a windows server 2003. The server RAM is 2G, with 2 CPU's. Nothing else to note is running on this server.

The application is running 7 similtaneous scheduled jobs, each of which is extracting data using a dblink from a progress database using datadirect odbc driver. The dblink\odbc\progress part of the equation is working fine.

current settings are:
SGA_MAX_SIZE=1577M
PGA_AGGREGATE_TARGET=300M
SGA_TARGET=1098M

OEM addm is advising increasing SGA_TARGET to 1834M - which obviously will not work (1834 >1577) and I dont want to increase SGA_MAX_SIZE above (2000M - 20%) = 1600M

Any advice much appreciated !.
Re: sga & pga optimum settings [message #314729 is a reply to message #314723] Thu, 17 April 2008 11:41 Go to previous message
Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Advisor says one value, you say (and I agree) you can't set this, so stay to your maximum.

Regards
Michel
Previous Topic: ORA-01034: Oracle Not Available (merged)
Next Topic: CPU Apr2008
Goto Forum:
  


Current Time: Sun Dec 08 18:58:20 CST 2024