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: 65144
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-01008 not all variables bound
Next Topic: Describe Sequence
Goto Forum:

Current Time: Sun Aug 20 18:14:50 CDT 2017

Total time taken to generate the page: 0.04340 seconds