Interesting sessions/tips from RMOUG

Posted by jean-pierre.dijcks on Oracle Blogs See other posts from Oracle Blogs or by jean-pierre.dijcks
Published on Wed, 23 Feb 2011 11:09:55 -0800 Indexed on 2011/02/23 23:30 UTC
Read the original article Hit count: 359

Filed under:
|
|
|
|

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!

© Oracle Blogs or respective owner

Related posts about News

Related posts about best practices