Home » RDBMS Server » Performance Tuning » gather statistics on partition table (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0)
gather statistics on partition table [message #686596] Wed, 19 October 2022 14:46 Go to next message
wtolentino
Messages: 364
Registered: March 2005
Senior Member
i run a stats on a partition table with using this package and parameters:
      dbms_stats.gather_table_stats (ownname => 'WR', tabname => 'WR_CSE_MEM_MTH_SMRY',
                                     partname=> 'WR_CSE_MEM_MTH_202209', 
                                     cascade => TRUE, 
                                     estimate_percent => DBMS_STATS.AUTO_SAMPLE_SIZE,
                                     method_opt=>'FOR ALL COLUMNS SIZE AUTO',
                                     granularity => 'ALL', degree=>2);


when i checked on the dba_tab_stats_history i see that there are other partition table that the stats had collected.
/forum/fa/14660/0/

is that something that the gather stats had implicitly included? and if it is how do i exclude/prevent it?

thanks.

[Updated on: Wed, 19 October 2022 14:58]

Report message to a moderator

Re: gather statistics on partition table [message #686602 is a reply to message #686596] Fri, 21 October 2022 02:07 Go to previous messageGo to next message
John Watson
Messages: 8794
Registered: January 2010
Location: Global Village
Senior Member
Please excuse me if this is too obvious. Looking at the stats_update_time, the partitions were analyzed on different days.
Re: gather statistics on partition table [message #686603 is a reply to message #686602] Fri, 21 October 2022 04:49 Go to previous message
wtolentino
Messages: 364
Registered: March 2005
Senior Member
right and it was because the table is so big that the gather stats took days to complete about almost 3 days.
Previous Topic: Sql behaving badly after upgrade (merged)
Next Topic: Understanding UNDO 11g
Goto Forum:
  


Current Time: Wed Feb 01 07:32:13 CST 2023