cancel
Showing results for 
Search instead for 
Did you mean: 

sizing of PGA_AGGREGATE_TARGET parameter.

Former Member
0 Kudos

Hi,

My SAP is on oracle 10g. It ic currently having a PGA_AGGREGATE_TARGET parameter sized at 25MB. The earlywatch report is giving a warning for the current size. . In EWA report, the ideal value is given as 20% of total memory available for oracle. could you please suggest how to determine the right size for this parameter or even how to find out the total memory available for oracle.

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

Hello,

>

In EWA report, the ideal value is given as 20% of total memory available for oracle. could you please suggest how to determine the right size for this parameter or even how to find out the total memory available for oracle.

Well, you got the information on the EWA. You can find the details of the EWA recommendation on the following SAP note

619876 Oracle9i: Automatic PGA Memory Management

Step 1: Calculating/estimating a good start value

The following general recommendations apply to a standalone database server:

For Data Warehouse:

PGA_AGGREGATE_TARGET = <Total physical memory> * 40%

For OLTP:

PGA_AGGREGATE_TARGET = <Total physical memory> * 20%

If you have a standalone database server, you use the server memory.

If you are sharing the server with other application, then you have to deduct the memory used by the other applications from the server memory.

In any case, the total memory used by oracle (and other applications) should never be higher than the physical memory, you do not want to swap to disk.