RULE hint better sometimes after upgrade

From: Fedock, John \(KAM.RIC\) <>
Date: Tue, 8 Apr 2008 16:52:51 -0400
Message-ID: <>

We just upgraded our HP-UX 2 node RAC database from to  

So far, I have come across 2 queries where performance died. On both queries, running it with the RULE hint brought performance back. There were no hints on the queries before. Also, on one of those queries, deleting all stats on the object greatly improved performance (but on the other it made no difference).  

So, did the optimizer change that much between and  

I know the RULE isn't supported in 10g, but it can be used.  

Am I missing anything obvious?  

Also, on this upgrade the JVM crapped out, although the status and all was valid. After reinstalling it, all was fine.            

John Fedock

"K" Line America, ISD Department  

Received on Tue Apr 08 2008 - 15:52:51 CDT

Original text of this message