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

  • From: "Thomas Biju" <BThomas@xxxxxxxxxx>
  • To: "Egor Starostin" <egorst@xxxxxxxxx>, "GovindanK" <gkatteri@xxxxxxxxxxx>
  • Date: Thu, 10 Nov 2005 12:39:41 -0600

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@xxxxxxxxx] 
Sent: Thursday, November 10, 2005 12:30 PM
To: Thomas Biju
Cc: oracle-l@xxxxxxxxxxxxx
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.



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.


Other related posts: