How did you check?
There are only blocks in buffer chache. Normally, they are part of
some segments or other structures.
you should be able to see which blocks are in the cache in x$bh table.
Note that there will be always some blocks even after flushing as
cache is the only way to read anything (direct IO doesn't count) so
any SELECT statement should basically cause some blocks to be loaded
into cache.
Plus on flushing Oracle obviously wouldn't be able to flush blocks
that are held in some incompatible mode.
All is IMHO - never tested this behavior.
2005/11/10, DBA Deepak <oracle.tutorials_at_gmail.com>:
>
> Hi All,
>
> Want to know what kind of objects does the
>
> alter system flush buffer_pool;
>
> flush out of the buffer_cache in 10g;
>
> I tried to flush the cache but when i queried the buffer cache afer flushing
> still the user objects exist in the cache.
>
> NO OTHER USERS ARE CONNECTED.
> --
> Regards,
>
> Deepak
> Oracle DBA
--
Best regards,
Alex Gorbachev
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 10 2005 - 13:31:05 CST
