Re: 11gr2 v$access oddity?
- From: Nuno Souto <dbvision@xxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 19 May 2012 21:22:46 +1000
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@xxxxxxxxxxxx
dbvision@xxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of dbvision@xxxxxxxxxxxx
> Sent: Thursday, May 17, 2012 6:55 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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"?
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
