Re: v$access oddity?

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Fri, 18 May 2012 07:21:43 -0700 (PDT)
Message-ID: <f396c9a4-a8f4-4f82-9794-06b0cfee7996_at_googlegroups.com>

On Friday, May 18, 2012 8:22:22 AM UTC-4, Mladen Gogala wrote:
> On Thu, 17 May 2012 16:05:12 -0700, Noons wrote:
>
> > 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.
>
> 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

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 -- Received on Fri May 18 2012 - 09:21:43 CDT