Re: Tuning Help - select condition from cdef$ where rowid=:1

> 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


Other related posts: