For the past month I’ve been intending to put together a post about DBMS_SERVICES and TAF – so I guess it’s about time to do it. I introduced the topic back in February in my discussion of 10g enhancements to client-side TAF configuration. As I pointed out then, there are two ways to configure TAF [...]
Centralized TAF Configuration in 10g, Part 2
March 29th, 2007 § 5 Responses
NOT NULL Plus TAF Causing ORA-08176
March 28th, 2007 § 1 Response
Just stumbled onto an interesting situation with TAF. Turns out that you can get an ORA-08176 error (consistent read failure; rollback data not available) from a SELECT statement that fails over with Transparent Application Failover in a RAC configuration. And I seem to have found a situation where adding a NOT NULL constraint to a [...]
DBCA Slow? Check Host Equivalence.
March 27th, 2007 § 3 Responses
Heh – just ran into an all-too-familiar “duuh” situation. I was launching DBCA to update a few settings on some services in a test database and it was taking …f…o…r…e…v…e…r… to run. It must have spent a minute on this partially updated screen. Now I haven’t launched DBCA in a week or so on this [...]
Tuning SQL Statement Execution in 10g, Part 2
March 23rd, 2007 § 5 Responses
Tuesday I wrote about a client in Houston and removing the RULE hint from queries as part of their 10g migration. This led into a discussion about the four ways to control SQL statement execution: rewriting the SQL, hints, stored outlines and SQL profiles. I then discussed the first two methods – rewriting SQL and [...]
RAC File Permissions Quick Reference
March 22nd, 2007 § 3 Responses
I was just thinking today about how useful it might be to have a quick reference to permissions on Oracle RAC databases. Can’t tell you how many time I’ve asked “what should the permissions be for this”… so I’m just going to use this post for all the files I can think of and their [...]
Single Oracle Password File on Raw with RAC
March 21st, 2007 § 2 Responses
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 [...]
Tuning SQL Statement Execution in 10g, Part 1
March 20th, 2007 § 2 Responses
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, [...]