Greeting to Everyone ;
My db version is 10.2.0.4. I need some basic information about SGA components.
SQL> SHOW SGA
Total System Global Area 638670568 bytes
Fixed Size 456424 bytes
Variable Size 503316480 bytes
Database Buffers 134217728 bytes
Redo Buffers 679936 bytes
Question :
1) Exactly what is Fixed size and variable size in SGA. ?
2) Variable SGA is calculated following components : - Is this true ?
Database Buffer Cache”, “Redo Log Buffer”, “Shared Pool” and “Large Pool”
------------------------------------------------
I am getting confused from ask tom link ..
http://asktom.oracle.com/pls/asktom/f?p=100:11:108593526068146::::P11_QUESTION_ID:365088445659
Thanks in advance ..