Re: definition of "buffer is pinned count"

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Thu, 07 Jun 2007 12:49:16 -0700
Message-ID: <1181245756.910959.192340@h2g2000hsg.googlegroups.com>

On Jun 7, 2:08 pm, wagen..._at_yahoo.com wrote:
> Oracle10g 10.2.0.2
> RHEL AS 4.4
>
> buffer is pinned count - the number of times a single DB operation
> (ex. select) REVISITS the same block in the SGA (buffer).
>
> Is this correct?
>
> Thanks
> wagen

BUFFER IS PINNED COUNT: Number of times a buffer was pinned when visited. Reports the number of times Oracle visited a data buffer without the expense of having to first use a latch.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Thu Jun 07 2007 - 14:49:16 CDT