on 01-18-2009 4:29 PM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.