doc

    Name:   recursiv.sql

    Author: Mark Gurry


The following script lists the number of recursive calls that this 
instance has performed. A major cause of recursive calls is having 
excessive fragmentation in your database objects. 

#

SELECT NAME, VALUE 
  FROM V$SYSSTAT
 WHERE NAME = 'recursive calls';