Troubleshooting ‘DFS lock handle’ waits

November 08, 2011  |   11g,Blog,Oracle database internals,Performance tuning,RAC   |     |   7 Comments

Waits for 'DFS lock handle' can cause massive performance issues in a busy RAC cluster. In this blog entry, we will explore the DFS lock handle wait event, and understand how to troubleshoot the root cause of these waits. I am also going to use locks and resources interchangeably in this blog, but internally, they are two different types of structures. A little background DFS (stands for Distributed File System) is an ancient name, associated ...

Oracle Open World 2011 – My presentation on RAC topic

September 28, 2011  |   11g,Blog,Performance tuning,Presentations,RAC   |     |   4 Comments

I will be talking about "Administering Parallel Execution in RAC" with demos on Sunday morning 9AM-10AM (session id 28060). This is part of IOUG RAC SIG presentation series. You would enjoy the content and demos I have prepared. I know, it is too early, but hoping to see you there! BTW, if you have attended my RAC Advanced Troubleshooting class series, please don't hesitate to introduce yourself when we meet. Session details: Session ID: 28060 Session Title: IOUG: ...

RAC hack session – Tuesday – July 11 2011

July 11, 2011  |   Blog,Performance tuning,Presentations,RAC   |     |   5 Comments

I will be conducting a 1-hour deep dive session about RAC LMS process (and about LGWR processes too if time permits) using advanced UNIX utilities. Read Tanel's blog entry for details: RAC hack session See you there!

1-Day Expert Oracle-centric Conference at MIT – 07/07/11 -virtual or physical

July 06, 2011  |   Blog,Performance tuning,Presentations   |     |   0 Comment

You probably aware of 1 day event happening on July 7th Thursday 9AM-5PM EDT (virtually and physically). I will be talking about advanced UNIX tools to debug issues. You can find details of 1-day event here Here is the outline of my presentation: Advanced tools and techniques in Unix environment - Riyaj Shamsudeen - 07/07/2011, 3:15pm - 4:00pm EDT Unix environments provides rich set of tools to debug performance ...

Advanced RAC Training

I will be delivering an intense, advanced 2-week RAC training seminar in Aug 22-26 and Sep 19-23 with numerous demos, dumps and scripts. We will meet 4 hours per day, in a virtual world, 8AM-12 Noon Pacific time for those two weeks. Tanel has written has a great blog post about this seminar series Advanced RAC training. If you like my presentations about RAC and performance tuning, you will love my ...