Re: LRU avg scan dept

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Thu, 17 Sep 1998 19:34:12 -0700
Message-ID: <6tsgib$bet@sjx-ixn3.ix.netcom.com>

That's funny. I get the message sayign that my "db_files is too high"!!!

winnie

Chuck Hamilton wrote in message <36011bb5.8493976_at_news.dvol.com>...
>I've been playing around with the very cool program called TOAD. One
>of the things it's pointed out for me is that my LRU average scan
>depth is too high (950). It suggests increasing DB_FILES but I think
>this is incorrect. How would DB_FILES effect avg lru scan depth?
>
>I don't recall anything about this value in the Oracle tuning class.
>Is this something I need to be alarmed about and if so, how can I
>reduce it.
>
>DBWR summed scan depth 162207
>DBWR lru scans 170
>Avg scan depth 954.16
>--
>Chuck Hamilton
>chuckh_at_dvol.com
>
>If at first you don't succeed, sky diving isn't for you.
Received on Thu Sep 17 1998 - 21:34:12 CDT