RE: Risk of RULE mode in 10g+
- From: "Kenneth Naim" <kennethnaim@xxxxxxxxx>
- To: <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2010 14:54:39 -0400
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Rich Jesse
Sent: Tuesday, March 16, 2010 2:13 PM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
