Re: dbwr high count of threads

Hi Richard,

A couple of questions.  

What version of Oracle?
What version of Solaris?
Are you using asynch I/O?
Are you on filesystems? If so, which one (ufs, vxfs, vxfs with quickio)? Have you specified ioslaves? If so, how many? How did you determine how many threads you were using? Is the entire database on NFS?
Is the server crash a Solaris crash or and Oracle crash?

Dave Miller

>X-Unix-From: Richard.Ji_at_MobileSpring.com Mon Sep 9 16:26:57 2002
>Date: Mon, 09 Sep 2002 14:18:24 -0800
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "Ji, Richard" <Richard.Ji_at_MobileSpring.com>
>From: "Ji, Richard" <Richard.Ji_at_MobileSpring.com>
>Subject: dbwr high count of threads
>X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
>Mime-Version: 1.0
>Content-Transfer-Encoding: 7bit
>
>Hi all,
>
>I noticed the dbwr process on Solaris has a very high number of threads
>(258).
>To me this is not a problem since I am seeing this on my small development
>box too.
>But we recently had some server crash and the consultant is saying Oracle is
>consuming
>a lots of resource, citing the high number of Oracle thread count from the
>core dump analysis.
>I don't believe this lead to the crash because the core stack trace points
>to NFS calls in both
>times.
>
>However, I don't know how to explain the high number thread count mostly
>from the dbwr process.
>Is this normal? I mean, it looks like it's normal since I see this on all
>of my instances.
>How do I convince him that this is ok?
>
>Thanks for your help.
>
>Richard
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ji, Richard
> INET: Richard.Ji_at_MobileSpring.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Tue Sep 10 2002 - 14:09:22 CDT