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: Which background process regulates amount of pga memory per session in 10g ? Thanks, rm.

Re: Which background process regulates amount of pga memory per session in 10g ? Thanks, rm.

From: <Ranko.Mosic_at_gmail.com>
Date: 6 Sep 2005 05:56:43 -0700
Message-ID: <1126011403.502933.95690@f14g2000cwb.googlegroups.com> 





Just to add, did very quick ( possible incorrect ) trace on server
process ( connection ) - no sign of  malloc, brk or anything like that
to deal with session memory.


Where is actual resize/size done ?



Also , I have 1G of ram. Set SGA_TARGET to 5G - starts, no problem. Set
to 15000G - doesn't want to start. Where is limit calculated ? Also
granule size doesn't change, no matter how I play with SGA_TARGET (
contrary to Kyte's beta book ). 

 


rm.
Received on Tue Sep 06 2005 - 07:56:43 CDT












Original text of this message













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