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

Home -> Community -> Usenet -> c.d.o.server -> Re: Why is UGA size so large?

Re: Why is UGA size so large?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Thu, 24 Mar 2005 21:52:08 +1100
Message-ID: <42429bd4$0$902$5a62ac22@per-qv1-newsreader-01.iinet.net.au> 





Marcel D?rr apparently said,on my timestamp of 24/03/2005 9:21 PM:



> Is the problem caused by PL/SQL cached cursors, session cached

> cursors, PL/SQL runtime overhead, PL/SQL global variables?

> How can I avoid that this much memory is used?

> 




are you using sort area by any chance?


-- 
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam


Received on Thu Mar 24 2005 - 04:52:08 CST












Original text of this message













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