Re: v$access oddity?

> Nuno, statistics is the multi-versioned object, not the table itself. I> believe that you will see something completely different if you did> "select count(*) from F_GL_MONTHLY_BALANCE" and I don't have in mind John> Cleese in a bikini.> Stats on version 11G can have several versions, one being used, another> one being QA-ed, the third one being collected.

Hah-ah! Yes, that certainly makes sense and is very plausible in this
particular context. The db was created in 10g and has just been upgraded to
11.2.0.3, never used WM in it. I was doing a stats recalc on this very large
partitioned table and was surprised it was taking a long time. So I decided to
do a search on V$ACCESS just in case someone else was touching it. That's when
I saw the "multi-versioned" object from my SID (95). Looks like all those
multiple 11g stats-within-stats are being managed by WM.
Interesting! Thanks for that insight.
Received on Sat May 19 2012 - 06:40:20 CDT