We’ve had a couple of short lived, but very inconvenient I/O latency issues recently. I’ve been using the awesome Latency Heat Map Visualization by Luca Canali as one of the tools to investigate this.
I’m guessing this isn’t the type of I/O latency heat map most people would want to see from a production system.
It’s really hard for me to make a judgement about Chapterhouse: Dune. On the one hand there are some excellent characters and the general story line is great. On the other, there are parts I found really boring. I got a bit sick of the teasers without any explanation. At first is was intriguing, but as they continued I just got a bit fed up with them and decided to stop second guessing the outcome and just let it happen. I think there are two ways an author can play this game:
1) Make the outcome fairly obvious from the start, but make the journey to get there exciting. Kind of like The Dresden Files.
2) Make the outcome a mystery, but subtly lead you in the right direction.
I think this book is trying to do the latter, but is quite clumsy about it. Having said all that, I’m glad I read it. The overall outcome is more than satisfactory.
I’m not going to read the books by Frank Herbert’s son. I’ve been told they are not good, and the brief snippets I’ve read seem to reinforce that.
I guess the end of a series of books like this needs a bit of a summary. I think the first book is a total classic. The rest you can take or leave. There are definitely interesting elements to all of them, but they are not nearly as accomplished as the first.
How do you want to start the day? I’m guessing it’s not to be called out to the front of the room by a speaker and used as a guinea pig, while they ask you trick questions to make you look stupid. Tom Kyte, you will pay. Oh yes! You will pay!!!
The sessions I attended on day 2 were:
Tom Kyte : What’s new in Oracle database application development
Tim Hall (me) : A cure for Virtual Insanity : A vendor-neutral introduction to virtualization without the hype
Georgi Kodinov : Quick Dive into MySQL
Tim Hall (me) : From Zero to Hero : Using an assortment of caching techniques to improve performance of SQL containing PL/SQL calls
Husnu Sensoy : ZFS Storage can backup your Exadata
Tom Kyte : 5 SQL and PL/SQL things in the Latest Generation of Database Technology
Another very useful day indeed. I had some good feedback and interesting questions about my talks. This sort of feedback is really important when you are presenting regularly as it allows you to continuously refine your material and presenting skills. It can sometimes give you a fresh perspective on a subject, that inspires you to alter the focus of your presentations entirely. I’m very grateful to anyone who takes the time to provide this sort of feedback. Big thanks to Tom Kyte, who has given me some very useful advice over the last couple of days, but then he owes me for making me look stupid in his first session of the day!
In the evening we went out for dinner at a restaurant just down the road from the hotel. I ate plenty of cheese, so I was in heaven. Not surprisingly, much of the talk ended up being about Oracle. It may seem a little sad to some people, but when I’m surrounded by people with brains the size of a planet, I can’t help myself quizzing them about this stuff. I love it!
Great big thanks go out to Milena and her gang for organizing this event and inviting me. Thanks also to Stoyan for being my driver again. No offence to other user groups, but BGOUG conferences are my favorite events of the year. I will keep coming back as long as you will have me! Also, a big thank you to the Oracle ACE program for making this possible.
So Day 1 (part 2) didn’t go to plan because I forgot to take my camera or my phone to the party.
Suffice to say, lots of food, lots of drink (for those that do) and most importantly lots of dancing. Yes, I once again murdered the traditional dances of Bulgaria, but it’s the takling part that counts right?
I had good intentions of leaving early, but I ended up chatting about Oracle until about 02:00. Day 2 is going to be tough…
Last night we all got together to eat some food and chat. Julian Dontcheff is practically a savant where Bulgarian Poetry, World Cup match results and random Oracle facts are concerned. Although Christian Antognini was pretty impressive on the random Oracle facts too.
I didn’t have any presentations today, so I got to sit and watch. I’ve done loads of typing, mostly of syntax for 12c features, but it’s not really stuff that is worth posting, because I have no way to validate it out, so I’m just going to keep it as a reminder for when I get hold of 12c and can try it out.
The sessions I went to included:
Joze Senegacnik : Is my SQL Statement Using Exadata Features
Christian Antognini : SQL New Features in the latest generation of Oracle Database
Julian Dontcheff : Upgrading to the latest generation of database technology
Christian Antognini : How the Query Optimizer Learns from its Mistakes
Clive King : Solaris 11u1 performance and stability : features and frameworks
Tom Kyte : Tom’s Top 12 Things about the Latest Generation of Database Technology
There was a lot of material I had seen at OOW2012 and UKOUG2012, but also a lot I had not, so I’m glad I went to them. The smaller setting also made it easier to ask questions, which can be quite daunting at the big events.
Tom gave me a couple of tips that have gone straight into one of my talks for tomorrow. I’m gonna have to name check him for it, or I’ll feel like I’m passing it off as my own.
I said this after OOW2013 and I’m sure I will say it again, but the number of changes in 12c is pretty daunting. I guess the fact it’s been about a 3 year wait, rather than the normal 18 months adds to that. In many cases (but not all) it’s not the scope of the individual changes that are the issue, but the sheer volume of them. I think people are going to be blogging for a long time before they’ve got through them. It will be interesting to see what gets selected for inclusion in the OCP DBA upgrade exam.
I’m off to dinner now. I will try to get some photos and post them in “Day 1 (part 2)@ tomorrow.
It’s stupid o’clock in the morning and I’m waiting for my taxi to arrive. Considering how close Bulgaria is, it takes me a very long time to get there.
I am a mix of excited and nervous. This is my first conference this year, so all the usual insecurities are in full effect, from fear of flying to the constant nagging thoughts that perhaps I don’t know anything about Oracle and maybe I shouldn’t be on stage acting like I do.
I’m sure it will go OK and it will be nice to meet up with the gang again.
On Thursday I’ll be flying out to Bulgaria for BGOUG Spring 2013. It’s been about 18 months since I’ve visited the people over there, so I’m really looking forward to getting stuck in.
This will be my first conference of the year, so I’m feeling a little nervous at the moment. I’m sure the adrenalin rush will kick in and get me through.
I’m signed up for the southern leg of the OTN Tour of Latin America (Chile, Peru, Uruguay, Argentina, Brazil), but it will be a while before I get any confirmation, so there are no guarantees yet.
I wrote a couple of days ago about replacing my MacBook Pro hard drive with SSD. At the same time I bought a little SSD to use as the system drive for my desktop. I fitted that this morning, installed a fresh copy of Fedora 18 and mounted the original 1TB hard drive as a data drive.
Like the MacBook Pro, my desktop is a few years old, but still has plenty of grunt (Quad Core and 8G RAM) for what I need it for. I do run the odd VM on it, but any heavy stuff is run on my server, so there is no incentive to go out an buy the latest kit for what is essentially just a client PC.
The addition of the SSD means the start up time is a much better and it just feels a lot more responsive. Most apps start up almost instantly. Even GIMP, which used to take an age to start, is mega quick. I’ve put a couple of VMs on it and not surprisingly, they are fast to start up too. Overall I’m really pleased with the outcome.
The funny thing is, I never noticed how noisy spinning rust was until I switched to these SSDs. The Mac is silent and runs for a lot longer before the fan kicks in. The desktop is also silent, until I pull something from the data disk, at which point I hear that slight grinding noise.
I don’t think I would invest in large capacity SSDs for home until the prices drop considerably, but having witnessed the before and after results on these two old machines, I can’t imagine ever running without an SSD system disk again.
Cheers
Tim…
PS. While I was reconfiguring my desktop I tried out Dnsmasq. Much simpler than BIND.
Update: I worked through some of the suggestions here to enable TRIM support and reduce wear.
I’ve had my 13″ MacBook Pro since the mid 2009 refresh and it’s been really reliable. Apart from one brief visit to Apple to replace a noisy fan, I’ve had no worries. A few years ago I upgraded from 4G to 8G RAM, so I’m not stranger to taking the back off it.
Even though it’s quite old by computer geek standards, I really don’t have any performance problems. I do demos with a couple of Linux VMs running Oracle and it works OK. Despite this, I was bored the other night and decided to buy an SSD to replace the internal hard drive. It arrived yesterday, so during last nights insomnia, I decided to fit the hard drive, rather than stare at the ceiling.
The actual hard drive replacement is pretty simple. You can see an example of it here. It takes about 5 minutes.
The transfer of the data proved a little more tricky than I expected though…
Attempt 1:
I use Time Machine for backups, so I slapped in the new hard drive, booted from the CD and expected to just restore from Time Machine. It turns out my Time Machine backups weren’t as complete as I thought.
Attempt 2:
No worries. I connected my old hard drive using a USB cable, booted from the CD and used the Disk Utility to restore the old hard drive to the new SSD. That would have been fine, except the new hard drive was fractionally smaller than the old one. That would have been fine for a Time Machine backup, since the old drive was not completely full, but for an image restore it’s a big no-no. Now I was starting to get worried. I could always replace the old drive, but I was starting to think I might have wasted my money.
Attempt 3:
So finally I bit the bullet and re-installed Snow Leopard (the most recent media I had), upgraded to Lion, then Mountain Lion through the App Store. Once that was done I dragged my apps and data from the old drive across to the new drive. Job’s a good’un!
So it got solved in the end, but it wasn’t quite the blissful experience I expected.
