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

Report message to a moderator

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: 68665
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

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 17:00:38 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.