invalid views

[davey23uk]

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

[abhaysk]

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.

[davey23uk]

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

[marist89]

Maybe they were installed by some monitoring tool?

[davey23uk]

yeah I thought that too, but no.

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

cheers

[abhaysk]

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.

[Srinivas_Sharma]

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

[davey23uk]

Oh....

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