> These are the stats from the trace file for this statement.
>
> select condition
> from
> cdef$ where rowid=:1
> [...]
> What are the next steps for me to diagnose the issue?
Here's the next step (not a solution though):
Find the parent(s) for this recursive statement. tkprof can't display
recursive relationship between statements, for this task you need to
use a profiler which can display it. Like OraSRP, for example.
--
Egor
http://www.oracledba.ru
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 10 2005 - 12:32:30 CST
