As an active member of the Oracle user community I really enjoy talking to delegates at user conferences and user group meetings. As such I was very lucky having had the opportunity to attend two of them recently. I have written about the OUGN spring conference in the post before this, and I also enjoyed the AIM meeting earlier in March.
One of the subjects that always seems to come up is Exadata. Many, many DBAs want to have Exadata experience, and if only to tick a box. Now Exadata means a significant investment, in other words not every company on the planet will have one. On the other hand it’s reasonably complex to administer, therefore recruiters and other HR personal are very interested in DBAs with “Exadata experience”. Now, the reason of this blog post is an open question to the readers: what do you consider as Exadata experience?
The recent server switch within Fasthosts has not solved the availability issues with my website. It was down for 30 minutes again yesterday. Since the initial (accidental) server move in December the availability of the site has been terrible. What’s worse, Fasthosts seem incapable of giving me any information as to why. It’s on a shared hosting platform, so there isn’t much I can do to diagnose the issue myself.
If filled out my ACE Director Annual Self Evaluation today. Between 1st June 2011 and now, which is about 10 months, I did the following:
It’s quite scary when you list it like that.
Recently I used the COMMIT_WAIT and COMMIT_LOGGING parameters for solving (or, better, working around) a problem I faced while optimizing a specific task for one of my customers. Since it was the first time I used them in a production system, I thought to write this post not only to shortly explain the purpose of the these two parameters, but also to show a case where it is sensible to use them.
The purpose of the two parameters is the following:
This one is to be filed under the “little things I didn’t really know until now” section: RMAN duplicate. Be honest to yourself: would you have known the answer to this question: what happens to tablespaces which are read-only on the source during an RMAN duplication (not for standby)?
I have started my career as a DBA on Oracle 220.127.116.11, and at the time not everyone fully embraced RMAN. OK, RMAN made it really hard at the time to fall in love with it. So when we “cloned” our production database to development, the following steps were followed:
Unfortunately I’ve just had to pull out of the Austrian Oracle User Group conference in Vienna in June. It’s a one day conference and only one of my papers was selected. The ACED travel support requires that at least two* papers are selected before you can apply for approval, so that knocks me out of the running. Sorry for any inconvenience to the organizers. On the positive side, another slot has opened up in the schedule for someone else to present.
As a note to other ACEDs, make sure conference organizers are fully aware of the conditional nature of your application. I always try to remind people that I can only come if I get travel approval, but in this case that message got lost somewhere down the chain.
April 4, 2012 A fair number of articles on this blog are Oracle performance related in one respect or another. I started thinking about how to measure how much more efficient something is when compared to something that is never performed. Consider a situation where you had a database user account that is a member of the [...]