OraFAQ Forum: Performance Tuning » Query to check that statistics gathered

Home » RDBMS Server » Performance Tuning » Query to check that statistics gathered (Oracle 9i)

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

Query to check that statistics gathered [message #345577]

Thu, 04 September 2008 04:29

Olivia
Messages: 519
Registered: June 2008

Senior Member

How to check whether statistics were statistics gathered or not?

Regards,
Oli

[Updated on: Thu, 04 September 2008 04:56]

Report message to a moderator

Re: Why different plan [message #345598 is a reply to message #345577]

Thu, 04 September 2008 04:57

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

What may be the reason?

There are many

Quote:

How to check whether statistics were gathered or not?

You already asked this several times. The answer is the same.

Regards
Michel

Report message to a moderator

Re: Query to check that statistics gathered [message #345675 is a reply to message #345577]

Thu, 04 September 2008 07:32

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

For Tables, look at the last_analyzed column in *_TABLES.
For Indexes, look at the last_analyzed column in *_INDEXES

or you can look at *_TAB_STATISTICS and *_IND_STATISTICS

Report message to a moderator

Re: Query to check that statistics gathered [message #345676 is a reply to message #345675]

Thu, 04 September 2008 07:33

Olivia
Messages: 519
Registered: June 2008

Senior Member

Thank you very much. Good memory! Smile

Quote:

you can look at *_TAB_STATISTICS and *_IND_STATISTICS

Something added to my basket Smile

Regards,
Oli

[Updated on: Thu, 04 September 2008 07:35]

Report message to a moderator

Re: Query to check that statistics gathered [message #345692 is a reply to message #345676]

Thu, 04 September 2008 08:54

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You want more in your basket: %_STATISTICS, %_HISTOGRAMS

Regards
Michel

Report message to a moderator

Re: Query to check that statistics gathered [message #345704 is a reply to message #345676]

Thu, 04 September 2008 09:38

dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad

Member

Case 1: If you are using automatic statistics gathering,You need not worry about this. (This is recommended in most of the cases unless you have too much data volatility - deleting/inserting in your table)

Case 2: If you had chosen manual statistics collection,
You may have a look at

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/stats.htm#i41884

Regards,
Dwarak

Report message to a moderator

Re: Query to check that statistics gathered [message #345710 is a reply to message #345692]

Thu, 04 September 2008 10:20

Olivia
Messages: 519
Registered: June 2008

Senior Member

Michel Cadot wrote on Thu, 04 September 2008 08:54

You want more in your basket: %_STATISTICS, %_HISTOGRAMS

Regards
Michel

Thanks Michel Smile

Learning is a never ending process..and little I know...

Thanks to Dwarak too!

Regards,
Oli

[Updated on: Thu, 04 September 2008 10:23]

Report message to a moderator

Previous Topic:	What does it signifies
Next Topic:	tunning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 22:43:59 CST 2024