RE: Risk of RULE mode in 10g+

From: Kenneth Naim <>
Date: Tue, 16 Mar 2010 14:54:39 -0400
Message-ID: <014f01cac53a$22bda770$6838f650$_at_com>

The rule hint still exist in the all_tab_columns view which is causing us some significant performance problems and is a known issue on MOS. The "official" fix is to recreate the view without the hint, go figure.

Ken Naim

-----Original Message-----
From: [] On Behalf Of Rich Jesse
Sent: Tuesday, March 16, 2010 2:13 PM
Subject: RE: Risk of RULE mode in 10g+

> EYY, just my luck. I've got a note here from an Oracle 10g new features
> class that says it died. But then again how long ago did LONGS die???
> Dick Goulet

LOL -- anyone attempting a materialized view over 64KB knows they're still around and in use in the dictionary. :)



Received on Tue Mar 16 2010 - 13:54:39 CDT

Original text of this message