PGA has remained quite an unknown area for the DBAs who have started working in Oracle databases from version 9i onwards. PGA_AGGREGATE_TARGET has made life easier still databases keep on hitting out of memory errors like ORA-04030. In this presentation, we will be discussing more about basic concepts and mechanisms of PGA, covering the PGA components, discussing the various reasons of ORA-4030 and the methodology to fix it.
A senior technical analyst with Oracle Support Group, Mansvi Sharma has around 9 years of experience in database operations. An Oracle Certified Master (11g) and Oracle 11g RAC and Grid Infrastructure Expert, he specializes in troubleshooting and resolving memory and Oracle Internals issues. He has presented in various forums like Sangam 13 and other events in India on Oracle database technologies.