Home » RDBMS Server » Performance Tuning » database statistics
database statistics [message #549979] Thu, 05 April 2012 02:50 Go to next message
priteshranjan.preet
Messages: 125
Registered: April 2012
Location: delhi
Senior Member
exec dbms.stats_gather_database_stats();
exec dbms.stats_gather_schema_stats('SCOTT');

where i find the output of the above command and use with table,index and column statistics. for which purpose i can use the above command and what its use.

please tell me in details;

Report message to a moderator

Re: database statistics [message #549982 is a reply to message #549979] Thu, 05 April 2012 03:02 Go to previous messageGo to next message
Littlefoot
Messages: 16995
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Details are provided in documentation; see what's in there, follow links to other documents.

Report message to a moderator

Re: database statistics [message #550909 is a reply to message #549982] Fri, 13 April 2012 08:14 Go to previous message
priteshranjan.preet
Messages: 125
Registered: April 2012
Location: delhi
Senior Member
thanks.

Report message to a moderator

Previous Topic: Different explain plan
Next Topic: loop questions
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 24 12:46:50 CDT 2013

Total time taken to generate the page: 0.14805 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.