How Buffer Cache Works
Hi Everyone,
Hope you are all doing good.
I Have a query regarding the buffer cache mechanism.
If my SGA size is 10Gb and My table size is 20Gb. I have fired a query select * from <my_table_name>;
can anyone please explain me clearly how internal process will happen when table size is greater than SGA memory size ?
Thanks in advance.
Regards,
Satya Kadarla.
.