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

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: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you should have a look at Database Concepts.

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


Current Time: Tue Dec 06 14:19:53 CST 2016

Total time taken to generate the page: 0.06270 seconds