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

Home -> Community -> Mailing Lists -> Oracle-L -> Upgraded From v8.1.7.4 to v9.2.0.3 and now dbms_stats.gather_table_stats

Upgraded From v8.1.7.4 to v9.2.0.3 and now dbms_stats.gather_table_stats

From: <Brian_P_MacLean_at_eFunds.Com>
Date: Thu, 17 Jul 2003 17:13:38 -0700
Message-Id: <25946.338346@fatcity.com> 





Upgraded Solaris v8.1.7.4 64-bit to v9.2.0.3 and now
dbms_stats.gather_table_stats on partitioned tables is running and running
and running.  In testing on one partition in v8.1.7.4 the command takes 3
minutes, in v9.2.0.3 it took...well I killed it after 3 hours.  I also see
an abnormal amount of temporary tablespace being used.  I installed patch
2919423 per the known bug related to this but it's still keeps running and
running and running.



Suggestions?  Comments?



TIA

Received on Thu Jul 17 2003 - 19:13:38 CDT












Original text of this message













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