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

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 Received on Fri Mar 21 1997 - 00:00:00 CST