Re: Strange processes showing up

DBWR_IO_SLAVES > 0. This is a bad thing. The IO slaves functionality really stinks and the alternative of DB_WRITER_PROCESSES > 1 is a much better mechanism, especially from 8i onwards. Both mechanisms are Oracle's own version of asynchronous I/O; is that enabled? If so, you might not need either...

You wouldn't want to set DB_WRITER_PROCESSES beyond CPU_COUNT if you choose to use it, I should think. You shouldn't assume that DBWR needs more power unless wait events such as "free buffer wait" or "write complete waits" are consuming significant portions of total response time...

Take a BSTAT/ESTAT or STATSPACK report and run it through the full-fledged YAPP processor on www.oraperf.com; it'll say for sure...

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, January 27, 2003 3:33 PM

> I just notice these ora_ixxx_sid processes on my server. Does anyone have
> an idea what they are? They didn't used to be there.
>
> oracle 18249 1 0 16:07:35 ? 0:00 ora_i106_cdwprd
> oracle 10664 1 0 15:36:38 ? 0:00 ora_snp3_cdwprd
> oracle 10650 1 0 15:36:37 ? 0:00 ora_ckpt_cdwprd
> oracle 10786 10783 1 15:37:14 ? 1:01 oraclecdwprd
> (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))
> )
> oracle 18243 1 0 16:07:34 ? 0:00 ora_i103_cdwprd
> oracle 10646 1 0 15:36:37 ? 0:00 ora_dbw0_cdwprd
> oracle 18267 1 0 16:07:36 ? 0:00 ora_i10e_cdwprd
> oracle 18265 1 0 16:07:35 ? 0:00 ora_i10d_cdwprd
> oracle 18255 1 0 16:07:35 ? 0:00 ora_i108_cdwprd
> oracle 10648 1 0 15:36:37 ? 0:01 ora_lgwr_cdwprd
> oracle 18251 1 0 16:07:35 ? 0:00 ora_i107_cdwprd
> oracle 10656 1 0 15:36:37 ? 0:00 ora_reco_cdwprd
> oracle 10662 1 0 15:36:37 ? 0:00 ora_snp2_cdwprd
> oracle 18271 1 0 16:07:36 ? 0:00 ora_i10g_cdwprd
> oracle 18269 1 0 16:07:36 ? 0:00 ora_i10f_cdwprd
> oracle 18263 1 0 16:07:35 ? 0:00 ora_i10c_cdwprd
> oracle 14655 1 20 15:53:45 ? 6:54 oraclecdwprd
> (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
> oracle 18241 1 0 16:07:34 ? 0:00 ora_i102_cdwprd
> oracle 10658 1 0 15:36:37 ? 0:00 ora_snp0_cdwprd
> oracle 18247 1 0 16:07:35 ? 0:00 ora_i105_cdwprd
> oracle 22069 22016 0 16:23:29 pts/5 0:00 grep cdwprd
> oracle 18261 1 0 16:07:35 ? 0:00 ora_i10b_cdwprd
> oracle 10642 1 0 15:36:37 ? 0:00 ora_pmon_cdwprd
> oracle 10654 1 0 15:36:37 ? 0:00 ora_smon_cdwprd
> oracle 10660 1 0 15:36:37 ? 0:00 ora_snp1_cdwprd
> oracle 18245 1 0 16:07:34 ? 0:00 ora_i104_cdwprd
> oracle 18321 1 0 16:07:44 ? 0:02 oraclecdwprd
> (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
> oracle 18259 1 0 16:07:35 ? 0:00 ora_i10a_cdwprd
> oracle 18257 1 0 16:07:35 ? 0:00 ora_i109_cdwprd
> oracle 10683 1 0 15:36:42 ? 0:03 ora_i201_cdwprd
> oracle 18237 1 0 16:07:34 ? 0:00 ora_i101_cdwprd
>
>
> R.Smith
> If you are not the intended recipient of this e-mail message, any use,
> distribution or copying of the message is prohibited. Please let me know
> immediately by return e-mail if you have received this message by mistake,
> then delete the e-mail message. Thank you.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).