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_at_yahoo.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_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_at_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_at_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_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).
>
>
> =====
> 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_at_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_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
Received on Tue Nov 14 2000 - 13:03:06 CST
