OraFAQ Forum: Server Administration » Generating STATISTICS

Home » RDBMS Server » Server Administration » Generating STATISTICS

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

Generating STATISTICS [message #242918]

Tue, 05 June 2007 09:04

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

Report message to a moderator

Re: Generating STATISTICS [message #242919 is a reply to message #242918]

Tue, 05 June 2007 09:11

harshad.gohil
Messages: 157
Registered: April 2007
Location: USA

Senior Member

It depends on number of rows in table.. indexes.. and datatype.

Report message to a moderator

Re: Generating STATISTICS [message #242942 is a reply to message #242918]

Tue, 05 June 2007 10:07

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

generating statistics for TABLE- will that touch all its indexes also ?

Report message to a moderator

Re: Generating STATISTICS [message #242943 is a reply to message #242942]

Tue, 05 June 2007 10:11

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

Report message to a moderator

Re: Generating STATISTICS [message #242944 is a reply to message #242918]

Tue, 05 June 2007 10:15

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

Report message to a moderator

Re: Generating STATISTICS [message #242949 is a reply to message #242944]

Tue, 05 June 2007 10:26

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

can you post your oracle version?

Report message to a moderator

Re: Generating STATISTICS [message #242959 is a reply to message #242918]

Tue, 05 June 2007 11:00

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...

Report message to a moderator

Previous Topic:	Sysdba logging as another user
Next Topic:	Constraints

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:46:47 CDT 2024