Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

10 gb table versus 1 gb buffer cache

757299Mar 2 2010 — edited Mar 2 2010

If I have a 1gb buffer cache,when i query full table scan of 10 gb data.1gb will be stored in sga,but where will be the 9gb data stored whether it will be directly queried from data file and placed in pga for execution?

Edited by: user9252729 on Mar 2, 2010 8:36 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 30 2010

Added on Mar 2 2010

#cache, #general-database-discussions, #performance

4 comments

804 views