Home » RDBMS Server » Server Administration » sga & pga optimum settings (Database, Oracle 10g rel 2, windows server 2003)
sga & pga optimum settings [message #314723] Thu, 17 April 2008 10:55 Go to next message
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:

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: 63937
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Advisor says one value, you say (and I agree) you can't set this, so stay to your maximum.

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

Current Time: Thu Oct 27 19:45:38 CDT 2016

Total time taken to generate the page: 0.09624 seconds