OraFAQ Forum: Performance Tuning » incremental stats not happening

Home » RDBMS Server » Performance Tuning » incremental stats not happening (ORACLE 11GR2 SOLARIS)

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

incremental stats not happening [message #568652]

Mon, 15 October 2012 08:37

guddu_12
Messages: 124
Registered: April 2012
Location: UK

Senior Member

Dear all,

I have set the incremental stats for my partition table as it taks more than 20 min to gether , though the incremental is set to 'true' the table is getting analyzed completely.

Can you please help me to sort out this

Thanks

Report message to a moderator

Re: incremental stats not happening [message #568667 is a reply to message #568652]

Mon, 15 October 2012 12:42

Littlefoot
Messages: 16993
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Excuse me if I'm wrong about it (as I know close to nothing about Warehouse Builder as well as gathering incremental statistics for partitioned tables), but ... is this really a Warehouse Builder question? If not, would you like us to move it elsewhere? Where would that be?

Report message to a moderator