Category Archives: Oracle

Riga Dev Day 2015 : The Journey Begins

-+*My first flight was 06:20, so I had to leave the house at 04:00, which meant getting up at about 03:00. Yuck! The first flight was about 90 minutes from Birmingham to Frankfurt, with the smoothest landing I can ever remember in a plane the size of an A320. I was meant to have a 65 […]

Riga Dev Day and Oracle Midlands Event #7

-+*There are a couple of things on the radar for the coming week and unfortunately for me they are both on the same day. In Birmingham, UK it is Oracle Midlands Event #7 (OM7) on Thursday 22nd of January. This will be the first Oracle Midlands event I’ve missed since it started. I’m a big fan […]

Cloud Control : Plugin Patch

-+*I applied some of the plugin patches to our Cloud Control installation today. We already have Cloud Control installed, so this was just a case of updating the plugins. Here’s a quick overview of what I did. Backup up everything! Database and file system. Setup > Extensibility > Self Update Download the latest versions […]

Flashback Data Archive Enhancements in Oracle Database 12c

-+*Having played around with Flashback Data Archive in 11g, I figured I would get through the 12c enhancements pretty quickly. I didn’t account for the fact I’m a donkey and can’t see the wood for the trees. Luckily, I know some people who aren’t stupid and they gave me a nudge in the right direction, […]

Adaptive Query Optimization in Oracle Database 12c

-+*Over the holiday period I finally decided to tackle the Adaptive Query Optimization stuff in Oracle 12c, which resulted in these articles. Adaptive Query Optimization in Oracle Database 12c Release 1 (12.1) : A links page to the other articles. Adaptive Plans in Oracle Database 12c Release 1 (12.1) Dynamic Statistics in Oracle Database 12c Release […]

“a SQL” or “an SQL”?

-+*This is an age old question and of course the answer depends on how you say “SQL”. … a Structured Query Language statement… … a Sequel statement… … an Es Queue El statement… (I say it this way) Different people say it different ways. Most of the time I don’t notice, but I just read something by […]

Oracle REST Data Services (ORDS) 3.0 on Tomcat 7

-+*What started out being a quick dabble with Oracle REST Data Services (ORDS) 3.0 spawned a bunch of different things… First, I needed a fresh APEX installation to play around with. Most of the APEX stuff I’ve been using recently has been against Oracle 11.2 databases and I follow this kind of method. Standard stuff… That’s fine, […]

Develop against the versions in the Yum repositories!

-+*I saw a tweet by Simon Haslam at the weekend that read, “I’m v surprised to read that @Atlassian Stash needs newer git than in the latest RHEL/OL6 repos!” I had a similar experience at the weekend too, but this time with Oracle REST Data Services (ORDS) 3.0 EA. According to the documentation, it requires the […]

Fedora 21 : Oracle 11g and 12c Installations

-+*Fedora 21 has arrived and it’s now delivered in three focussed flavours (Workstation, Server and Cloud). This of course resulted in the usual articles from me. Fedora 21 (F21) Installation Oracle Database 11g Release 2 (11.2) Installation On Fedora 21 (F21) Oracle Database 12c Release 1 (12.1) Installation On Fedora 21 (F21) As always, read […]

Riga Dev Day 2015

-+*Over the weekend I booked my flights and hotel for the Riga Dev Day on January 22nd. It’s my first time in Latvia, so I look forward to seeing everyone out there! Cheers Tim..