Re: 11gr2 v$access oddity?
From: Nuno Souto <dbvision_at_iinet.net.au>
Date: Sat, 19 May 2012 21:22:46 +1000
Message-ID: <4FB78286.6080002_at_iinet.net.au>
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.
Date: Sat, 19 May 2012 21:22:46 +1000
Message-ID: <4FB78286.6080002_at_iinet.net.au>
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:Received on Sat May 19 2012 - 06:22:46 CDT
> 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