RE: 11gr2 v$access oddity?

From: Powell, Mark <mark.powell2_at_hp.com>
Date: Mon, 21 May 2012 18:01:00 +0100
Message-ID: <7C4BF3B32B80CC44AE37D31B172415937DDE88A432_at_GVW1337EXC.americas.hpqcorp.net>



Because Oracle keeps multiple versions of the statistics in 11.2 (pending, historic) and I believe that Oracle may well be using WMS internally to do this. I do not know this for an absolute fact but from the naming and information posted it is what appears to be taking place.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Nuno Souto Sent: Saturday, May 19, 2012 7:23 AM
To: oracle-l_at_freelists.org
Subject: Re: 11gr2 v$access oddity?

In theory yes. But SID 95 was my session and the only thing I was doing was recalcing stats with dbms_stats. Partitioned table. Why would that trigger WM? And this db has never been 9i, it started life as 10g and has never had WM activated.

--
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_iinet.net.au
dbvision_at_iinet.net.au


Powell, Mark wrote,on my timestamp of 18/05/2012 11:05 PM:

> Wouldn't that indicate that Oracle Workspace Manager (9i+) is in use?
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dbvision_at_iinet.net.au
> Sent: Thursday, May 17, 2012 6:55 PM
> To: oracle-l_at_freelists.org
> Subject: 11gr2 v$access oddity?
>
>
> 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"?
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
Received on Mon May 21 2012 - 12:01:00 CDT

Original text of this message