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

On Thu, 10 Nov 2005 11:29:14 -0600, "Thomas Biju" <BThomas_at_br-inc.com> said:
> We recently upgraded an 8i (test) database to 9.2.0.6, the batch jobs are
> taking more than 4 times longer to complete in the 9i environment.
> When traced one of the batch jobs using DBMS_SUPPORT (waits=yes,
> binds=no), the most "expensive" SQL seems to be "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
>
>
>
> Thanks,
> Biju Thomas
> Database Administrator
>

Did you do a FULL statistics gathering or SAMPLE? First time after patch it should be full. Also how much time it took with 8i?

HTH
GovindanK

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