RE: Risk of RULE mode in 10g+
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <kennethnaim@xxxxxxxxx>, <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 17 Mar 2010 09:31:46 -0400
Some how that seems "logical and expected behavior", the fix that is.
Dick Goulet
Senior Oracle DBA/NA Team Lead
PAREXEL International
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kenneth Naim
Sent: Tuesday, March 16, 2010 2:55 PM
To: rjoralist@xxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Risk of RULE mode in 10g+
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
