OraFAQ Forum: Performance Tuning » gather statistics on partition table

Home » RDBMS Server » Performance Tuning » gather statistics on partition table (Oracle Database 19c Enterprise Edition Release 19.0.0.0.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

gather statistics on partition table [message #686596]

Wed, 19 October 2022 14:46

wtolentino
Messages: 422
Registered: March 2005

Senior Member

i run a stats on a partition table with using this package and parameters:

Code: [Select all] [Show/ hide]

      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.

Attachment: dba_tab_stats_history.JPG
(Size: 86.96KB, Downloaded 7128 times)

[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

John Watson
Messages: 8976
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.

Report message to a moderator

Re: gather statistics on partition table [message #686603 is a reply to message #686602]

Fri, 21 October 2022 04:49

wtolentino
Messages: 422
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.

Report message to a moderator

Previous Topic:	Sql behaving badly after upgrade (merged)
Next Topic:	Understanding UNDO 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 15:43:07 CDT 2025