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: 227
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

Report message to a moderator

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: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 16:05:43 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.