Ardent Performance Computing
Jeremy
Single Oracle Password File on Raw with RAC
Had an interesting question come up yesterday. Was on the phone with a colleague who’s configuring TSM backups on a 3-node cluster that he’s just setup for a client in Miami. He wanted to parallelize the backup job across the cluster and was configuring the channels in RMAN. They were not using the sys account … Continue reading
Tuning SQL Statement Execution in 10g, Part 1
Last week I was in Houston teaching a class on 10g New Features and Performance Tuning for a group of developers at a fairly large organization downtown. I try to make my classes as interactive as possible and we had a number of interesting discussions about topics such as appropriate uses for bitmap join indexes, … Continue reading
Six Steps to Effective RAD
I’m sure that this topic will be irrelevant to most people. Usually, when your organization needs you to develop a new application they say to take as long as you want. Rarely do we actually have timelines or due dates. But I guess there might be one or two people out there who need to … Continue reading
Consistent Reads and Multiversioning
Came up with this demo for a class last week and I think that it’s useful. The demo illustrates one of the most important foundational concepts in an Oracle database: how Oracle provides isolation and consistency. For my favorite technical illustration of undo and redo check out slide #22 of the Redo Internals presentation on … Continue reading
Life Requires a Sense of Humor
Aris, my roommate, just now left for work. He’s working a full day even though it’s a Saturday. He just reminded me that this is another reason he’s not paid enough… Here’s a snippet of the conversation we had right before he walked out the door: Jeremy: Why are you renaming your windows domain? That’s … Continue reading
RAC Listener Best Practices
The listener is a small part of an Oracle RAC configuration – and maybe that’s why it is so often overlooked and setup with only the defaults. More often than not, the listener gets setup automatically by DBCA during the ASM or database configuration. However this is not a good practice at all; at best … Continue reading
udev for Security Conscious RAC Sysadmins
I’ve recently installed Oracle RAC on both RedHat 4 and Suse Enterprise 9. The most recent installation reminded me of an issue which has come up more than once: persistance of raw device permissions. If you remember installing Oracle on SLES8, RHEL2 and RHEL3, then you remember that you would just chmod the /dev files … Continue reading
Centralized TAF Configuration in 10g, Part 1
In Oracle 10g there are two very different ways to configure TAF: with TNSNAMES (since 8.0, automatic generation new in 10g) and with DBMS_SERVICES (entirely new in 10g). They are very different approaches and it appears that the new DBMS_SERVICES method will be preferred moving forward since it has been given precedence and overrides whatever … Continue reading
Disclaimer
This is my personal website. The views expressed here are mine alone and may not reflect the views of my employer.
contact: schneider @ ardentperf.com
Ardent Performance Computing 
Recent Comments