Re: db Tuning .... what do these statistics mean?

doid wrote:
>
> I've just begun to discover the wonderful world of Oracle's performance
> statistics, via UTLESTAT and UTLBSTAT.
>
> Here are a few questions for which I couldn't find answers in the
> manuals. I hope that somebody out there might have a few answers or
> opinions. I realize that there usually isn't a definitive answer for
> questions like these.
>
> I've heard that Enqueue Timeouts should be low. How low? How important
> is this? On a good day, I see 0-10, and on a bad day, I see 100-300.
>
> Ditto for Recursive Calls. On a bad day, I might see 6 million
> recursive calls, and only 100000 user calls. How significant might this
> be, and what's the recommended solution?
>
> What about Redo Log Space requests? I get about 10/day. Is that bad?
>
> I'm very interested in hearing what others might have to say. Please cc
> me via e-mail.
>
> Thanks

Get yourself a copy of Advanced Oracle Tuning and Administration, Oracle Press. Lots of detail inside.

Steve Phelan. Received on Sun Mar 23 1997 - 00:00:00 CST