Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help interpreting TKPROF output
but these would have no affect if Siebel has optimizer mode set to RULE, no?
"Geomancer" <pharfromhome_at_hotmail.com> wrote in message
news:cf90fb89.0311081511.7e5b142c_at_posting.google.com...
> > I'm trying to figure out what might have slowed down considerably
> a specific query these past days.
>
> If Siebel uses RBO then it is most-likely a partially analysed schema.
>
> Look for "accidental" stats on any table, and remove them:
>
> select table_name from dba_tables where num_rows > 1;
Received on Sat Nov 08 2003 - 17:34:14 CST