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 .