Home » RDBMS Server » Server Administration » Generating STATISTICS
Generating STATISTICS [message #242918] Tue, 05 June 2007 09:04 Go to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Generating STATISTICS- Frequently generating STATISTICS,is good or bad ?Will it take long time to complete if tables have more records ?

I have never got a chance to work on this scenario, Can some one please tell me some scenarios where you had to generate statistics and how long it took to complete.Please show some light
Re: Generating STATISTICS [message #242919 is a reply to message #242918] Tue, 05 June 2007 09:11 Go to previous messageGo to next message
harshad.gohil
Messages: 157
Registered: April 2007
Location: USA
Senior Member
It depends on number of rows in table.. indexes.. and datatype.
Re: Generating STATISTICS [message #242942 is a reply to message #242918] Tue, 05 June 2007 10:07 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
generating statistics for TABLE- will that touch all its indexes also ?
Re: Generating STATISTICS [message #242943 is a reply to message #242942] Tue, 05 June 2007 10:11 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Read it for statistics collection.


http://download-west.oracle.com/docs/cd/B12037_01/server.101/b10752/stats.htm
Re: Generating STATISTICS [message #242944 is a reply to message #242918] Tue, 05 June 2007 10:15 Go to previous messageGo to next message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Thanks for the link .

Also want to hear from experts on real time scenarios they had come across.Pls share if any
Re: Generating STATISTICS [message #242949 is a reply to message #242944] Tue, 05 June 2007 10:26 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
can you post your oracle version?
Re: Generating STATISTICS [message #242959 is a reply to message #242918] Tue, 05 June 2007 11:00 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
we have 8i,9i nd 10g.

my idea is to understand some scenarios in production environment ;like.... do you have 'Automatic Statistics Gathering' enabled? or how often u run statistics ...?
or do you prefer to run through DBMS job or through crontab ,etc...
Previous Topic: Sysdba logging as another user
Next Topic: Constraints
Goto Forum:
  


Current Time: Fri Dec 09 08:15:04 CST 2016

Total time taken to generate the page: 0.05603 seconds