Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Calculating UGA size

RE: Calculating UGA size

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Tue, 19 Sep 2000 01:01:17 +1000
Message-Id: <10623.117248@fatcity.com>


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/

@

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: Schoen Volker [mailto:v.schoen_at_inplan.de] Sent: Monday, 18 September 2000 21:00
To: 'Oracle Lazy DBA list'; 'Oracle List' Subject: Q: Calculating UGA

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? Received on Mon Sep 18 2000 - 10:01:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US