RE: DBWR slaves in NT???

Hmmmm...I don't know how pounding a single drive with two threads instead of one would help, but it could be tried. I would think that the LGWR would be the big complainer in a 1-disk config, instead of the DBWR. Or at least I think LGWR would complain more often...

My post was simply to point out that the error message in TOAD about "Number of DB_FILES set too high" was inaccurate. And as the "Tuning" stuff in TOAD has been redone, at least in the latest TOAD v7 Beta, this error message won't be a hassle too much longer.

Long live Toadman Jim! :)

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Kevin Kostyszyn [mailto:kevin_at_dulcian.com]
> Sent: Thursday, March 01, 2001 14:09
> To: Multiple recipients of list ORACLE-L
> Subject: RE: DBWR slaves in NT???
>
>
> If I am completely off the wall here just slap me around a
> little bit. But
> couldn't you play with the init parameteres DBWR_IO_SLAVES or
> DB_WRITER_PROCESSES to help improve write performance? I
> mean, I agree with
> Ross, there is only one disk, but maybe it could help a little to help
> simulate asynchronous I/O?
> Kev
> Just thinkin out loud again!
>
> -----Original Message-----
> Sent: Thursday, March 01, 2001 2:31 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Actually, that message is invalid for Oracle8 DBs. From what
> I can gather,
> the DB_FILES init.ora parameter only
> potentially affected DBWR performance in Oracle7. In
> Oracle8, it ain't
> true.
>
> Remember, the DBWRs write dirty buffers (data in memory that has been
> modified from it's counterpart in a datafile) from the buffer
> cache (memory)
> to the datafiles (disk). In O7, the DBWR I/O clump size, or
> how many dirty
> blocks could be written at once (also sometimes referred to
> as the DBWR's
> "internal write batch size"), was calculated as:
>
> DB_FILE_SIMULTANEOUS_WRITES*DB_FILES/2.
>
> In O8, the DBWR I/O clump size is static, and is different
> from platform to
> platform. Thus, for Oracle8, the advise to change DB_FILES is bogus.
>
> HTH!
>
> Rich Jesse System/Database Administrator
> Rich.Jesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
> Disclaimer: After taking the Oracle8 Perf Tuning class, I
> think I know more
> than I do. Don't blame me for your (in)actions based on my opinion!
>
> -----Original Message-----
> Sent: Thursday, March 01, 2001 12:27
> To: Multiple recipients of list ORACLE-L
>
>
> not a dbwriter problem.
> on a "single-disk wonder", your best
> bet is to DUMP all indexes on loadable
> tables, then load your data, then rebuild
> the indexes.
> of course, that might take just as long.
> any possiblity of getting more disk?
> like, several? a raid controller?
> mit gluck!
>
>
>
> -----Original Message-----
> Sent: Thursday, March 01, 2001 11:26 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi Friends
> I have toad tool for my NT database
> DBWR Average Scan Depth 1024 **Number of DB_Files too high??
> I got doubt due to from v$waitstat I got data block waits
> some time 8000 and
>
> some times higher number. How can I increase the DBWR slaves on NT??
> although I set in development box, How can I see as background process
> really working for me??
> I have my datafile and indexes same on E disk drive, My hit
> ratios are okay,
>
> My import is killing me.
> Any help appreciated.
> Thanks
> Raghu.
> ______________________________________________________________
> ___________
> Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raghu Kota
  INET: raghukota_at_hotmail.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).


------------------------------------------------------------------------

This message has been scanned for viruses with Trend Micro's Interscan
VirusWall.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Kevin Kostyszyn
  INET: kevin_at_dulcian.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).


------------------------------------------------------------------------

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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).