- Any 1 or 2 eBooks/Videos -- $10 each
- Any 3-5 eBooks/Videos -- $8 each
- Any 6 or more eBooks/Videos -- $6 each
This is based on the presentation Juan Loaiza gave regarding What’s new with Exadata. While a large part of the presentation focussed on what was already available, there are quite a few interesting new features that are coming down the road.
First of was a brief mention of the hardware. I’m less excited about this. The X4 has plenty of the hardware that you could want: CPU, memory and flash. You’d expect some or all (more...)
If you want to download the slide deck, here it is. As always, I would really, really like to hear from you.
As I mentioned, it was impossible to fit in a demo within that compressed 45 minute timeline. I put the details of the demo in a separate file with all the scripts and instructions that allows you to execute the demos at your own site.Download the slide deck as well as the scripts. In addition I have also written a whitepaper to explain (more...)
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 (more...)
The Grid Infrastructure filesystem was reporting that it was a bit full today (release 220.127.116.11). This was tracked down to the “crfclust.bdb” file, which records information about the cluster health for monitoring purposes. It was 26GB. It’s not supposed to get bigger than 1GB so this is probably a bug, but let’s explicitly resolve the size issue right now and search Oracle support later. Worst case, bdb (Berkerley Database) files get (more...)
Sometimes we occasionally just miss the obvious, for years. Just noticed that an easy way to release code to a particular schema is to login as your normal DBA user (USER1) [as preferred by audit], use the alter session command to switch to point to the release schema (USER2) and run your DDL. Oracle behaves, from an object-owner perspective, as if you are logged-in as the schema owner without all the negative aspects of actually (more...)
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.
Disclosure: I'm attending Openworld at the invitation of the OTN ACE Director program who are paying for my flights, hotel and conference fee. My employer has helpfully let me attend on work time, as well as sending other team mates because they recognise the educational value of attending. Despite that, all of the opinions expressed in these posts are, as usual, all my own.
The first day of the ACE D briefing was a bit (more...)
2. Monday Sep 29th 13:30 Understanding Cache Fusion Moscone North 130
3. Tuesday Sep 30th 15:00 Exadata SIG Moscone South 208
4. Tuesday Sep 30th (more...)
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?
This year we’ll have a ton of activity at the Delphix booth. You can check out the speaking schedule, (more...)
A book tittle "I Heart Logs - Event Data, Stream Processing, and Data Integration" by (more...)
I was testing SQL plan baselines on a base 18.104.22.168 release of Oracle on a 64 bit Linux virtual machine. I ran DBMS_SPM.LOAD_PLANS_FROM_CURSOR_CACHE to create a SQL plan baseline for a test query after running that query once to get its plan in the cursor cache. When I ran the test query after creating the SQL plan baseline and called dbms_xplan.display_cursor to see its new plan I got (more...)
Here’s a quick rundown of places I plan to be during the week.
|Sunday 9/28/14 3:30||Expert Oracle Exadata: Then and Now [UGF6626]||I’ll be participating in the Exadata Then and Now Panel with Tanel Poder, Andy Colvin, Martin Bach, Karl Arao, Frits Hoogland and anyone else we can drag in. The idea is to get book authors from “Apress Expert Oracle Exadata” version 1 and version 2 (due out by the (more...)|