You might get ORA-02097 while changing PGA_AGGREGATE_LIMIT.

To set PGA_AGGREGATE_LIMIT we should take care of following allowable values :

  • 2 GB (default value)
  • 200% of the PGA_AGGREGATE_TARGET value
  • 3 MB times the value of the PROCESSES parameter.
  • Less then 1.2 X RAM – SGA

Here In my case I am changing value according my processes parameter.

Processes parameter contains 2000 process.

So PGA_AGGREGATE_LIMIT=2000*3MB

Thate is 6000 MB that is less than 6144 MB.

Stay tuned for More articles on Oracle RAC 

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply