Using the My Oracle Support Portal (MOSC)

MOSC Banner

How Buffer Cache Works

edited May 28, 2016 3:56PM in Using the My Oracle Support Portal (MOSC) Question

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.

.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center