RAC Workload Management Whitepaper

Posted in: Technical Track

Unlike my previous post, this time it’s relevant for everyone and not only those lucky ones in Sydney. ;-)

I have been presenting about RAC Connection Management on a number of conferences and I have done a white paper that is focused on RAC Workload Management. It was available to the conference attendees and now is publicly available so read on.

The first time I presented RAC Connection Management during Slovenian Oracle User Group 2007 conference. The amount of information I wanted to share was huge and definitely out of scope of 40 minutes presentation.

I cut it a bit and presented at the UKOUG 2007 conference few months later. IT was much better but still packed with info difficult to absorb in 45 minutes. The next conference was RMOUG 2008 where I was much more comfortable with 60 minutes slot and finished it right on time. However, I still felt that DBA’s without extensive experience were somewhat overwhelmed by the amount of info I threw on them in one hour.

So my next presentation was at the Hotsos 2008 Symposium and its title had changed to RAC Workload Management. Obviously, the content has changed as well — it was now focused on the part of workload management and control with Oracle RAC. This is also when the whitepaper was born and what you can download now is pretty much my Hotsos 2008 whitepaper. I also introduced a live demo and that has blown me out of schedule on this one. But the responses were great so I should be satisfied.

Later on, I have presented it at the RAC Attack! in Chicago and this is when some of my demos went belly up. Otherwise, it went very well and responses were good. I’ve also done the online webinar for Oracle RAC SIG and that was broader — not only workload management part. However, I had to trow away live demo — wouldn’t work well online without direct contact with the audience.

Finally, my best time was presenting it at the UKOUG 2008 as a 2 hours masterclass. I have finished every demo and they all worked flawlessly — it wasn’t easy to set them up using my Macbook and simulate real world conditions when one of virtual machines is overloaded – it makes my Mac laptop crawling. But it all worked quite well and I’ve got excellent responses.

Now that you read until the very end you deserved it — please download RAC Workload Management whitepaper and enjoy. Note that the most juicy bits are at the very end so read on (sorry if it takes you an hour or two) — you will discover the way to create your own Load Balancing Advisory!

Any feedback would be greatly appreciated here. Please do not hesitate to let me know if you found something wrong there — quite a few parts in the presentation are not documented anywhere else publicly. At least, I didn’t see them documented anywhere.

Want to talk with an expert? Schedule a call with our team to get the conversation started.

About the Author

What does it take to be chief technology officer at a company of technology experts? Experience. Imagination. Passion. Alex Gorbachev has all three. He’s played a key role in taking the company global, having set up Pythian’s Asia Pacific operations. Today, the CTO office is an incubator of new services and technologies – a mini-startup inside Pythian. Most recently, Alex built a Big Data Engineering services team and established a Data Science practice. Highly sought after for his deep expertise and interest in emerging trends, Alex routinely speaks at industry events as a member of the OakTable.

2 Comments. Leave new

Oracle RAC Workload Management Free Webinar in Australia and the US by Alex Gorbachev | Pythian Group Blog
May 20, 2009 1:26 am

[…] I posted my RAC Workload Management whitepaper, it was downloaded by many but it turned out that not everyone has half a day to go through such […]

kalyan chakravarthy
August 25, 2009 4:32 pm

Hi Alex ,

greetings for the day

I have used u r script in pythian white paper and palced it in $CRS_HOME/racg/usrco with name service_rebalance.sh , but this script is not being called when shutdown instnace is intiated , however i have service relocation script (different script i got from oracle OTN ) it is working fine , could you plz let me know are there any modifications i need to do in the script.



Leave a Reply

Your email address will not be published. Required fields are marked *