RE: Risk of RULE mode in 10g+

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Wed, 17 Mar 2010 09:31:46 -0400
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F051CD145_at_us-bos-mx022.na.pxl.int>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kenneth Naim Sent: Tuesday, March 16, 2010 2:55 PM
To: rjoralist_at_society.servebeer.com; oracle-l_at_freelists.org 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_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-l


--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 17 2010 - 08:31:46 CDT