Home » SQL & PL/SQL » SQL & PL/SQL » Gathering Stats (Oracle 11g)
Gathering Stats [message #572280] Mon, 10 December 2012 00:27 Go to next message
ajaykumarkona
Messages: 399
Registered: August 2010
Senior Member
Hi Experts,

I have used the following statement to gather the stats of a table..

EXEC dbms_stats.gather_table_stats('APP','SALE_AMT',ESTIMATE_PERCENT=>100,CASCADE=>True);


To gather the stats it is taking one hour and the table SALE_AMT is having 237213998 records.

Please help me is there any way to get the stats quickly.

Thanks in advance.
Re: Gathering Stats [message #572281 is a reply to message #572280] Mon, 10 December 2012 00:30 Go to previous messageGo to next message
BlackSwan
Messages: 23143
Registered: January 2009
Senior Member
>Please help me is there any way to get the stats quickly.
NO!
Re: Gathering Stats [message #572285 is a reply to message #572281] Mon, 10 December 2012 01:38 Go to previous messageGo to next message
Roachcoach
Messages: 1233
Registered: May 2010
Location: UK
Senior Member
You could always reduce the estimate percent.

the documentation has some other things in it you may find useful.
Re: Gathering Stats [message #572324 is a reply to message #572285] Mon, 10 December 2012 11:30 Go to previous message
Flyby
Messages: 148
Registered: March 2011
Location: Belgium
Senior Member
In oracle 11 the auto sample size has improved. Try it before setting sampling 100 percent
Previous Topic: Display Week number as per financial year(Apr - Mar)
Next Topic: Inserting Single Quotes
Goto Forum:
  


Current Time: Thu Dec 18 14:36:21 CST 2014

Total time taken to generate the page: 0.09171 seconds