Just about to start the second day of the Michigan OakTable Symposium. Right now there are two guys standing about 20 feet away from me who are having an animated conversation about how internal bind variable behavior and cardinality feedback changed between different versions of Oracle. That sums up the symposium so far. Some sessions … Continue reading
Yesterday, I had a fight to the death with a nasty Oracle Net problem. The battle consumed a little more of the day than I intended… but it was worthwhile for the sweet taste of victory. Everything started with this short, innocent-seeming instant message: there is something wrong with a 10g server config. connecting to … Continue reading
Back in the Oracle 9i days, I was one of those people who got on eBay to buy firewire PCI cards and disks that could do non-exclusive login. Remember that? The first time a little test cluster could be cheap enough for the home enthusiast? I still have the parts in my closet. Of course, … Continue reading
Oracle provides three ways to manage ASM: (1) through SQL, (2) through the web-based database console or grid control, and (3) through the server-based java GUI tool DBCA. These are your choices for adding storage, replacing a disk, growing a volume, etc. But if you’re an experienced DBA who recently started playing with 11gR2 ASM, … Continue reading
Quite a few people have already plugged this event (Charles Hooper, Jonathan Lewis, Tanel Poder, Doug Burns, Christian Antognini, Randolf Geist, etc) – but I want to chime in anyway. It’s so closeby and the price goes up in two days! The Thursday and Friday before OpenWorld (September 16-17), some kind folks in Michigan are … Continue reading
Some time ago, we installed Oracle on a Sun box with 48 local 1TB disks (spread across six controllers). I explained to the storage and system teams that we would use ASM as the volume manager – and as such, it would take care of mirroring. One storage admin asked me which disk was the … Continue reading
Last week Dan broke the news that we’re bringing RAC Attack back to Collaborate! We’ve run this workshop several times now: it’s gotten better every time and we’ve always received overwhelmingly positive feedback. This is going to be a great workshop in Orlando that you don’t want to miss! A Short History We first ran … Continue reading
In the last post I showed mathematically how ASM calculates the free usable space that it displays. However one of the first questions I received after presenting that internally was from someone concerned about all of the unusable space being saved just in case we lose a disk. (In my worked example it was 1/6 … Continue reading
This is quick and dirty. I hope to get a more polished write-up of what it means and how it works, but since I’m so busy right now I don’t know if I’ll get to it soon. In the meantime someone just might find this useful or informative so I’m just going to put it … Continue reading
At the company where I’m working right now, I’m part of an architecture effort to come up with our standard design for RAC on Linux across the firm. There will be dozens or possibly hundreds of deployments globally using the design we settle on. We’re internally debating whether or not we should include OCFS2 in … Continue reading
Recent Comments