RE: Risk of RULE mode in 10g+
From: Kenneth Naim <kennethnaim_at_gmail.com>
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.
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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Rich Jesse
Sent: Tuesday, March 16, 2010 2:13 PM
To: oracle-l_at_freelists.org
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. :)
Rich
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 16 2010 - 13:54:39 CDT