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!
Received on Tue Nov 14 2000 - 04:13:47 CST
