Sunday started with the walk across the Golden Gate Bridge. It was meant to be a run, but a few of us lazy folk met up early and walked it instead. I did run about 5 paces, so I don’t feel quite so guilty about having a “I ran the bridge” type T-shirt.
Especially on this Monday it seems all about new database data intern ration technologies and…
It’s been about 8 months since I posted a little note about a “notable change in behaviour” of the optimizer when dealing with subqueries in the where clause that could be used to return a constant, e.g.:
select * from t1 where id between (select 10001 from dual) and (select 90000 from dual) ;
There’s been a note at the start of the script ever since saying: Check if this is also true for any table with ‘select fixed_value from table where primary = constant’ I finally had a few minutes this morning (San Francisco time) to check – and it does, in both 220.127.116.11 and 18.104.22.168. With the t1 table from the previous article run the following:
Thank you all those who came to attend my session "Demystifying Cache Buffer Chains Latches" at Oracle Open World 2014. Much appreciated. I hope you got something out your time investment.
I have also written a paper to accompany this session. The paper explains the concepts I presented in greater detail. You can download a zip file containing the slide deck, the paper and the scripts here. Please note: this is a zip file.
And, yes, here is the blog entry that talka about why you need 7X memory to completely fit your database in buffer cache http://arup.blogspot.com/2011/04/can-i-fit-80mb-database-completely-in.html
As always, I would love to hear about your thoughts on the presentation.
One down at #oow14; five more to go :)
It’s funny this might be one of the first time in years that my strange…
Day 2 of the ACE Director Briefing followed a similar format to day 1. Lots of things we are not allowed to talk about and a few things we can.
Of the things we can talk about:
Here’s a quick rundown of places I plan to be during the week.
Me : Great to get some time with you Kerry.
Kerry : I’m wearing a baseball cap.
Me : OK… Come to think of it, I’m not sure I’ve ever seen you without one.
Kerry : I never take it off.
Me : Really? Isn’t that a bit inconvenient?
Kerry : Not really. If the peak gets in the way I turn the cap around.
Me : OK… So what’s your favourite sport?
Kerry : Baseball, mostly because of the caps…
Me : I’m a bit pushed for time, can I get back to you to finish off this interview?
Kerry : Sure thing dude. I’ll send you an Enkitec cap…
Me : Nice to meet you Jonathan.
Jonathan : I find speaking English too inefficient, so I will be answering the questions using ASCII.
Me : Oh. OK. That’s going to be kind-of confusing, but let’s try. Where do you get information about Oracle from?
Jonathan : 68,101,102,105,110,105,116,101,108,121,32,110,111,116,32,121,111,117,114,32,119,101,98,115,105,116,101,32,121,111,117,32,105,100,105,111,116,33
Me : I’m not sure this is going to work out. Thanks for your time… I think…