Home » RDBMS Server » Server Administration » pga_size_shared_server_mode
- pga_size_shared_server_mode [message #60427] Fri, 06 February 2004 21:25 Go to next message
ahmad
Messages: 5
Registered: December 2002
Junior Member
plse advise me about the criteria to define a value for the pga of a database to be created in the shared server mode.

Report message to a moderator

- Re: pga_size_shared_server_mode [message #60430 is a reply to message #60427] Sat, 07 February 2004 04:57 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
In shared server mode,the UGA is stored in the large pool/shared pool and hence the number and size of the pga areas are likely to be lesser than in the dedicated server mode,but it still depends on the amount of sorting you do.
If you are in 9i, its recommended to use workarea_size_policy=auto and set the pga_aggregate_target depending on the number of shared servers/OS memory available/sort_area_size . You could monitor (pgastat etc) and adjust the values depending on the usage.

-Thiru

Report message to a moderator

Previous Topic: big doubt
Next Topic: tablespace reaches 70%
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 17 01:44:43 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.