recipients of list ORACLE-L [EMAIL PROTECTED]
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
-L
did he mention any benchmarked performance improvements from gathering
statistics on the system tablespacE?
From: Grabowy, Chris [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 03:34:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Desupport of RBO
At the recent
Title: RE: Desupport of RBO
Chris,
Yes, thank you very much!
In a
way it will be simpler to have only one optimizer mode to take into
consideration. We will be able to analyze the whole database and leave it
at that.
I
assume that dbms_stats.gather_database_stats is smart enough to make
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
It is
very likely thatyou haven't heard of 10i, because it is called
10g.
Raj
-Original Message-From: Nikunj Gupta
[mailto:[EMAIL PROTECTED]Sent: Tuesday, October 07, 2003 2:30
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Desupport of RBO
Yes Jared
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
Title: 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
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
Title: 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
didnt they change it to CBO in 9.0.2? Or is that only in 10g?
From: Boivin, Patrice J [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 02:59:33 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Desupport of RBO
We had issues here with first_rows and all_rows when set
The way I read it is that you can still use it, it's just not officially
supported. i.e. If you call up Oracle Support and say my query (SELECT
/*+RULE */ blah blah blah...) crashes the database, they will say
Sorry, you're out of luck or Switch to cost-based.
Some apps (e.g. Siebel) still rely
Title: RE: Desupport of RBO
in 10g, you can analyze sys (9i too, but don't know if anyone actually
does it) as well as fixed tables ... though frequent fixed table analysis is not
recommended.
Raj
Rajendra dot
Title: 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
did he mention any benchmarked performance improvements from gathering statistics on
the system tablespacE?
From: Grabowy, Chris [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 03:34:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Desupport of RBO
At the recent
Bit old but
http://www.pro-dba.com/oracle_10i.html
HTH
GovindanK
-Original Message-
From: Cunningham, Gerald;Cunningham, GeraldSent: 10/7/2003 12:11:25 PMTo: [EMAIL PROTECTED]Subject: RE: Desupport of RBOThe way I read it is that you can still use it, it's just not officially
]
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
statistics on the system tablespacE?
From: Grabowy, Chris [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 03:34:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Desupport of RBO
At the recent NYOUG conference, they were handing out special preview
copies of Oracle 10g
improvements from gathering
statistics on the system tablespacE?
From: Grabowy, Chris [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 03:34:25 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Desupport of RBO
At the recent NYOUG conference, they were handing out special
will do this.
From: [EMAIL PROTECTED]
Date: 2003/10/07 Tue PM 02:04:31 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
First time I've seen this note: 189702.1
Jared
).
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Monday, October 06, 2003 04:34
PM
Subject: Desupport of RBO
First time I've seen this
note: 189702.1 Jared
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
22 matches
Mail list logo