Oracle Memory Allocation First the total allocation of memory is limited by sga_max_size and it has to be modified at spfile level so requires a db restart. To look at sga_max_size
to chane it
Then all memory is getting allocated from sga_target the size of it can be set during runtime (assuming it is not larger than sga_max_size). to look at sga_target
to change:
look at current allocation status live
|
OracleDB >