UKOUG conference day 2 opened up with Tom Kyte talking about 5 PL/SQL things you probably didn’t know. It did have 12c in the title but I think 4 out of the 5 were pre 12C. Implicit conversions are EVIL is my main take-away and he made me aware of (more...)
UKOUG conference day 1 and to my eye there does not seem to be that many differences between Manchester Central and Birmingham ICC. Lots of smaller halls and a large main hall, a similar lunch available, the same lack of seating. I understand that attendance is seen comparable as (more...)
Today I had the opportunity to see Amazon Web Services being used in a real environment and I was very impressed with what I saw. The ability to drive any configuration you want from a menu system and pay for only what you use seems to be the way that (more...)
When I read the list of 12c new features the one that interested me immediately was the ability to be able to recover a table from an RMAN backup. This seemed to be quite challenging as RMAN is an image copy of blocks and a table is normally copied using (more...)
With a subtitle of ‘The 10 commandments of being a good DBA within a DBA team”
I have been considering for a while what might make a good DBA manager and how that has a knock-on effect of developing DBAs and giving them an insight into best practises. These are (more...)
A short entry showing two problems that I have come across recently with datapump export and the workarounds I used.
Using ASM disk for exports
Quite often it is hard to find sufficient space to export a large amount of data, especially if trying to use a filesystem. However with (more...)
The title of this post is intentionally slightly unclear and hopefully it is intrigued people to view the post and even better, add their comments.
SQL Plan Management has been around since 11G came out which is back in 2007. It does not require a tuning pack, so the package (more...)