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

Thank you. The trace file I have is 1.3GB. I downloaded the trace analyzer from Oracle. And its analysis is going on since 10PM last night (exec trca$i.trace_analyzer). Does this help to find the parent?

Did full stats on all schema tables (COMPUTE) except 4 large ones where we did 10% sample.

With 8i this particular job ran for 22 minutes, in 9i it takes about 4 hours.

-----Original Message-----
From: Egor Starostin [mailto:egorst_at_gmail.com] Sent: Thursday, November 10, 2005 12:30 PM To: Thomas Biju
Cc: oracle-l_at_freelists.org
Subject: 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


_____________________________________________________________________________________________________________

This electronic transmission and any attached files are intended solely for the person or entity to which they are addressed and may contain
information that is privileged, confidential or otherwise protected from disclosure. Any review, retransmission, dissemination or other use,
including taking any action concerning this information by anyone other than the named recipient, is strictly prohibited. If you are not the
intended recipient or have received this communication in error, please immediately notify the sender and destroy this communication.

--
http://www.freelists.org/webpage/oracle-l