FAQ
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

Search Discussions

  • Howard Latham at Nov 4, 2011 at 3:10 pm
    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
    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


    --
    http://www.freelists.org/webpage/oracle-l


    --
    Howard A. Latham

    Sent from my Nokia N97


    --
    http://www.freelists.org/webpage/oracle-l
  • Sheehan, Jeremy at Nov 4, 2011 at 3:25 pm
    That makes sense. I'll have the developer look at that angle. There are no types being used in the MV so the error might be related to the other session that's running against the same table.
    Thanks!

    Jeremy

    From: Howard Latham
    Sent: Friday, November 04, 2011 11:09 AM
    To: Sheehan, Jeremy
    Cc: oracle-l-freelists
    Subject: Re: "invalid type" in v$access

    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 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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedNov 4, '11 at 3:06p
activeNov 4, '11 at 3:25p
posts3
users2
websiteoracle.com

2 users in discussion

Sheehan, Jeremy: 2 posts Howard Latham: 1 post

People

Translate

site design / logo © 2022 Grokbase