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

Michael:

  Can you be a bit more specific about the process performed? It is a bit more complicated than that. Detail will help.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation

Direct:	(248) 865-4350
Mobile:	(248) 408-2918
Email:	Stephen.Karniotis_at_Compuware.com
Web:	www.compuware.com

 -----Original Message-----
Sent:	Wednesday, May 14, 2003 2:32 AM
To:	Multiple recipients of list ORACLE-L
Subject:	Re: HP-UX 11i/9.2.0.3/Upgrade Question

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
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Karniotis, Stephen
  INET: Stephen_Karniotis_at_compuware.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).