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: 4 Sep 2005 15:28:05 -0700
Message-ID: <1125872885.857012.92910@g14g2000cwa.googlegroups.com> 





If pga_aggregate_target is set to some value ( say 50M ) when total PGA
for all sessions


reached 50M then subsequent memory allocations for PGA are smaller then
initially.


Which process does that ? Does server process ( session ) check what
amount of PGA


it can allocate ? Or there is something similar to MMON that regulates
SGA ? 


rm
Received on Sun Sep 04 2005 - 17:28:05 CDT












Original text of this message













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