| sga & pga optimum settings [message #314723] |
Thu, 17 April 2008 10:55  |
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 !.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
