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 -> Strange results with Oracle 8.1.7 and statistic gathering dbms_stats vs dbms_utility

Strange results with Oracle 8.1.7 and statistic gathering dbms_stats vs dbms_utility

From: martin <martin_folb_at_puresolv.com>
Date: 2 Oct 2002 13:38:02 -0700
Message-ID: <5600154e.0210021238.51005c8d@posting.google.com> 





We have a customer with a large app using WebSphere and Oracle 8.1.7.



They run:



exec dbms_utility.analyze_schema('SAP', 'COMPUTE'); weekly.



We recently ran:



dbms_stats.gather_schema_stats(ownname=>'SAP';)



on our test system and saw HUGE improvements in speed.



Why is this? What is the difference between the two.



Please help and advise.



Martin Folb


WGCUSA

Received on Wed Oct 02 2002 - 15:38:02 CDT












Original text of this message













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