Version is 11.2.0.3.
We have locked the status for one of the table in the database. LAST analyzed Column shows NULL. However I see the entry in DBA_TAB_STATS_HISTORY for this table.
Just want to understand this behaviour. We have Default AUTO gather STATS enabled in the instance.
| TABLE_NAME | LAST_ANALYZED |
| PS_TSEL_P_TAO4 |
| OWNER | TABLE_NAME | STATS_UPDATE_TIME |
| SYSADM | PS_TSEL_P_TAO4 | 11/25/2016 4:02:47.968931 PM +08:00 |
| SYSADM | PS_TSEL_P_TAO4 | 11/25/2016 4:05:53.246285 PM +08:00 |
| SYSADM | PS_TSEL_P_TAO4 | 11/25/2016 4:06:01.268603 PM +08:00 |
| SYSADM | PS_TSEL_P_TAO4 | 11/29/2016 7:50:02.315677 AM +08:00 |
| SYSADM | PS_TSEL_P_TAO4 | 11/29/2016 7:50:42.015481 AM +08:00 |
| SYSADM | PS_TSEL_P_TAO4 | 11/29/2016 7:50:50.219026 AM +08:00 |
And in WRI$_OPTSTAT_IND_HISTORY.
How can be ANALYZETIME is getting updated whe the table STATS has been locked long back. What is the reason Behind that and is there any way to track this behaviour. Someone please suggest.
OBJECT_NAME OBJECT_TYPE SAVTIME ROWCNT AVGRLN SAMPLESIZE ANALYZETIME
-------------------- ------------------- ---------------------------------------- ---------- ---------- ---------- --------------------
PS_TSEL_P_TAO4 TABLE 25-NOV-16 16.02.47.968931 +08:00
PS_TSEL_P_TAO4 TABLE 25-NOV-16 16.05.53.246285 +08:00
PS_TSEL_P_TAO4 TABLE 25-NOV-16 16.06.01.268603 +08:00 0 0 0 25 Nov 2016 16:05:53
PS_TSEL_P_TAO4 TABLE 29-NOV-16 07.50.02.315677 +08:00 0 0 0 25 Nov 2016 16:05:53
PS_TSEL_P_TAO4 TABLE 29-NOV-16 07.50.42.015481 +08:00 0 0 0 25 Nov 2016 16:05:53
PS_TSEL_P_TAO4 TABLE 29-NOV-16 07.50.50.219026 +08:00