"Table Scan: (stale)" message found on v$session_longops
788643Jul 31 2010 — edited Jul 31 2010I am seeing this message
"Table Scan: (stale) obj# 13122506: 10864 out of 10864 Blocks done"
on the message column of v$session_longops. This is the query it is executing
select min(minbkt),maxbkt,substrb(dump(min(val),16,0,32),1,120)
minval,substrb(dump(max(val),16,0,32),1,120) maxval,sum(rep) sum
rep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(
case when rep=1 then 1 else 0 end) unqrep from (select val,min(b
kt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(va
l) repsq from (select /*+ no_parallel(t) no_parallel_index(t) db
ms_stats cursor_sharing_exact use_weak_name_resl dynamic_samplin
g(0) no_monitoring */"START_DATE" val, ntile(254) over (order by
"START_DATE") bkt from sys.ora_temp_1_ds_1748280 t where "STAR
T_DATE" is not null) group by val) group by maxbkt order by maxb
kt
Does this mean that the table it is scanning has stale statistics? How does oracle says which statistics is stale? Is it if the statistics is 4 days back or 1 month back?
Any response would be appreciated.
Thanks