-
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
-
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 07: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"
-
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
-
Maybe they were installed by some monitoring tool?
Jeff Hunter
-
yeah I thought that too, but no.
Anyway if no-one else has them, they shall be gone
cheers
-
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"
-
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
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|