Re: Tuning Help - select condition from cdef$ where rowid=:1
- From: Egor Starostin <egorst@xxxxxxxxx>
- To: BThomas@xxxxxxxxxx
- Date: Fri, 11 Nov 2005 00:30:15 +0600
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
