Home » RDBMS Server » Performance Tuning » Query to check statistics are up to date (Oracle9i)
Query to check statistics are up to date [message #345121] Tue, 02 September 2008 06:31 Go to next message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Which data dictionary need to be queried statistics are up to date.USER_TABLE?


Thanks in advance

Regards,
Oli
Re: Query to check statistics are up to date [message #345134 is a reply to message #345121] Tue, 02 September 2008 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depends on the meaning of "up to date".
USER_TABLES gives you the last analyzed date.

Regards
Michel
Re: Query to check statistics are up to date [message #345138 is a reply to message #345134] Tue, 02 September 2008 06:56 Go to previous message
Olivia
Messages: 519
Registered: June 2008
Senior Member
Thanks for the information Michel.

Regards,
Oli
Previous Topic: How to make the response time less for this query
Next Topic: Alternative way to avoid full scan?
Goto Forum:
  


Current Time: Sat Dec 10 20:52:09 CST 2016

Total time taken to generate the page: 0.09692 seconds