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:
Yup, I remember praying exactly the same thing!Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA. -----Original Message----- Jared Still Sent: Wednesday, June 11, 2003 10:10 PM To: Multiple recipients of list ORACLE-L 7.0.13. Ah yes, I remember that. Mostly I remember praying that 7.0.16 would be in the mail RSN. Jared On Wednesday 11 June 2003 18:14, Pete Sharman wrote:Much as I hate to say that Jared's confidence in Mogens is misplaced,wemust all remember Mogens has now reached the grand old age of 42 andthebrain cells are starting to slip. :) To be absolutely 100% picky and correct, there was an event setting introduced in (I believe) 6.0.27-ish that you could use to turn on the CBO. However, Mogens is correct in that it was first officially released and supported in the first Production release of Oracle7, 7.0.13. Sorry, Mogens, couldn't resist! :) Pete "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook "Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long term Oracle DBA. -----Original Message----- Mogens Nørgaard Sent: Tuesday, June 10, 2003 7:55 PM To: Multiple recipients of list ORACLE-L Thanks for the confidence, Jared. It was introduced in 7.0 and theworldhasn't been the same since. Mogens Jacques Kilchoer wrote:I am 99% confident that I remember the CBO existing on VAX/VMS in7.1.5, andfor sure in 7.1.6 (on VAX/VMS)-----Original Message----- I first saw the CBO in 1994 if IIRC. Seems to me it was introduced in 7.2. I'm sure Mogens knows for sure. :)