Re: Upgraded From v8.1.7.4 to v9.2.0.3 and now dbms_stats.gather_table

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

Never mind. Fixed it myself.

The effects of the "granularity=>'ALL'" method have changed for partitioned tables. On v8.1.7.4 it didn't go global on the table, now it does. Ouch.

                                                                                                                                    
                      Brian P MacLean                                                                                               
                                               To:      ORACLE-L_at_fatcity.com                                                        
                      07/17/2003 05:13         cc:                                                                                  
                      PM                       Subject: Upgraded From v8.1.7.4 to v9.2.0.3 and now dbms_stats.gather_table_stats    
                                               runs FOREVER(Document link: Brian P MacLean)

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? Received on Thu Jul 17 2003 - 22:17:13 CDT

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