Database Tuning (MOSC)

MOSC Banner

How does Oracle locate blocks in db cache buffer

edited Sep 24, 2010 4:30PM in Database Tuning (MOSC) 6 commentsAnswered ✓
 Hi All,

Today I was asked one question how oracle located one or more blocks in db cache buffer.

I found that I hadn't learnt or tried to learn exact process in which Oracle located one or more blocks in db buffer cache.

Could someone point me some useful web pages that talk about this process, please?

For example, for a full table scan, Oracle must first locate the first block of one table and then scan all other blocks sequentially.

How dose Oracle know the address of the first block?

Thank you very much in advance.

Leon

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