Limiting PGA with PGA_AGGREGATE_LIMIT in Oracle 12c


In Oracle 12c, a new interesting much needed feature, has been introduced which controls the maximum amount of the PGA memory consumed by the user processes. The PGA_AGGREGATE_LIMIT parameter limits the amount of memory used by processes in the PGA.

Setting up Oracle 12c Active Data Guard Database

In the Multitenant world, the PDB Database is considered an independent database but the operational tasks performed at the CDB level effect all the PDB databases plugged into it. The task of setting up of a Data Guard, switching or failing over are all performed at the CDB level. When the Data Guard is initially setup, with the CDB database, all PDB’s are also replicated to the target. Read more here.

Oracle 12c Silent Mode Binary Install and De-install

Installation of the Oracle Binaries is a pretty simple task for the DBA’s. However the process may become exhaustive if you are repeatedly performing these installs on a number of servers.