TOAD Statistics Analysis - DBWR avg scan depth - meaning please ??

In the T.O.A.D tool there is an Statistics Analysis page which reports a 'DBWR avg scan depth' which when it is 'too high' produces a red light alert and recommend that the

#DB_FILES too high?

What I would like to know is what the connection between the DB_FILES parameter is and this analysis value. The value appears to be based on the following query

SELECT DECODE(DLU.VALUE, NULL ,0,0,0,DBS.VALUE / DLU.VALUE ) FROM V$SYSSTAT DBS,V$SYSSTAT DLU
WHERE DBS.NAME = 'DBWR summed scan depth' AND DLU.NAME = 'DBWR lru scans'

I trust this helps

Regards

--
Kevin A Lewis (BOCM PAULS LTD - Animal Feed Manufacturer - Ipswich England)

                        <KevinALewis_at_HotMail.com>

The views expressed herein by the author of this document are not necessarily those of BOCM PAULS Ltd. Received on Thu Jul 08 1999 - 10:39:24 CDT