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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Question about Automatic Memory Management

Re: Question about Automatic Memory Management

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 31 Aug 2006 17:33:25 GMT
Message-ID: <J4vI3v.9oJ@igsrsparc2.er.usgs.gov>


Dan wrote:
> We are running a 9i production database in which the parameter
> PGA_AGGREGATE_TARGET is set. By setting this we are enabling automatic
> memory management and thus, supposedly, disabling the usage of the
> *_AREA_SIZE parameters.
>
> Do the *_AREA_SIZE parameters get totally ignored when setting
> PGA_AGGREGATE_TARGET? We are concerned that they are still used,
> especially since we cannot set these values to null and then start up
> the database. Why do we have to give these parameters real values if
> they are being ignored? And if we give them values, are these values
> being used in ANY way? If they are used, is the area shared by all
> users or is each user dynamically allocated their own area at
> connect-time or execution time?
>
> Thanks,
> Dan
>

 From the Oracle docs....

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96524/c08memor.htm#14491

"With PGA_AGGREGATE_TARGET, sizing of work areas for all dedicated sessions is automatic and all *_AREA_SIZE parameters are ignored for these sessions."

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
Received on Thu Aug 31 2006 - 12:33:25 CDT

Original text of this message

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