Re: v$access oddity?

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: Sat, 19 May 2012 21:40:20 +1000
Message-ID: <jp80r5$oc5$1_at_dont-email.me>



Mladen Gogala wrote,on my timestamp of 18/05/2012 10:22 PM:

> 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

Original text of this message