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

Francisco has a valid point, but it must be treated with caution. Among the _other objects_ which increase the <recursive calls> count are stored procedures. If extensive use is made of these (and some production systems run almost exclusively on them) then <recursive calls> may account for up to 80% of all calls without giving cause for alarm. The advice to reduce <recursive calls> unconditionally really had to be modified wth the introduction of V7.2

Chrysalis.

Francisco C P de Almeida wrote:
>
> I don't have a feeling for the other numbers, but your RECURSIVE CALLs
> figures seem too high to me. These, as you might've already known, are
> calls that ORACLE places on itself, while querying its own dictionary data
> tables and views to retrieve, among other things, information on your
> tables, column definitions and other objects. You can bring recursive calls
> down by enlarging your SHARED_POOL_SIZE init.ora parameter, if you're
> running ORACLE 7, or by increasing the DC_... parameters (DC stands for
> dictionary cache), if you're still running ORACLE 6.
>
> Such high values for RECURSIVE CALLs may substantially degrade performance.
>
> --
> Francisco C P de Almeida, consultor
> Tel: 55-21-5125064
> piragibe_at_esquadro.com.br
>
> doid <doid_at_usa.net> escreveu no artigo <3332EF2F.7B7C_at_usa.net>...
> > 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 Thu Mar 27 1997 - 00:00:00 CST