Does Select uses DB_buffer_cache?

Hello:

Just curious to know, if Select statement with full tablescan (No indexes are used or not existing based on CBO) uses db_buffer_cache?

If the table is indexed and if server process using indexes to fetch data then, definitely it has to use db_buffer_cache? Isnt it?

Thanks, ST2003

Does Select uses DB_buffer_cache? Do we need air to breathe?

You can't get anything out of oracle database that hasn't been read out of buffer cache. No matter if your query uses indexes or does a FTS, no matter if it need to perform any physical read or not, every single row that it returns to you is read from buffer cache.

I'm unclear on exactly what your question is, but if any of the blocks of the table are available in the buffer then they will be read from it, not from disk -- if they are not available in the buffer then they will be read into it.

You would probably benefit from a cover-to-cover read of the concepts guide -- it would give you a very solid grounding in many of these detailed "how does Oracle do that" issues .

what you need is RTFM

Thanks Guys.. I know this for sure.. but the lead dba in my company confused me and I just kept quiet. I did not argue and I checking with you guys..

Client process submits request to server process
server process takes it to the db buffer cache
transaction starts-all locks get applied automatically
throws into RBS, if DML
Data is processed in DB Buffer Cache, based on the DML and exec path.
After Parse, Exec and fetch is done.. by server proc to user process.
If Update or Delete, then it also gets to RedoLog buffers..

I was expecting an Yes/No but I get the point..

ST2003

Quote:

---

Originally posted by st2003
Thanks Guys.. I know this for sure.. but the lead dba in my company confused me and I just kept quiet. I did not argue and I checking with you guys..

---

I think your Senior/Lead DBA needs..

Quote:

---

Originally posted by pando
what you need is RTFM

---

:D :D