OraFAQ Forum: Server Administration » last_analyzed column is not getting updated after gather stats

Home » RDBMS Server » Server Administration » last_analyzed column is not getting updated after gather stats (Oracle database 11.2.0.3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

last_analyzed column is not getting updated after gather stats [message #662207]

Thu, 20 April 2017 13:50

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';

Report message to a moderator

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

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 14:02:41 CST 2024