Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"Table Scan: (stale)" message found on v$session_longops

788643Jul 31 2010 — edited Jul 31 2010
I 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
This post has been answered by sb92075 on Jul 31 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 28 2010
Added on Jul 31 2010
6 comments
6,122 views