Re: Recursive Calls

Hi Cemal.

There are several potential causes of recursive calls including:

• Misses on dictionary cache
• Firing of database triggers
• Executing of DDL statement such as ALTER INDEX and CREATE INDEX
• Execution of SQL statements within stored procedures, function, packages.

You may have lot of fragmentet tables/indexes, and need to reaoganize.

A basic rule of tumb is a ratio of 4:1 on User Calls: Recursive Calls

To see if your ratio is within this ratio, run this script:

select name, value from v$sysstat
where name in ('user calls','recursive calls');

If your ratio is bad, you should investigate for fragmented tables/indexes

Best regards
Jan Fure

cdoganay_at_my-dejanews.com wrote in article <705793$4u9$1_at_nnrp1.dejanews.com>...
> Hi, I have noticed that the number of recursive calls increased
dramatically
> on Oracle 8.0.4. What could be caused or how can I find out it?
>
> Cemal
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Sat Oct 17 1998 - 10:36:43 CDT