RE: 11gr2 v$access oddity?
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 May 2012 18:01:00 +0100
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Nuno Souto
Sent: Saturday, May 19, 2012 7:23 AM
To: oracle-l@xxxxxxxxxxxxx
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
