Re: Help interpreting TKPROF output

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sun, 9 Nov 2003 10:26:30 +1100
Message-ID: <3fad7bb2$0$9282$afc38c87@news.optusnet.com.au>

"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;

Bit picky, I realise, but you should probably test for num_rows is not null, actually. Zero or 1 are genuine numbers and indicate the schema has been analyzed, even if the results are a bit pathetic. Only when the column is null does it indicate the abscence of all statistics.

Regards
HJR Received on Sat Nov 08 2003 - 17:26:30 CST