Oracle

DBD::Oracle on AIX 5.1

I installed DBD::Oracle on an IBM AIX 5.1 box, and for once I have some good news. Anyone who has ever tried this will know of some of the troubles I speak of. When dealing with DBI and any DBD on a AIX box, you either must either be lucky enough to have the same compiler installed that built the version of Perl that comes with the box (I have never seen this happen); or you have to spend a great deal of time downloading and installing your own GCC and the building your own version of Perl. Fortunately, all the hard work was done for me by other members of my team. Here’s how to do it.

UKOUG 2009 — Server Manageability Roundtable

This is a call for topics for the upcoming Server Manageability Roundtable that I will be running at UKOUG Conference 2009 Technology and E-Business Suite. The topic is quite broad so we will obviously need to focus on the most relevant areas for the attendees and this is the chance to state your interest so please comment away! Here are the topics that I think might be particularly interested…

New Oracle ACE at Pythian

I recently nominated my colleague and good friend Christo Kutrovsky for the Oracle ACE program. Today, I’m excited to share that he has been accepted and is now part of the community of 200+ Oracle ACEs and Oracle ACE Directors.

Oracle Parallel Query Sorting and Index Creation Performance Problems

There’s a serious performance bug that’s been in Oracle for a while, and finally there are hints of it been fixed, but only partially. The bug happens when performing sorting operations in parallel, and the source data is already well sorted. The “ranger” doesn’t do a good job of properly assigning row ranges to sorter processes, and ~90% of the rows end up being sent to the same parallel process, regardless of the level of parallelism.

Free 10-day trial of Safari Books Online

That’s right — get your free 10-day trial! All the information I know is here. The basics are: No access to Rough Cuts or Downloads, for new subscribers only. It’s one of those “sign up and if you do not cancel after 10 days, we bill you” — and at $42.99 a month, that’s not a mistake you want to make. Must sign up by Nov. 24th.

Where’s Everyone Gone?

Now that our new web-site is live I’d like to do the first blog post on it!

You shouldn’t be surprised if you notice that it’s difficult to locate your DBAs in the first week of December (i.e. in just two weeks from now)! And you know why? Because you need to be looking in the right place to find them.

Questions you always wanted to ask about Flashback Database…

Last Friday in the Sydney Oracle Meetup I talked about Oracle Flashback technology and how it helps to reduce downtime. The session generated great interest among the attendees, which led to interesting discussions and many questions about the subject. Some of the questions couldn’t be answered during the meeting so I’ve followed up on them and I’m posting the answers here since they may be of interest for many others.

Page 76 of 140« First Page...10...7475767778...90...Last Page »