Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rule Based Optimizer
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue'>Indeed you are
right, but I'm sad to say we failed. After
180 or so people passed through the house on Saturday, we probably have MORE
alcohol than when we started. What can I
say? We'll have to have another party!<span
style='mso-spacerun:yes'> <font size=1 color=blue
face=Wingdings><span style='font-size:9.0pt;font-family:Wingdings;mso-ascii-font-family:
"Comic Sans MS";mso-hansi-font-family:"Comic Sans MS";color:blue;mso-char-type:
symbol;mso-symbol-font-family:Wingdings'><span style='mso-char-type:symbol;
mso-symbol-font-family:Wingdings'>J<font size=1
color=blue face="Comic Sans MS"><span style='font-size:9.0pt;font-family:"Comic Sans MS";
color:blue'>
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue'>
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue;mso-no-proof:
yes'>Pete
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue;mso-no-proof:
yes'>
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue;mso-no-proof:
yes'>"Controlling developers is like herding cats."
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue;mso-no-proof:
yes'>Kevin Loney, Oracle DBA Handbook
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue;mso-no-proof:
yes'>
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue;mso-no-proof:
yes'>"Oh no it's not. It's much
harder than that!"
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue;mso-no-proof:
yes'>Bruce Pihlamae, long-term Oracle DBA.
<span
style='font-size:9.0pt;font-family:"Comic Sans MS";color:blue'>
<span
style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mogens
Nørgaard
Sent: Saturday, June 14, 2003
12:05 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: Rule Based Optimizer
<span
style='font-size:12.0pt'>
<span
style='font-size:12.0pt'>Pete - I love it when you talk dirty. It will probably
only get worse in the next 24 hours, since - if I recall correctly - you're
having the "I'm going back to Australia, so let's empty all the bottles in
my house" party tonight?
Thanks for the note on 6.0.27. It's funny how things are introduced early in releases sometimes. OPS was in 5, CBO in 6, some waits in 6 (the x$trace stuff). And it's all still around in 9 :-))).
Mogens
Pete Sharman wrote:
<span
style='font-size:10.0pt'>Yup, I remember praying exactly the same thing! <pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Pete<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>"Controlling developers is like herding cats."<pre style='margin-left:.5in'><span style='font-size:10.0pt'>Kevin Loney, Oracle DBA Handbook<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>"Oh no, it's not. It's much harder than that!"<pre style='margin-left:.5in'><span style='font-size:10.0pt'>Bruce Pihlamae, long term Oracle DBA.<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>-----Original Message-----<pre style='margin-left:.5in'><span style='font-size:10.0pt'>Jared Still<pre style='margin-left:.5in'><span style='font-size:10.0pt'>Sent: Wednesday, June 11, 2003 10:10 PM<pre style='margin-left:.5in'><span style='font-size:10.0pt'>To: Multiple recipients of list ORACLE-L<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>7.0.13. Ah yes, I remember that.<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Mostly I remember praying that 7.0.16 would<pre style='margin-left:.5in'><span style='font-size:10.0pt'>be in the mail RSN. <pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Jared<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>On Wednesday 11 June 2003 18:14, Pete Sharman wrote:<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<pre
style='margin-left:.5in' wrap=""><span style='font-size:10.0pt'>Much as I hate to say that Jared's confidence in Mogens is misplaced,<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<span
style='font-size:10.0pt'>we<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<pre
style='margin-left:.5in' wrap=""><span style='font-size:10.0pt'>must all remember Mogens has now reached the grand old age of 42 and<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<span
style='font-size:10.0pt'>the<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<pre
style='margin-left:.5in' wrap=""><span style='font-size:10.0pt'>brain cells are starting to slip. :)<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>To be absolutely 100% picky and correct, there was an event setting<pre style='margin-left:.5in'><span style='font-size:10.0pt'>introduced in (I believe) 6.0.27-ish that you could use to turn on the<pre style='margin-left:.5in'><span style='font-size:10.0pt'>CBO. However, Mogens is correct in that it was first officially<pre style='margin-left:.5in'><span style='font-size:10.0pt'>released and supported in the first Production release of Oracle7,<pre style='margin-left:.5in'><span style='font-size:10.0pt'>7.0.13.<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Sorry, Mogens, couldn't resist! :)<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Pete<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>"Controlling developers is like herding cats."<pre style='margin-left:.5in'><span style='font-size:10.0pt'>Kevin Loney, Oracle DBA Handbook<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>"Oh no, it's not. It's much harder than that!"<pre style='margin-left:.5in'><span style='font-size:10.0pt'>Bruce Pihlamae, long term Oracle DBA.<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>-----Original Message-----<pre style='margin-left:.5in'><span style='font-size:10.0pt'>Mogens Nørgaard<pre style='margin-left:.5in'><span style='font-size:10.0pt'>Sent: Tuesday, June 10, 2003 7:55 PM<pre style='margin-left:.5in'><span style='font-size:10.0pt'>To: Multiple recipients of list ORACLE-L<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Thanks for the confidence, Jared. It was introduced in 7.0 and the<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<span
style='font-size:10.0pt'>world<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<pre
style='margin-left:.5in' wrap=""><span style='font-size:10.0pt'>hasn't been the same since.<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Mogens<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Jacques Kilchoer wrote:<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<pre
style='margin-left:.5in' wrap=""><span style='font-size:10.0pt'>I am 99% confident that I remember the CBO existing on VAX/VMS in<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<span
style='font-size:10.0pt'>7.1.5, and<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<pre
style='margin-left:.5in' wrap=""><span style='font-size:10.0pt'>for sure in 7.1.6 (on VAX/VMS)<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<pre
style='margin-left:.5in' wrap=""><span style='font-size:10.0pt'>-----Original Message-----<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>I first saw the CBO in 1994 if IIRC.<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>Seems to me it was introduced in 7.2.<pre style='margin-left:.5in'><span style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>I'm sure Mogens knows for sure. :)<pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<span
style='font-size:10.0pt'> <pre style='margin-left:.5in'><span style='font-size:10.0pt'>
<span
style='font-size:12.0pt'>
Received on Mon Jun 16 2003 - 08:35:13 CDT
![]() |
![]() |