Home » RDBMS Server » Performance Tuning » SGA and PGA
SGA and PGA [message #273829] Thu, 11 October 2007 17:42 Go to next message
Messages: 11
Registered: May 2007
Junior Member

For the purpose of this question I am using a random number for pga and sga settings.

In 10G if the work_area_size is set to AUTO. pga_aggregate_target set to 100 mb
sga_target set to 100 mb

Total available ram on the server 1 gig.

Even though the work area is set to auto does the target size setting mean that the pga and sga cannot use more than 100 mb each?
Re: SGA and PGA [message #273851 is a reply to message #273829] Fri, 12 October 2007 00:05 Go to previous message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you should have a look at Database Concepts.

Previous Topic: sample size in user_table
Next Topic: slow in all aspects
Goto Forum:

Current Time: Mon Oct 24 00:39:29 CDT 2016

Total time taken to generate the page: 0.09839 seconds