Home » RDBMS Server » Performance Tuning » incremental stats not happening (ORACLE 11GR2 SOLARIS)
incremental stats not happening [message #568652] Mon, 15 October 2012 08:37 Go to next message
guddu_12
Messages: 175
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
Re: incremental stats not happening [message #568667 is a reply to message #568652] Mon, 15 October 2012 12:42 Go to previous messageGo to next message
Littlefoot
Messages: 19650
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?
Re: incremental stats not happening [message #568910 is a reply to message #568667] Wed, 17 October 2012 08:33 Go to previous messageGo to next message
guddu_12
Messages: 175
Registered: April 2012
Location: UK
Senior Member
This is my mistak, please move it to performace tunning section and let me know if you know the answer
Re: incremental stats not happening [message #569013 is a reply to message #568910] Thu, 18 October 2012 12:28 Go to previous message
Littlefoot
Messages: 19650
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I don't know the answer, but will move it over there.
Previous Topic: NOLOGGING in Oracle 11gr2
Next Topic: Proper index is not used ...
Goto Forum:
  


Current Time: Wed Oct 01 14:46:10 CDT 2014

Total time taken to generate the page: 0.14005 seconds