Database Backup and Recovery (MOSC)

MOSC Banner

sga and memory parameter

edited Aug 8, 2019 6:10AM in Database Backup and Recovery (MOSC) 1 commentAnswered

Following Value is set in my environment,i understand memory_max_target and memory value .

my question ,memory_target=sga_target+pga_target,now in this sga_max_size is 2500m which is equal to memory_max_target and memory_target parameter.

This mean SGA_max_size is fix to 2500m (mean sga size move to 2500m,if it reach to 2500m hten what will be PGA

memory_max_target      big integer  2500M

memory_target      big integer          2500M

sga_max_size                                 2500m

NAME      TYPE VALUE

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

sga_target      big integer 0

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