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: 64840
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 May 27 16:27:57 CDT 2017

Total time taken to generate the page: 0.14284 seconds