RE: RE: Desupport of RBO

Nope. Mr Freeman are you out there??

Also, Jonathan Lewis is a commentary author for this book, so he may some insight.

But wait, I have some dice at my desk...bingo...it's 8 percent faster. You can quote me.

-----Original Message-----
rgaffuri_at_cox.net
Sent: Tuesday, October 07, 2003 4:04 PM
To: Multiple recipients of list ORACLE-L

did he mention any benchmarked performance improvements from gathering statistics on the system tablespacE?
>
> From: "Grabowy, Chris" <chris.grabowy_at_lmco.com>
> Date: 2003/10/07 Tue PM 03:34:25 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: RE: Desupport of RBO
>
> At the recent NYOUG conference, they were handing out special preview copies of Oracle 10g New Features by our very own Robert Freeman....
>
> Page 11 has a section entitled...Collecting Data Dictionary Statistics...this is done using the DBMS_STATS.GATHER_DICTIONARY_STATS procedure.
>
> Does that answer your question Patrice?
>
> -----Original Message-----
> Sent: Tuesday, October 07, 2003 3:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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-----
> 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
> |--
> |Author: Guido Konsolke
> | INET: Guido.Konsolke_at_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_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
> --
> Author:
> INET: Kip.Bryant_at_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_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.
>
>
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Grabowy, Chris
  INET: chris.grabowy_at_lmco.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_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).