Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Multiple copies of the same block in the buffer cache
When I look in V$CACHE I often see multiple (2-6) copies of the same
block. Yes, I know that V$CACHE is an Oracle Parallel Server view,
and it is not even created by default during installation.
However, many people told me that V$CACHE is perfectly valid for
non-OPS instances. What really puzzles me is that there are
multiple copies of the same block even for the table that
is queried/updated by only one session.
Also, I noticed that the total number of rows in V$CACHE is slightly different from db_block_buffers. For example, I have db_block_buffers = 350,000 (database with 2K blocks) and select count(*) from v$cache returns 362,971. It may be a coincidence, but the difference between these two numbers (12,971) is approx. half of the total number of blocks with more that one copy (25,060). Received on Tue Mar 26 2002 - 00:55:00 CST