I am trying to understand how Oracle uses memory structure for tuning purpose. For that I ran a simple select against V$sga and like to know:
- What is the fixed size?
- What is the variable size?
area in the SGA.
How are these two areas in the SGA calculated? And, what is there use?