Plano de execução

[David SiqueiraParticipante]

Marcião achei algo que talvez possa lhe trazer algum “NORTE”, sobre onde procurar esse seu problema, dê uma lida nisso :

[i]”Detecting Dynamic Extension
Dynamic extension causes Oracle to execute SQL statements in addition to those SQL statements issued by user processes. These SQL statements are called recursive calls because Oracle issues these statements itself. Recursive calls are also generated by these activities:

misses on the data dictionary cache
firing of database triggers
execution of Data Definition Language statements
execution of SQL statements within stored procedures, functions, packages, and anonymous PL/SQL blocks
enforcement of referential integrity constraints
Examine the RECURSIVE CALLS statistic through the dynamic performance table V$SYSSTAT. By default, this table is available only to the user SYS and to users granted the SELECT ANY TABLE system privilege, such as SYSTEM. Monitor this statistic over some period of time while your application is running, with this query:

SELECT name, value

FROM v$sysstat
WHERE name = ‘recursive calls’;

The output of this query might look like this:

NAME VALUE
——————————————————- ———-
recursive calls 626681

If Oracle continues to make excessive recursive calls while your application is running, determine whether these recursive calls are due to one of the activities that generate recursive calls other than dynamic extension. If you determine that these recursive calls are caused by dynamic extension, you should try to reduce this extension by allocating larger extents.”[/i]

Link de origen: http://www.baskent.edu.tr/~tkaracay/ders/database/sql/oracle8/a58246/io.htm

Abcs.

David