OTN APAC 2014 : Summary

As you will have seen from my last post, I’m back in Birmingham after completing the OTN APAC 2014 tour. Here is a list of all the posts I wrote over the course of the tour. OTN APAC 2014 : The...
0 comment

OTN APAC 2014 : Auckland to Birmingham

Everything went smoothly at Auckland airport. Boarding an A380 takes quite a bit of time and I was near the front of the plane, so I was in the last group to board. Fortunately there was loads of room...
0 comment

VirtualBox 4.3.20

Just got home to find VirtualBox 4.3.20 has been released. I’ve just installed it on MaC (Yosemite), Fedora 20 and Windows 7 with no dramas so far. The downloads and changelog are in the usual places. Cheers Tim… VirtualBox...
0 comment

New leafmisscount Option in Flex Cluster 12c

In the Oracle RAC previous version we have worked with the option “misscount” of crsctl, which applies for all the servers because there was only one kind of servers, but in the new version of Oracle...
0 comment

Parallel Costs

While creating a POC of a SQL rewrite recently I received a little surprise as I switched my query from serial execution to parallel execution and saw the optimizer’s estimated cost increase dramatically....
0 comment

OTN APAC 2014 : Auckland – Day 2

My day 2 at the conference started with my analytic functions session. I’m always a bit worried I oversimplify things, but people seem to appreciate it, so perhaps I’m just being paranoid....
0 comment

Quantum Data

That’s data that isn’t there until you look for it, sort of, from the optimizer’s perspective. Here’s some code to create a sample data set: create table t1 as with generator...
0 comment

OTN APAC 2014 – Auckland – Day 1

So it was really day 2 of the conference, but it was day 1 for me, so that’s the way I’m naming it… There were seven tracks available, but I’ll be speaking about what I saw… First...
0 comment

OTN APAC 2014 : Auckland Day Off

The first day of the Auckland conference was made up of hands-on labs and workshops. I wasn’t presenting, so I arranged to meet up with some friends and have a play day. On my way out of the hotel I...
0 comment

Comparisons

“You can’t compare apples with oranges.” Oh, yes you can! The answer is 72,731,533,037,581,000,000,000,000,000,000,000. SQL> SQL> create table fruit(v1 varchar2(30)); SQL>...
0 comment