Re: intermittent very high waits in LGWR on Linux?

From: bugbear <bugbear_at_trim_papermule.co.uk_trim>
Date: Mon, 04 Jul 2005 10:11:31 +0100
Message-ID: <42c8fd47$0$41923$ed2619ec@ptn-nntp-reader03.plus.net>

Noons wrote:
> bugbear apparently said,on my timestamp of 1/07/2005 11:34 PM:
>

>>
>> Oracle is making heavy use of neither CPU nor IO!!!!
>> (and neither is anything else...)
>> It appears that the "log file sync waits" I'm seeing are more
>> like sleeps(). It ain't even tryin'.
>>
>> Since the LGWR is a separate process, I start to (again) suspect Linux
>> scheduling.
>>

>
>
> consistent with your finding on the semaphore.
> Something I forgot to ask: which exact version of
> 9ir2 you running?
> Logged on as SYSTEM, do a
> SELECT * FROM V$VERSION
> to find out.
> I'll see what I can dig from Metaclick on semaphores
> and Mandrake+Oracle to see if it is something to do
> with the specific Linux release.

  select * from V$VERSION
   2 ;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for Linux: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production

I am told (Ididn't do it) that installation was straight from the release, using the installer defaults for a "small" database.

    BugBear Received on Mon Jul 04 2005 - 04:11:31 CDT