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?

Report message to a moderator

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

Regards
Michel

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jun 25 20:09:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.