Database Tuning (MOSC)

MOSC Banner

Why don't blocks show up in the buffer cache after performing a query?

edited Nov 2, 2016 5:00AM in Database Tuning (MOSC) 5 commentsAnswered

I performed a query (see below) to view the contents of my buffer cache to see how much of a particular table was cached.  I noticed the table/object wasn't returned in the query.  I wrote a SELECT * FROM tabname and then re-performed the query and noticed that there were still no blocks in the buffer cache from the table ("tabname") that I just queried.  Why is this happening?  Why don't I see any blocks in the buffer cache?

Thanks,

Greg

select

s.owner owner,

object_name objname,

subobject_name subobjname,

substr(object_type,1,10) objtype,

ts.block_size / 1024 blockkb,

buffer.blocks blocks,

Tagged:

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