Search

OakieTags

Who's online

There are currently 0 users and 29 guests online.

Recent comments

Affiliations

Oracle

Oracle OpenWorld 2014 : User Group Sunday

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. :)

Oracle OpenWorld 2014 – New Data Formats and Integration

Especially on this Monday it seems all about new database data intern ration technologies and…

12c Fixed Subquery

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 11.2.0.4 and 12.1.0.2. With the t1 table from the previous article run the following:

OOW14 Session: Cache Buffer Chains Latches Demystified

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 :)

Oracle OpenWorld 2014 – In the middle of it…

It’s funny this might be one of the first time in years that my strange…

Openworld 2014

Oracle OpenWorld

Are you going to Oracle OpenWorld 2014? I am, and I hope to see you there! As you probably know, OpenWorld is a humongous event with tens of thousands of people in attendance and some amazing presentations. Why, I even hear Oracle’s new CTO might be there. I wonder if he has anything to talk about?

Oracle OpenWorld 2014 : ACE Director Briefing – Day 2

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:

OOW 2014 Schedule

Here’s a quick rundown of places I plan to be during the week.

An Interview with Kerry Osborne

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…

An Interview with Jonathan Lewis

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…