OraFAQ Forum: Performance Tuning » database statistics

Home » RDBMS Server » Performance Tuning » database statistics

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database statistics [message #549979]

Thu, 05 April 2012 02:50

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;

Report message to a moderator

Re: database statistics [message #549982 is a reply to message #549979]

Thu, 05 April 2012 03:02

Littlefoot
Messages: 21765
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

priteshranjan.preet
Messages: 131
Registered: April 2012
Location: delhi

Senior Member

thanks.

Report message to a moderator

Previous Topic:	Different explain plan
Next Topic:	loop questions

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 04 19:36:26 CDT 2023