Oracle #DB12c New – PGA_AGGREGATE_LIMIT

Program Global Area (PGA) in Oracle database is a private memory region that contains the data and control information for a server process. PGA is allocated per server process, used for storing run-time area of cursor, sorting, bitmap merge, etc. Automatic PGA management in Oracle Database was managed by two parameters up until 11gR2 – … Read more

Oracle Tidbits – April 2015

“Oracle *daily* TidBits” (#oratidbit) published at https://www.facebook.com/oraclenotes on weekdays in April 2015. You will also see these tidbits, one tidbit at a time, for each page refresh on the right side of this blog as well… Hope you find these helpful to learn something new or to remind you of its existence and use… Publish Date TidBit 2-Apr #oratidbit … Read more