Buffer use under Oracle

From: Binyamin Dissen <bdissen_at_dissensoftware.com>
Date: Wed, 12 May 2004 15:11:20 +0300
Message-id: <2k44a0dd5qb3c9ud0rokgufo2099rkgble@4ax.com>

I am trying to investigate why a large number of buffers are being used by a certain index.

At the present time, the heavily inserted/deleted table has 10 rows, but according to V$BH the index is using 6000 buffers.

V$BUFFER_POOL_STATISTICS indicates that there are many searches for a free buffer going on.

None of the rows in V$BH have a non-zero value in forced_reads or forced_writes.

The vast majority have a V$BH status of XCUR.

Why isn't Oracle reusing these buffers for other processing?

How can ten index records use that much buffer space?

What should I be looking at?

--

Binyamin Dissen <bdissen_at_dissensoftware.com> http://www.dissensoftware.com

Director, Dissen Software, Bar & Grill - Israel

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Wed May 12 2004 - 07:08:27 CDT