RE: HP-UX 11i/9.2.0.3/Upgrade Question

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.

• Kirti

-----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 8.1.7.4 instance to 9.2.0.3. I
> installed the software, installed the 9.2.0.3 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: http://www.orafaq.net
-



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).