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

From: Francisco C P de Almeida <piragibe_at_esquadro.com.br>
Date: 1997/03/26
Message-ID: <01bc3991$d69ebe20$7d55ffc8@chico>#1/1

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 Wed Mar 26 1997 - 00:00:00 CST