Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
-----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).Received on Wed May 14 2003 - 13:46:51 CDT