invalid views
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: invalid views

  1. #1
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333

    invalid views

    Hi, need a quick favour off someone, can someone check if they have
    these two views in the databases q$bh and q$buffer_cache in the sys schema

    The version was 8.1.7.4 and was migrated to 9.2.0.5, they are invalid in my database and cant be recomplied because the text is wrong.

    Oracle say they dont know anything about them and can drop them but I am suspicious as we didnt create them and they didnt appear from thin air!

    Cheers

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Even we have migrated from 8.1.7.4 to 9.2.0.4, we didnt have such views..

    If you still have 8.x S/W, look into RDBMS/ADMIN what are these objects for..

    BTW, can you post the text?

    Abhay.
    Last edited by abhaysk; 05-11-2004 at 08:08 AM.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Code:
    q$bh
    
    SELECT "ADDR","INDX","INST_ID","BUF#","HLADDR","NXT_HASH","PRV_HASH","NXT_REPL",
    "PRV_REPL","FLAG","LRU_FLAG","TS#","FILE#","DBARFIL","DBABLK","CLASS","STATE",
    "MODE_HELD","CHANGES","CSTATE","X_TO_NULL","FORCED_READS","FORCED_WRITES",
    "LE_ADDR","DIRTY_QUEUE","SET_DS","OBJ","BA","CR_SCN_BAS","CR_SCN_WRP","CR_XID_USN",
    "CR_XID_SLT","CR_XID_SQN","CR_UBA_FIL","CR_UBA_BLK","CR_UBA_SEQ","CR_UBA_REC",
    "CR_SFL","LRBA_SEQ","LRBA_BNO","HRBA_SEQ","HRBA_BNO","RRBA_SEQ","RRBA_BNO","US_NXT",
    "US_PRV","WA_NXT","WA_PRV","TCH","TIM"
    FROM sys.x$bh
    WHERE inst_id = USERENV('Instance')
    
    It is invalid because HRBA_SEQ,HRBA_BNO and BUF# do not exist in x$bh
    
    And
    
    q$buffer_cache
    
    SELECT
    bh.addr
    ,bh.buf#
    ,bh.dbarfil
    ,bh.dbablk
    ,bh.ts#
    ,bh.obj
    ,bh.class
    ,DECODE(bh.state,0,'FREE',1,'XCUR',2,'SCUR',
    3,'CR',4,'READ',5,'MREC',6,'IREC')
    ,bp.bp_name
    ,DECODE(BITAND(bh.flag,1),0,'N','Y')
    ,DECODE(BITAND(bh.flag,524288),0,'RANDOM','SEQUENTIAL')
    ,bh.nxt_repl
    ,bh.prv_repl
    FROM
    sys.x$kcbwbpd bp
    ,sys.x$bh bh
    ,sys.x$kcbwds ds
    WHERE
    bp.bp_size > 0
    AND ds.set_id >= bp.bp_lo_sid
    AND ds.set_id <= bp.bp_hi_sid
    AND bh.buf# >= ds.start_buf#
    AND bh.buf# <= ds.end_buf#
    AND bh.inst_id = USERENV('Instance')
    AND bp.inst_id = USERENV('Instance')
    AND ds.inst_id = USERENV('Instance')
    I know why they are invalid, columns are missing in the actual views. Oracle say delete them as they dont know what they do, but I am suspicious as we or my customer didnt create them.

    Might have to do it anyway and keep the text just in case

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Maybe they were installed by some monitoring tool?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    yeah I thought that too, but no.

    Anyway if no-one else has them, they shall be gone

    cheers

  6. #6
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by davey23uk
    yeah I thought that too, but no
    can u ckeck the date these objects were created & if any other objects created along with this on that day.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  7. #7
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    I think its installed by Q Diagnostic Engine.......

    The Q Diagnostic Center provides an interesting, information-dense GUI summary of system resource usage that lets you quickly analyze system performance.

    Q is composed of the Q Viewer and the Q Diagnostic Engines for Oracle and Client PCs. The Diagnostic Engine for Oracle executes on any Oracle7.2 or 7.3 database.

    The Client Engine currently supports Windows 95 and NT platforms.

    If u had this tool sometime it must have installed those q$views.....


    Srini

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    Oh....

    Never heard of that, will ask my customer if they have

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width