Oracle-L: Re: RE: Desupport of RBO

From: <rgaffuri_at_cox.net>
Date: Tue, 07 Oct 2003 11:09:32 -0800
Message-ID: <F001.005D24A2.20031007110932@fatcity.com>

didnt they change it to CBO in 9.0.2? Or is that only in 10g?
>
> From: "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
> Date: 2003/10/07 Tue PM 02:59:33 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: Desupport of RBO
>
> We had issues here with first_rows and all_rows when set in init.ora for 8i
> a couple of years ago... performance dropped significantly. During
> discussions with Oracle Support I learned that the data dictionary for 8i
> has to run in rule mode, I don't know if they changed that in 9i or 10G.
>
> Hopefully... 10G still has a data dictionary I imagine.
>
> : )
>
> Patrice.
>
> -----Original Message-----
> Sent: Tuesday, October 07, 2003 3:14 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 10g it won't be supported... wander when rule hints won't be used in
> E-Business Suite... 11.5.8 still has rule hints in some of the code.
>
> April Wells
> Oracle DBA/Oracle Apps DBA
> Corporate Systems
> Amarillo Texas
> /\
> / \
> / \
> \ /
> \/
> >\<
> \
> >\<
> \
> Few people really enjoy the simple pleasure of flying a kite
> Adam Wells age 11
>
>
>
> -----Original Message-----
> <mailto:Kip.Bryant_at_Vishay.com> ]
> Sent: Tuesday, October 07, 2003 1:05 PM
> To: Multiple recipients of list ORACLE-L
>
>
> OK, dumb question. Does this mean the rule hint won't be possible?
> Application I support mostly uses CBO but there have been cases where we had
> to
> resort to RBO hint. 'course it'll be some time before we can consider
> v10...
>
> Kip
>
> |Hi Jared,
>
> |haven't seen it, too. But the fact
> |was spreaded over the newsgroups.
>
> |We still have some 3rd party apps that don't use
> |*any* feature above Oracle 7 (well, almost). Queries with
> |the RULE hint where it's not necessary.
> |But if we change a thing, support will be lost.
> |So we decided to rewrite the whole app.
> |Lucky me: enough work for the next years.
>
> |Greetings,
> |Guido
>
> |>>> Jared.Still_at_radisys.com 07.10.2003 01.34 Uhr >>>
> |First time I've seen this note: 189702.1
>
> |Jared
>
> |--
> |Please see the official ORACLE-L FAQ: http://www.orafaq.net
> <http://www.orafaq.net>
> |--
> |Author: Guido Konsolke
> | INET: Guido.Konsolke_at_tkserv-triaton.thyssenkrupp.com
>
> |Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> <http://www.fatcity.com>
> |San Diego, California -- Mailing list and web hosting services
> |---------------------------------------------------------------------
> |To REMOVE yourself from this mailing list, send an E-Mail message
> |to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> |the message BODY, include a line containing: UNSUB ORACLE-L
> |(or the name of mailing list you want to be removed from). You may
> |also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> <http://www.orafaq.net>
> --
> Author:
> INET: Kip.Bryant_at_Vishay.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> <http://www.fatcity.com>
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
> The information contained in this communication, including attachments, is
> strictly
>
> confidential and for the intended use of the addressee only; it may also
> contain
>
> proprietary, price sensitive, or legally privileged information. Notice is
> hereby given that
>
> any disclosure, distribution, dissemination, use, or copying of the
> information by anyone
>
> other than the intended recipient is strictly prohibited and may be illegal.
> If you have
>
> received this communication in error, please notify the sender immediately
> by reply e-mail,
>
> delete this communication, and destroy all copies.
>
>
>
>
>
> Corporate Systems, Inc. has taken reasonable precautions to ensure that any
> attachment to
>
> this e-mail has been swept for viruses. We specifically disclaim all
> liability and will
>
> accept no responsibility for any damage sustained as a result of software
> viruses and advise
>
> you to carry out your own virus checks before opening any attachment.
>
>
>
>
>

RE: Desupport of RBO

We had issues here with first_rows and all_rows when set in init.ora for 8i a couple of years ago... performance dropped significantly. During discussions with Oracle Support I learned that the data dictionary for 8i has to run in rule mode, I don't know if they changed that in 9i or 10G.

Hopefully... 10G still has a data dictionary I imagine.

: )

Patrice.

-----Original Message-----
From: April Wells [mailto:awells@csedge.com]
Sent: Tuesday, October 07, 2003 3:14 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Desupport of RBO

10g it won't be supported... wander when rule hints won't be used in E-Business Suite... 11.5.8 still has rule hints in some of the code.

April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
/\
/   \
/     \
\     /
\/
>\<
     \
     >\<
         \
Few people really enjoy the simple pleasure of flying a kite
Adam Wells age 11

-----Original Message-----
From: Kip.Bryant@Vishay.com [mailto:Kip.Bryant@Vishay.com]
Sent: Tuesday, October 07, 2003 1:05 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Desupport of RBO

OK, dumb question. Does this mean the rule hint won't be possible?
Application I support mostly uses CBO but there have been cases where we had to
resort to RBO hint. 'course it'll be some time before we can consider v10...

Kip

|Hi Jared,

|haven't seen it, too. But the fact
|was spreaded over the newsgroups.

|We still have some 3rd party apps that don't use
|*any* feature above Oracle 7 (well, almost). Queries with
|the RULE hint where it's not necessary.
|But if we change a thing, support will be lost.
|So we decided to rewrite the whole app.
|Lucky me: enough work for the next years.

|Greetings,
|Guido

|>>> Jared.Still@radisys.com 07.10.2003 01.34 Uhr >>>
|First time I've seen this note: 189702.1

|Jared

|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.net
|--
|Author: Guido Konsolke
| INET: Guido.Konsolke@tkserv-triaton.thyssenkrupp.com

|Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
|San Diego, California        -- Mailing list and web hosting services
|---------------------------------------------------------------------
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be removed from). You may
|also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: Kip.Bryant@Vishay.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Oct 07 2003 - 14:09:32 CDT