Home » RDBMS Server » Server Administration » Gather Statistics - too much time taking
Gather Statistics - too much time taking [message #203836] Thu, 16 November 2006 09:14 Go to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

I have gathering statistics from a table having 8000000 records. It is taking aroung 1.5 Hour to gather status. Is ther any way I can decrease the time for Gather stats..

I'm using
DBMS_GATHER.GATHER_TABLE_STATS('User1','Table1');

Thanks
Brian.
Re: Gather Statistics - too much time taking [message #203840 is a reply to message #203836] Thu, 16 November 2006 09:23 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did you try parallel?
Re: Gather Statistics - too much time taking [message #203907 is a reply to message #203836] Thu, 16 November 2006 22:43 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
No, how to use parallel?

Is parallel possible for schema also?

Thanks
Re: Gather Statistics - too much time taking [message #203979 is a reply to message #203836] Fri, 17 November 2006 03:29 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

Is this the efficient way of analyzing

DBMS_STATS.GATHER_TABLE_STATS(ownname=>'user1', tabname=>'table1',degree=>16);

Here degree(degree of parallelism) is itself the parallel cluase or some other paralle clase exists.

Regards,
Ronald.
Re: Gather Statistics - too much time taking [message #204036 is a reply to message #203836] Fri, 17 November 2006 07:42 Go to previous messageGo to next message
Brayan
Messages: 315
Registered: June 2002
Senior Member
Hi,

In 8 CPU db server I have analysed the table having 20000000 records using following...

dbms_stats.GATHER_TABLE_STATS(ownname=>'TARGETDB',tabname=>'DEPOSITS', degree=>16);

It is taking around 4 hrs. I do not have this much big window to analyze. Even I have many tables with this size. Please suggest what I should do to reduce time.

Brian.
Re: Gather Statistics - too much time taking [message #204040 is a reply to message #203836] Fri, 17 November 2006 07:50 Go to previous message
henderd
Messages: 6
Registered: November 2006
Junior Member
how's about using estimate_percent or block_sample to reduce the time required?
Previous Topic: How to create second database in single instance..
Next Topic: question about 10g upgrades
Goto Forum:
  


Current Time: Wed Dec 07 18:31:27 CST 2016

Total time taken to generate the page: 0.06236 seconds