| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Calculating UGA size
Hi, Steve,
I wonder if it helps with a sum of runtime and persistent memory from v$sqlarea:
select parsing_user_id, sum(persistent_mem+runtime_mem)
from v$sqlarea
group by parsing_user_id;
But I noticed the value returned is very much higher than the sum of session uga memory (max or not) for the corresponding users. Probably because UGA is only a small part of PGA, which is what my persistent_mem+runtime_mem is?
Best regards,
Yong Huang
yong321_at_yahoo.com
you wrote:
Hallo Volker,
The UGA size is dependent on both the SQL issued by the session, and the data returned, as well as the parameter settings. So there is no "formula" that can be used to predict the UGA size. Instead, you should test the application, measure the UGA size for a representative and extrapolate. To measure the UGA size, look at the 'session uga memory max' statistic in V$SESSTAT.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
@
-----Original Message-----
Sent: Monday, 18 September 2000 21:00
To: 'Oracle Lazy DBA list'; 'Oracle List'
Hi list,
I want to calculate the user global area in dedicated server configuration. Can't find how to calculate the needed RAM per user process in Oracle documentation. Is there any formula to calculate this?
 |
 |