Home » RDBMS Server » Performance Tuning » database statistics
database statistics [message #549979] Thu, 05 April 2012 02:50 Go to next message
priteshranjan.preet
Messages: 131
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;
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: 21806
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.
Re: database statistics [message #550909 is a reply to message #549982] Fri, 13 April 2012 08:14 Go to previous message
priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi
Senior Member
thanks.
Previous Topic: Different explain plan
Next Topic: loop questions
Goto Forum:
  


Current Time: Fri Mar 29 02:23:15 CDT 2024