Re: SPIN_COUNT Parameter
Date: Tue, 6 Sep 1994 17:18:53 GMT
Message-ID: <brosalesCvpxFH.10s_at_netcom.com>
hemant_at_shakti.ncst.ernet.in (STOCKHOLDING CORPORATION OF INDIA LTD.) writes:
>I have found this parameter in both V6 and V7 databases.
>What does it do ? The default value is 2000.
>Can it be tuned ?
This parameter should be tuned for machines with multiple CPU only. It sets the number of times Oracle attempts to get a latch before sleeping. If a latch is busy, Oracle spins and checks back with the latch availability up to spin_count number of times. If spin_count is met and latch is still un-avail, it sleeps and then retries later.
Thus for high value of spin_count, you may get a latch sooner but at a cost of CPU time.
You should get stat on latch contention before tuning this parameter.
Robert Rosales
Sonica Software Corp
brosales_at_netcom.com
>I have found this parameter in both V6 and V7 databases.
>What does it do ? The default value is 2000.
>Can it be tuned ?
Received on Tue Sep 06 1994 - 19:18:53 CEST