Discussions
Categories
- 384.6K All Categories
- 2.5K Data
- 556 Big Data Appliance
- 1.9K Data Science
- 451.4K Databases
- 222.1K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 32 Multilingual Engine
- 562 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 561 SQLcl
- 4K SQL Developer Data Modeler
- 187.5K SQL & PL/SQL
- 21.4K SQL Developer
- 296.9K Development
- 1 Application Development
- 18 Developer Projects
- 140 Programming Languages
- 293.6K Development Tools
- 112 DevOps
- 3.1K QA/Testing
- 646.2K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 193 Java Community Process
- 106 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 21 Java Essentials
- 167 Java 8 Questions
- 86K Java Programming
- 81 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 206 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 537 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 178 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 236 Portuguese
How can i increase my PGA in database 11g
User_APT8X
Member Posts: 2 Red Ribbon
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
-
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
