• From: SJHussain@xxxxxxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 24 Aug 2004 11:29:33 +0300


I was just read Oracle Metalink Note 223730.1 Automatic PGA Memory
Management in 9i. There is a recommended formula for setting PGA on OLTP
and DSS systems. I am interested in OLT system only.
For OLTP the folurma is PGA_AGGREGATE_TARGET = (<Total Physical Memory> *
80%) * 20%

I just want to ask you people, how accurate is this formula?

Best Regards,

Syed Jaffar Hussain

Visit us on
======  Banque Saudi Fransi - Privacy Notice  ======
This message is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material. Any
use of this information by persons or entities other than the intended
recipient is prohibited.  If you have received this in error,  please
contact the sender and delete the material from  your computer.  Any
opinions and other information  contained in this message that do not
relate to the official  business  of  Banque  Saudi  Fransi shall be
understood as neither given or endorsed by it. Although precautions
have been taken to ensure no viruses are present in this email, BSF
cannot accept responsibility for any loss or damage arising from the
use of this email or attachments.
======  Banque Saudi Fransi - Privacy Notice  ======

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: