Baselines

I’m not very keen on bending the rules on production systems, I’d prefer to do things that look as if they could have happened in a completely legal fashion, but sometimes it’s necessary...
0 comment

Webinar Followup (Nov. 12) – In Search of Plan Stability – Part 2

Sorry for the delay in getting this posted, but thanks to everyone who attended my November 12th webinar entitled In Search of Plan Stability - Part 2. You can download the presentation materials from...
0 comment

Oracle Database 12c : EXPAND_SQL_TEXT, APPROX_COUNT_DISTINCT, Session Sequences and Temporary Undo

While I was away on the OTN APAC tour, I wasn’t really able to sink my teeth into anything, so inspired by Connor McDonald‘s session in Perth, I decided to write up a few bits and pieces in...
0 comment

OTN APAC tour 2014 blog posts compilation

So much has been written about all the exciting events of the 2014 OTN Asia-Pacific tour. It just feels right to compile all of them into one link list. I am sorry if I missed a post, please ping me and...
0 comment

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

Challenge Me! Capturing SQL Server Data with PowerShell

Hello PowerShell lovers! If you are reading this blog post, then you are likely interested in attending my session at SQLBits (well, so far it is an abstract. Hopefully I will be selected!) Any data professional...
0 comment

KeepAlive socket in 12c listener

A not uncommon issue with firewalls and listeners are timeouts. Your production database may be behind a firewall, you may connect from a remote location, even your Windows workstation may have some firewall...
0 comment