Home » RDBMS Server » Performance Tuning » tuning stats command (ORACLE 11GR2 SOLARIS)
tuning stats command [message #566065] Tue, 11 September 2012 04:32 Go to next message
guddu_12
Messages: 175
Registered: April 2012
Location: UK
Senior Member
Dear All,

i load a table through sql loader which takes nearly 14 min for 8-9 millions records, once the records complete i run the analyze table compute statics to gather stats and it takes nearly 15 min. is there any ways so that i can reduce the stats timing. the stats collection command runs from other schema not from where the table is residing.

Thanks

Rajesh
Re: tuning stats command [message #566067 is a reply to message #566065] Tue, 11 September 2012 04:39 Go to previous message
Michel Cadot
Messages: 59975
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i run the analyze table compute statics to gather stats


And you're wrong, you should use dbms_stats.

Regards
Michel
Previous Topic: Tuning issue
Next Topic: ASH Report
Goto Forum:
  


Current Time: Thu Dec 18 03:06:39 CST 2014

Total time taken to generate the page: 0.11049 seconds