Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

"What are the risks of increasing pga_aggregate_target, is it safe to do?

edited Dec 6, 2018 3:29PM in Oracle Database Appliance (ODA) (MOSC) 3 commentsAnswered ✓

Hi MOSC,

Given:

plenty of available free memory in oda rac system (180 GB - after taking in account OS and all database/rac memory usage)

cluster database uses automatic shared memory mode

PGA comes from OS bucket

v$pga_target_advice show an increase in performance by adjusting PGA to 20GB

Now:

SGA 48 GB

PGA 08 GB

Will be:

SGA 48 GB

PGA 20 GB


Via:

alter system set pga_aggregate_target=20G scope=both sid='*';

Mgmt question;

"

If we increase pga;

     1) How safe is that action?

     2) What are the risks?

"

DBAs:
So far we just have;

As the parameter is dynamic, there is no concern or need for a database bounce so therefore no need for downtime and risking client productivity/access.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center