Hotsos Symposium Speaker – Riyaj Shamsudeen

Riyaj Shamsudeen is a returning Hotsos Symposium presenter.

Biography

Riyaj ShamsudeenRiyaj Shamsudeen has 18+ years of experience in Oracle and 17+ years as an Oracle DBA/Oracle Applications DBA. He is the principal DBA for OraInternals, a consulting company resolving many advanced performance, recovery, RAC, and EBS11i issues. Riyaj specializes in RAC and performance issues and has authored many articles, mostly about performance, database internals, optimizer internals, etc.

Mr. Shamsudeen is a frequent presenter in major conferences such as Hotsos Symposia, UKOUG, RMOUG etc. He is also a proud member of OakTable network, and he blogs regularly at http://orainternals.wordpress.com.

Riyaj is an Oracle Ace, and he has co-authored two books with esteemed colleagues.

Presentation Titles

Session #1: Advanced RAC Troubleshooting, Part 1

Session #2: Advanced RAC Troubleshooting, Part 2

Abstracts

These presentations explore and troubleshoot performance issues encountered in RAC environments. Below are a few discussion points:

  • Trend analysis for global cache traffic and performance using AWR/statspack tables. Review of simple techniques to probe interconnect performance.
  • Understanding wait events in SQL trace files related to RAC such as gc cr grant 2-way, gc cr grant 3-way, gc multi block reads, etc.
  • Global cache object re-mastering
  • Global cache waits and LGWR performance. LGWR performance is important in single instance databases and LGWR performance is even more critical in RAC instances.
  • Interconnect issues, lost packets, and statistics. Identifying interconnect issues with database and OS statistics.
  • Troubleshooting performance issues with MTU/jumbo frames, and jumbo frames mis-configuration issues.
  • Troubleshooting RAC background processes such as LMS/LMD, etc.
  • Troubleshooting parallel query, interconnect, and PQ setup related performance issues.
  • Concurrency-induced global cache issues and a few time-tested simple work-arounds.
  • Troubleshooting locking issues and deadlocks in RAC environments.
  • Bind peeking issues and RAC instances.
  • ...and a few misc items.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

Riyaj ShamsudeenThe speaker schedule is as follows: