Message-Id: <10680.122027@fatcity.com>
From: "Tom Pall" <tom@cdproc.com>
Date: Tue, 14 Nov 2000 13:03:06 -0600
Subject: Re: DBWR Average Scan Depth

I've asked TOAD about a number of those tuning measures.
They said that if I did not like the red circles, I should just edit the
file with the alarm limits.
----- Original Message ----- 
From: K Gopalakrishnan <kaygopal@yahoo.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sent: Tuesday, November 14, 2000 4:15 AM
Subject: RE: DBWR Average Scan Depth


> Hi Vivek !!
> 
> 
> TOAD is right for pre 8i versions. DBWR AVG Scan depth
> was a sun function of db_files in earlier versions.
> But this advice is no more  applicable for 8i (and
> probably above)
> 
> 
> 
> 
> 
> --- VIVEK_SHARMA <VIVEK_SHARMA@infy.com> wrote:
> > 
> > > On 7.3.4.5 on AIX 4.3.3 when Running a Batch
> > Processing Option (Interest
> > > Calculation on Bank Accounts)
> > > 
> > > Following Error Message Displayed in the TOAD
> > Performance Tool :-
> > > Message - DBWR Average Scan Depth , Suggestion
> > "Number of DB_FILES to High
> > > ?"
> > > 
> > > 
> > db_files existing=500 . 
> > NOTE - There Exist about 58 Datafiles
> > > Changed the db_files parameter to 60 from 500
> > > 
> > > db_file_simultaneous_writes=4 
> > Oracle Recommends setting it Equal to 4*Max No. of
> > Disks Across which a
> > Datafile is Stripped
> > > Increased db_file_simultaneous_writes to 16 from 4
> > because a Datafile is
> > > Stripped across 4 Disks
> > > 
> > Even Thereafter in the Subsequent Batch Processing
> > Runs the Message persists
> > :-
> > Message - DBWR Average Scan Depth , Suggestion
> > "Number of DB_FILES to High
> > ?"
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > -- 
> > Author: VIVEK_SHARMA
> >   INET: VIVEK_SHARMA@infy.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@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).
> 
> 
> =====
> Have a nice day !!
> ------------------------------------------------------------
> Best Regards,
> K Gopalakrishnan,
> Bangalore, INDIA.
> 
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Calendar - Get organized for the holidays!
> http://calendar.yahoo.com/
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: K Gopalakrishnan
>   INET: kaygopal@yahoo.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@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