Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help interpreting TKPROF output
If you look in the exec plan,
the optimizer mode is "RULE". The only time that analyzed stats could mess up an exec plan is if it was set at "CHOOSE". Thanx for the comment anyway.
Daniel
> > 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 Sun Nov 09 2003 - 10:58:29 CST