Hi everybody,
I want to know how buffer cache works?
if my SGA Memory size is 10GB and my table size is 5GB, When i select the 5GB table it will fit into the buffer cache.
Reverse it.
If my SGA memory is 5GB and my table size is 10GB. If i select the 10Gb size of table. How the 10Gb size of table will fit into 5GB of buffer cache.
Please any one can explain me clearly how internal process will happen when table size is greater than SGA memory size ?