Home » RDBMS Server » Performance Tuning » Query to check that statistics gathered (Oracle 9i)
Query to check that statistics gathered [message #345577] Thu, 04 September 2008 04:29 Go to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Query to check that statistics gathered [message #345675 is a reply to message #345577] Thu, 04 September 2008 07:32 Go to previous messageGo to next message
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
Re: Query to check that statistics gathered [message #345676 is a reply to message #345675] Thu, 04 September 2008 07:33 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You want more in your basket: %_STATISTICS, %_HISTOGRAMS

Regards
Michel
Re: Query to check that statistics gathered [message #345704 is a reply to message #345676] Thu, 04 September 2008 09:38 Go to previous messageGo to next message
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
Re: Query to check that statistics gathered [message #345710 is a reply to message #345692] Thu, 04 September 2008 10:20 Go to previous message
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:
  


Current Time: Sun Dec 11 04:10:31 CST 2016

Total time taken to generate the page: 0.14581 seconds