Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help interpreting TKPROF output

Re: Help interpreting TKPROF output

From: Geomancer <pharfromhome_at_hotmail.com>
Date: 8 Nov 2003 15:11:07 -0800
Message-ID: <cf90fb89.0311081511.7e5b142c@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:11:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US