Re: Monitoring questionable long running sessions

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Tue, 13 Jul 2004 00:44:18 +0200
Message-ID: <bp46f055ee84m0tc77mvq68t6730qhu90k@4ax.com>

"VC" <boston103_at_hotmail.com> wrote:

>> I read something about mad "spinning" CPU.
>
>Never heard about anything like that.

I will try to give a rough explanation. When some kind of resources are accessed, a latch is needed. If the latch is not acquired, Oracle can decide to "wait", and in the meanwhile, the CPU can be used for something else, or it can decide to "spin", which means that it goes through a loop and then does a retry. Due to some error, the CPU gets caught spinning indefinitely.

You could find related issues at Metalink.

Bye
Rick Denoire Received on Mon Jul 12 2004 - 17:44:18 CDT