Re: "invalid type" in v$access
- From: Howard Latham <howard.latham@xxxxxxxxx>
- To: JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx
- Date: Fri, 4 Nov 2011 15:08:59 +0000
I'm pretty sure I saw that once. I think one type is missing from the view
that this is based on. You can modify the view and add the missing type.
On 4 November 2011 15:05, Sheehan, Jeremy
<JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>wrote:
> Has anyone come across the "invalid type" type when querying v$access? If
> so, do you have any idea what might be causing it? I've searched google
> and metalink and absolutely nothing. Just more people asking about it. Go
> figure.
> I'm attempting to refresh a MV and have tried a number of different
> session parameters, but doing some digging I keep on seeing "invalid type"
> in v$access when it's querying a particular table. I'm also seeing the
> wait event "read by other session" on this table (ISO_BIDS) as well when
> refreshing the MV.
>
> Oracle 10.2.0.4
> AIX 6.1.4
>
> This is from a query that joins v$access and v$session.
>
> Session 217 is the MV refresh. Session 251 is another process running
> that is accessing the ISO_BIDS table.
>
> OWNER OBJECT_NAME TYPE SID SERIAL#
> USERNAME OSUSER STATUS
> ------------ -------------------- ---------- ---------- ----------
> ------------ ------------ --------
> MFSDB ISO_BIDS INVALID TY 217 46581 USER1
> USER1 ACTIVE
> MFSDB ISO_BIDS TABLE 217 46581 USER1
> USER1 ACTIVE
> MFSDB ISO_BIDS INVALID TY 251 8712 USER2
> USER2 ACTIVE
> MFSDB ISO_BIDS TABLE 251 8712 USER2
> USER2 ACTIVE
>
> Thanks in advance!
>
> Jeremy
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Howard A. Latham
Sent from my Nokia N97
--
//www.freelists.org/webpage/oracle-l
Other related posts:
