RE: DBWR Average Scan Depth

Hi Gopal/List

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 ?"

STATUS - As of Now we are reaching a Peak of 500 A/cs processed per minute DB Server Machine S80 Model of IBM - 12 CPUs , 3 GB RAM APP Server from which Firing Occuring = Thin Node of 4 CPUs with 1 GB RAM

NOTE - CPU Utilization if minimal

RAM Utilization :-
Almost Full RAM (3 GB) on DB Server is Utilized APP Server - About a 100-200MB of 1GB is Free A Small percent of Swapping is happening on Both DB & APP Servers

NOTE - Report.txt in the section "system wide-waits for non-backgroud processes" show
SMALL values for DB file Sequential Reads , latch free

How do we Approach this Issue ?

> -----Original Message-----
> From: K Gopalakrishnan [SMTP:kaygopal_at_yahoo.com]
> Sent: Tuesday, November 14, 2000 3:45 PM
> To: Multiple recipients of list ORACLE-L
> 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 - 11:08:50 CST