> 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
Received on Mon Nov 13 2000 - 10:30:07 CST
