Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

v$access oddity?

252 views
Skip to first unread message

Noons

unread,
May 17, 2012, 7:05:12 PM5/17/12
to
This, from a query on v$access in our DW in 11.2.0.3.2:

SID OWNER OBJECT
-------------- --------------------
--------------------------------------------------------------------------------
TYPE
-----------
95 DWDEVTEAM F_GL_MONTHLY_BALANCE
TABLE
95 DWDEVTEAM F_GL_MONTHLY_BALANCE
MULTI-VERSI
ONED OBJECT



F_GL_MONTHLY_BALANCE is a partitioned table.
"Multi-versioned object"?????
Looked it up everywhere, doesn't seem to register in google.

Anyone seen this before? What exactly is a "multi-versioned object"?
In this context, of course: I'm fully aware of UNDO mechanism and
Oracle's multi-versioning change control.
No other users of this table other than my SID above (95).
And I am not changing it, I'm re-calcing stats.

Mladen Gogala

unread,
May 18, 2012, 8:22:22 AM5/18/12
to
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.


--
http://mgogala.byethost5.com

Mark D Powell

unread,
May 18, 2012, 10:21:43 AM5/18/12
to
Oh, I had thought that indicated that the Oracle Workspace Manager was in use to keep multiple versions of row data. I do not think I have ever seen the message before. Something else to go on my list of things to look into.

HTH -- Mark D Powell --

Mladen Gogala

unread,
May 18, 2012, 11:13:20 AM5/18/12
to
On Fri, 18 May 2012 07:21:43 -0700, Mark D Powell wrote:

> Oh, I had thought that indicated that the Oracle Workspace Manager was
> in use to keep multiple versions of row data. I do not think I have
> ever seen the message before. Something else to go on my list of things
> to look into.
>
> HTH -- Mark D Powell --

Nuno said that he was calculating stats at the time. This doesn't strike
me as one of OWM thingies. As a matter of fact, I have never seen OWM
being used.



--
http://mgogala.byethost5.com

Noons

unread,
May 19, 2012, 7:40:20 AM5/19/12
to
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.
0 new messages