| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: DBWR slaves in NT???
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-----
From: Raghu Kota [mailto:raghukota_at_hotmail.com]
Sent: Thursday, March 01, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Subject: DBWR slaves in NT???
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.
--
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). Received on Thu Mar 01 2001 - 13:22:08 CST
 |
 |