v$access oddity?

From: Noons <wizofoz2k_at_gmail.com>
Date: Thu, 17 May 2012 16:05:12 -0700 (PDT)
Message-ID: <63f9ed56-f945-49cd-bc10-6aebc3cfc105_at_l5g2000pbo.googlegroups.com>

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. Received on Thu May 17 2012 - 18:05:12 CDT