Re: identify buffer data

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 23 Jan 2007 04:56:24 -0800
Message-ID: <1169556984.087808.120370@j27g2000cwj.googlegroups.com>

Steve Robin wrote:
> Is there any way to identified how many tables and records are in DB
> buffer cache.

It is possible to determine what objects have blocks in the buffer cache and the number of blocks, but not number of rows contained in the blocks (at least not easily). See:
http://jonathanlewis.wordpress.com/2006/11/02/but-its-in-the-manual/

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Tue Jan 23 2007 - 06:56:24 CST