Re: Suggestions, please

This is a good reason to use the bstat.sql and estat.sql scripts (or your  platform
equivalents). Run them once your D/B has already been up a while, you then avoid analysing the startup misses that you invariably get, no matter how well tuned you are!

On 31 Jan 96 at 15:06, Tom Robbins wrote :

> On Wed, 31 Jan 1996, Padmavijayam, Govind wrote:
> > I've been monitoring DD cache misses periodically and find that whenever I
> > startup the instance,
> > I get the following stats :
> >
> > DD requests DD Cache misses
> > ===============================
> > 1555701 90766
> >
> > ie; (cache misses / DD requests)* 100 approx reaches 6 !! which I know is
> > an extremely high value
>
> The first time Oracle goes to find info about a dd object, it isn't
> in cache yet, and registers a miss. When you start up, Oracle does
> a lot of reading into the cache, so you get a lot of misses at
> startup.
>

|  Peter Moore - Database Administrator - MAT Transport Ltd, London, UK
|  pt_at_chaff.demon.co.uk : +44 (171) 410 6373
|  "With a little study you'll go a long ways & I wish you'd start now!"