Recursive Calls Ratio (RecsvCallsRatio)

Description

The RecursiveCallsRatio parameter shows the ratio of recursive calls to all calls. A recursive call occurs when the execution of one SQL statement or PSL/SQL block requires the execution of other SQL statements, PSL/SQL procedures, functions or triggers. For example, auditing data is recorded in system tables by a recursive call or accessing an object with many extents may require recursive calls.

In applications which do not use PL/SQL in the server this parameter is a tuning parameter and should be very close to zero - higher values may indicate excessive execution of DDL or space management or (exceptionally) that the shared pool is too small to allow enough space for the dictionary cache. In applications which do make use of PL/SQL within the server this parameter is a measure of workload type, and shows the extent to which a single call to the DBMS server causes multiple requests internally.

Recommendations

• A high value indicates poor performance.
• Review dictionary cache activity for poor performance and review the storage parameters of objects that have many extents.

BMC PATROL properties

Attribute	Default value
Application class	ORACLE_ENVIRONMENT
Command type	not applicable
Platform	all
Icon style	Graph
Unit	percentage of calls that are recursive calls
Border range	undefined
Alarm1 range	undefined
Alarm2 range	undefined
Scheduling(poll time)	poll time of collector
Active at installation	Yes
Parameter type	Consumer
Value set by	CollEnvironment

BMC ProactiveNet Performance Management properties

Attribute	Default value
Monitor type	Oracle Database Environment
Key Performance Indicator	No
Monitor for abnormalities	Yes
Graph by default	No
Availability	No
Response time	No
Normal distribution	Yes
Statistical	Yes