How can i increase my PGA in database 11g

User_APT8X

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?

L. Fernigrini

You need to update the PGA_AGGREGATE_TARGET parameter

https://docs.oracle.com/cd/E18283_01/server.112/e17110/initparams188.htm

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