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.
--
Cheers
Nuno Souto
in sunny Sydney, Australia
wizofoz2k_at_yahoo.com.au.nospam
Received on Sat Jul 02 2005 - 06:17:52 CDT
