Interesting sessions/tips from RMOUG
By Jean-Pierre Dijcks-Oracle on Feb 23, 2011
One of the sessions I was at at last week's RMOUG was a session on Temp Tablespace Groups. I had a look because I had no experience with this and it seemed to help with parallel processing and the allocation/usage of temp.
You can read the excellent write-up at Kellyn Pedersen's blog - who did the session and all the work - here.
So for all of those who may be seeing lot's of waits like enq: TS - Contention when you are doing hash joins and sorts, do have a look at the above blog post.
I also had the chance to listen in at Stewart Bryson's session on Restartability (he had 3 R-s) where he gave very useful tips about how to deal with your data warehouse loads. Questions like archive log mode - should I or should I not were well covered. Flashback archives, also nice to hear about. Very nice talk, very interesting. Unfortunately he hasn't blogged about it yes, so no pointers to that one.
Got to see a couple of other interesting sessions, and as conferences go got to meet some interesting Oracle folks from the region.
As usual RMOUG was useful and fun. Off to the drawing boards to design next year's session!