Home » RDBMS Server » Server Administration » last_analyzed column is not getting updated after gather stats (Oracle database 11.2.0.3)
last_analyzed column is not getting updated after gather stats [message #662207] Thu, 20 April 2017 13:50 Go to next message
james1511
Messages: 1
Registered: April 2017
Junior Member
I am trying run GATHER_STATS on a table, but when I look into the LAST_ANALYSED column value of the dba_tables/all_tables'/dba_tab_statistics for this table record, the date is not getting refreshed even though the GATHER_STATS completes successfully.


getting NULL value for SELECT stattype_locked FROM dba_tab_statistics WHERE table_name = 'EVENT' and owner = 'SDS';


Re: last_analyzed column is not getting updated after gather stats [message #662213 is a reply to message #662207] Thu, 20 April 2017 15:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If you SHOW us what you do and get maybe we can help you, there we can just say maybe you did something wrong or maybe not, maybe there is a bug or maybe not, maybe <whatever> or maybe not.

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Align the columns in result.

Re: last_analyzed column is not getting updated after gather stats [message #662215 is a reply to message #662207] Thu, 20 April 2017 15:45 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
james1511 wrote on Thu, 20 April 2017 11:50

getting NULL value for SELECT stattype_locked FROM dba_tab_statistics WHERE table_name = 'EVENT' and owner = 'SDS';


so, why is this a problem that needs to be fixed?

SQL> select stattype_locked, count(*) from dba_tab_statistics  group by stattype_locked order by 1;

STATT	COUNT(*)
----- ----------
ALL	      18
	    4101
most object have NULL value.
Previous Topic: Help:difference between LAST_ANALYZED of dba_tables and STATS_UPDATE_TIME column of dba_tab_stats_hi
Next Topic: SQL Statement can not be traced
Goto Forum:
  


Current Time: Fri Mar 29 06:49:27 CDT 2024