Database Tuning (MOSC)

MOSC Banner

Need to unset pga_aggregate_limit

edited Jul 27, 2020 5:00AM in Database Tuning (MOSC) 8 commentsAnswered

In my Environment  we have to unset pga_aggregate_limit ,As far i understand  pga_aggregate_limit  is hard limit , if pga_aggregate_limit is more than PGA_AGGREGATE_TARGET

Oracle sets the default by picking the biggest value from:

  • 2 GB or
  • 200% of the PGA_AGGREGATE_TARGET value or
  • 3 MB times the value of the PROCESSES parameter

In my environment ,pga_aggregate_limit  is less then pga_aggregate_target,

Question 1) IS it possible pga_aggregate_limit less then pga_aggregate_target

Question 2) if i unset what will be impact of that

SQL> show parameter PGA

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

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