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: 10053 Trace File anomolies

Re: 10053 Trace File anomolies

From: <mccmx_at_hotmail.com>
Date: 28 Jun 2005 00:51:05 -0700
Message-ID: <1119945065.635042.278400@z14g2000cwz.googlegroups.com> 





We are using the following syntax for analyzing the schema:



dbms_stats.gather_schema_stats(ownname=>'MATT',cascade=>TRUE,estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE);



but by doing a full analyze as such:



dbms_stats.gather_table_stats(ownname=>'SYSADM',tabname=>'<TNAME>'cascade=>TRUE)
for each of the tables in the query, the problem dissapears and the
response time returns to normal.



I'm surprised that the estimate stats got it so wrong....



Matt
Received on Tue Jun 28 2005 - 02:51:05 CDT












Original text of this message













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