Forum Stats

  • 3,855,310 Users
  • 2,264,499 Discussions
  • 7,905,967 Comments

Discussions

How can i increase my PGA in database 11g

User_APT8X
User_APT8X Member Posts: 2 Red Ribbon
edited Feb 16, 2022 5:19PM in General Database Discussions
Actually i have an intances on database 11g

 I've received the error ORA-600[723] that refers to the PGA problem, 
 that is, the demand for sessions has been saturated. 
 How can I increase this memory?

Answers

  • L. Fernigrini
    L. Fernigrini Data Engineer Sr Consultant Member Posts: 4,026 Silver Crown

    You need to update the PGA_AGGREGATE_TARGET parameter


    you need to be sure that you actually have enough free memory to be used. Oracle uses SGA + PGA and the O.S. will need also some memory, so you have to size the SGA and PGA properly, depending on how much memory intensive are the sessions that connect to the database.

    For example, on a 64Gb RAM server, you may leave 4 gb for the O.S, and then size the SGA and PGA, for example you can size SGA on 48Gb and leave 12Gb for PGA. If the PGA is not enough, you need to reduce SGA and allocate more for PGA, or viceversa