Table statistics [message #618629] |
Mon, 14 July 2014 08:05 |
|
andrewscharles89
Messages: 25 Registered: July 2014
|
Junior Member |
|
|
Is there any way that I could find how many tables has statistics on them,and how many tables which doesn't have statistics on them.
I want to ensure all tables in the database has stats on them.there are 2k tables should I check manually whether this table exists in dba_tab_stats_history view.
[EDITED by LF: fixed topic title typo]
[Updated on: Wed, 16 July 2014 14:27] by Moderator Report message to a moderator
|
|
|
Re: table statstics [message #618631 is a reply to message #618629] |
Mon, 14 July 2014 08:13 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
query ALL_TABLES
It is trivial to differentiate between table which has statistics & table which has no statistics,
but how do you differentiate between table with goods, valid & current statistics & table with old, outdated, & incorrect statistics?
[Updated on: Mon, 14 July 2014 08:46] Report message to a moderator
|
|
|
|
|
Re: table statstics [message #619184 is a reply to message #618901] |
Fri, 18 July 2014 14:15 |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
you should gather statistics on all tables (except SYS) on a regular schedule. On most of our databases above 8i, we do it at 5am every morning.
|
|
|