| pga_size_shared_server_mode [message #60427] |
Fri, 06 February 2004 21:25  |
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.
|
|
|
|
| Re: pga_size_shared_server_mode [message #60430 is a reply to message #60427] |
Sat, 07 February 2004 04:57  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
