Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help interpreting TKPROF output
> 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:11:07 CST