Re: Spin count

From: Martin Rapier <M.Rapier_at_shef.ac.uk>
Date: 1995/07/17
Message-ID: <3uduup$kk4_at_hippo.shef.ac.uk>#1/1


davids_at_software.mitel.com (David So) wrote:
>
>Hi,
>
>I was told that "Spin count" which is a hidden parameter
>in Oracle7 init.ora.
>
>Can someone explain what it is?

As far as I am aware it controls how long oracle waits when it requests a latch with a willing-to-wait request (as opposed to an immediate request), and the latch is not available. According to my tuning course, the default is 2000 (milliseconds ?). I didn't know it was now undocumented, but I'm not sure you would gain much by fiddling around with it.

Latches are used to regulate access to internal resources such as the redo log buffer. You can check out latch activity with V$LATCH.

Cheers.
Martin. Received on Mon Jul 17 1995 - 00:00:00 CEST

Original text of this message