Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: HP-UX 11i/ Question

RE: HP-UX 11i/ Question

From: Deshpande, Kirti <>
Date: Wed, 14 May 2003 10:46:51 -0800
Message-ID: <>

It appears that someone installed Steve Adams' APT scripts in that 8i database, probably when it was a 7.x database !! ;)

Consider deleting and recreating all those views used by APT scripts.

-----Original Message-----
Sent: Wednesday, May 14, 2003 1:32 AM
To: Multiple recipients of list ORACLE-L

On 2003.05.14 01:56 "Vergara, Michael (TEM)" wrote:
> Hi All!
> I am trying to upgrade an instance to I
> installed the software, installed the patch, ran
> the upgrade, and now I'm getting an ORA-600 [16206]. I
> get this error querying the x$ view X_$KCBCBH.
> I have opened an iTAR with Oracle, but I was hoping that
> somebody out here has tripped over this and could lend their
> expertise.
> Thanks,
> Mike

X$KCBCBH ???? What are you trying to do? I haven't seen that old V6 view for a very, very long time, wver since my stegosaurus pet has died. Are you trying to predict an increase in the cache hit rate if you increase your
buffer cache by certain number of buffers? Doesn't work that way any more.
What would X$KCBCBH do? You are aware that you have more then one buffer pool, one for each block size. Which buffers are we talking about? 4K? 8K? 16K? That table no longer makes any sense and the best way that RDBMS
has to convey that to you is ORA-600.

Mladen Gogala
Please see the official ORACLE-L FAQ:

Please see the official ORACLE-L FAQ:
Author: Deshpande, Kirti

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed May 14 2003 - 13:46:51 CDT

Original text of this message