Database Administration (MOSC)

MOSC Banner

How to set PGA size ?

Hello everybody ,

I have read in oracle support the SGA and PGA must be not exceed 75% . My question let's suppose I have 100 GB Of RAM . I will allocate 50 GB for total of (SGA and PGA) . What is the percentage of the size of PGA size from 50 GB ?

also suppose I set 1000 for session .

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