Oracle Technical Stuff

This is some of my technical stuff, held together loosely in this page! If you are interested in what I do, see my resume (or CV!) on

View John Kanagaraj's profile on LinkedIn

My Book (co-authored with two of my friends):

Insider Solutions

Apart from my day to day job as an Oracle Performance Analyst, I am currently a ExecutiveEditor of IOUG‘s SELECT Journal, so if you are interested in writing a technical article on Oracle technologies, contact me!

It was also an honor to be chosen as one of the select few “Oracle ACE” by Oracle Corporation.

I am a frequent technical presenter at Oracle OpenWorld, IOUG and OAUG’s COLLABORATE and various other Oracle related user groups. I also write extensively in technical journals and some of my papers/articles are listed below. Contact me if you would like a copy:

Papers presented

Safely navigate the RBO to CBO minefield (IOUG Live! 2002): Dispels commonly held myths and misunderstandings about the Cost Based Optimizer while revealing the real dangers detailing and practical tips for migrating from the RBO to the CBO

UNIX Essentials for the Beginner DBA (IOUG Live! 2003): Practical essentials of UNIX, also covers advanced topics such as interpreting Operating System (OS) performance statistics and quick tips including a repertoire of commands that are put together to form useful snippets of code

Session Wait based Troubleshooting (IOUG Live! 2004): Tips on using information from the Oracle Wait Interface to troubleshoot RDBMS issues

Judicious use of Histograms in Oracle Applications Tuning (OAUG Connection Point2005): Shows how Histograms can be used to tune SQL in Oracle Applications (E-Biz Suite) when the code cannot be changed. Also appeared in OAUG Insight Magazine and in the Customer Knowledge Exchange Case Studies as Metalink Note 358323.1

Backporting Oracle 10g’s ADDM, AWR, ASH and Metrics to Oracle 8i and 9i (IOUG COLLABORATE 06): also presented at Oracle Open World 2006): Using real code, shows how certain 10g performance related features can be “backported” to earlier Oracle 8i and 9i releases

Know thy Database: Effectively collecting and using Database Metrics (OAUG COLLABORATE ’06): Practical examples that show how to collect and use Oracle RDBMS, E-Biz and OS metrics to effectively solve both everyday issues and support long term strategy

Your Tuning Arsenal: AWR, ADDM, ASH, Metrics and Advisors (IOUG COLLABORATE 07, presented again at Oracle OpenWorld 2007): Looks past the slick demos of the new tuning and performance related tools in Oracle Database 10g and goes “under the hood” to show how to use this information for tuning and monitoring

Diamonds in the Rough: 10gR2 Rules Manager and Expression Filters (IOUG COLLABORATE 07): Introduces Rules Manager (RM) and Expression Filter (EF) – two powerful, but relatively unknown and underutilized features of Oracle 10gR2

Practical help for the “SOXed-in” Oracle Apps DBA (IOUG COLLABORATE 07): Using SQL and scripts, this presentation will show how an E-Business “Apps” DBA can effectively extract access and privilege information, control access and report violations for SOX compliance

Core DBA to Apps DBA: What You Need to Know to Transition (IOUG COLLABORATE 07): Half Day University Seminar covering the skills and responsibilities of an “Oracle Apps” DBA in order to enable “Core DBA” attendees transition to their new responsibilities (Update: Sorry – this is not available as it is a paid-for Seminar for IOUG)

Oracle Database 10gR2: An enlightened revisit (before we give up and move to 11g!) (IOUG COLLABORATE 08) Addresses the significant gap between the “New features” books and articles that accompany the first Release of a new database version and the consolidation and extension that occurs in Release 2 of that same product.

Squeeze it dry: Leveraging Oracle Database 10gR2 features in an EBS 11i installation (IOUG COLLABORATE 08) Using the new and expanded features of 10gR2 in administering, maintaining, troubleshooting and tuning an EBS 11i / 10gR2 installation

Deep dive – Oracle Database 11g performance monitoring, upgrade testing and tuning (IOUG COLLABORATE 2010): Expand on the new tools in Oracle Database 11gR2 (Oracle RAT and SPA), specifically related to performance monitoring, upgrade testing and tuning in Oracle Database environments

Oracle’s SQL Tuning advisor and SQL Plan Baselines: Coexisting with traditional SQL Tuning (IOUG COLLABORATE 2010) – Understanding how these tools work under the hood will help you both utilize them effectively and bridge the gap to traditional SQL tuning

IOUG RAC Bootcamp: Performance monitoring and tuning RAC (IOUG COLLABORATE 2010)  Considerations and procedures for optimizing database and application performance in a RAC environment.

A Practical Approach to Database Performance Testing and Management in Oracle Database 11gR2 (IOUG COLLABORATE 2011) – Understanding and meeting practical challenges in Oracle database performance testing and management

Migrating EBS from Big Iron to a RAC Cluster on Linux: A performance perspective (IOUG COLLABORATE 2011) – Real life experiences architecting, testing and managing performance during migration from a vertically scaled Big Iron cluster to lower cost horizontal scaling, specifically highlighting the role of Services, Parallel Concurrent Processing and Application partitioning in such a project

Oracle Real Application Testing Meets the Real World – Using RAT for a major upgrade at Cisco (Invited speaker Oracle Open World 2011) – How I successfully used Oracle RAT to performance test and validate the upgrade of an Oracle EBS system

Oracle Real Application Testing: A look under the hood (IOUG COLLABORATE 2012): Going under the covers to derive a set of best practices for deploying and using Oracle RAT

Consolidated DB Replay in Oracle Database 11gR2 (Invited speaker at Oracle Open World 2012) – Making the case for using Oracle RAT and SPA for performance testing and validation, including a discussion of new features in Oracle Database 12c

Oracle Database Scalability (NoCOUG Winter 2013 Conference) What does Scalability really mean when applied to the Oracle Database? I break these concepts down to the nuts and bolts here. We also look at some of the scalability anti-patterns.

Oracle vs NoSQL – The good, the bad and the ugly (Invited speaker for IOUG COLLABORATE 2014) – Where and how to employ these NoSQL data stores effectively as well as point out some of the issues that you will have to think through (and prepare for) before your organization rushes headlong into a “Big Data” implementation

Wresting control of your Oracle data with Heat Map and ILM in Oracle DB 12c (Presented at IOUG COLLABORATE 2014 and Oracle OpenWorld 2014) – How to effectively use the Heap Map in Oracle Database 12c to understand data access patterns and combine that with partitioning for Information Lifecycle Management

Couchbase Server at Scale at eBay (Couchbase Connect 2014) – I was one of the customer keynote speakers. The presentation was professionally recorded and is available on YouTube at

Deep Dive – Oracle Sharding at eBay (NoCOUG Winter 2014) – We look at how eBay uses sharding in its Oracle databases.

Technical Articles

So what is an Oracle Apps DBA anyway? – An introduction to what an Oracle Apps (E-Business DBA) does

Low overhead Database Monitoring using Session Waits – Using session wait information (V$SESSION_WAIT) to provide low overhead monitoring

Judicious use of Histograms in SQL Tuning – Using Histograms to tune SQL performance without changing the code (this article won the IOUG Editors’ Choice Award for 2005)

Your IT Career – Kick it up a notch! – Ways and means of improving your IT career

Judicious use of Histograms in Oracle Applications Tuning – Using Histograms to tune Oracle Applications (E-Business Suite) reports

SQL Server eye for the Oracle Guy – an unbiased comparison of Oracle and SQL Server from a SQL Server DBA’s point of view; Published in the PASS (Professional Association of SQL Server ) Journal

Using ORA_ROWSCN to provide Optimistic locking – A locking approach in Web based applications (Published in IOUG’s Tips and Best Practices Booklet 2007)

Using row source operation statistics to write efficient SQL – (Published in IOUG’s Tips and Best Practices Booklet 2009)

Why is my Database Slow? (NoCOUG “Ask the Oracle ACEs” 2011) – An interesting article on how to ask the right questions to debug Application and Database performance

Oracle Database scalability – Some perspectives: (IOUG SELECT Journal Q4 2013) – We look at the various aspects of Scalability as applied to the Oracle Database.

Oracle vs NoSQL: A primer (part 1) (IOUG SELECT Journal Q4 2014) – In this two part article, we look at how the Oracle RDBMS differs from NoSQL.


4 Comments Add your own

  • 1. Jiten  |  December 20, 2007 at 5:52 pm

    Really Enjoyed reading..

  • 2. Otis Barr  |  November 1, 2008 at 12:24 pm

    Mr. Kanagaraj,

    I have come across several websites mentioning your name and more specifically the presentation you gave at Collaborate07 entitled “Core DBA to Apps DBA: What You Need to Know to Transition”.

    I was wondering if I may request a copy of the presentation, since I am working towards that very goal.

    When I found this website, I noticed several of your other papers/articles and I would like to request as many of them as you are willing to send me.

    The topics are very interesting and I am always seeking to find out more about managing my career path, as well as my knowledge of Oracle products.

    Thanks for your time and hopefully, I will get an opportunity to attend one of your presentations in the near future.

    Otis N. Barr

  • 3. Mohan Hosalaiah  |  May 22, 2009 at 8:50 am

    Hello Kanagaraj,

    I attended your presentation at Nocoug at Dublin. It is very informative. Please send me the the link to your papers on 10gr2 updates you mentioned in your session.

    Thanks and Regards

  • 4. sbhoracle  |  January 2, 2012 at 9:39 am

    You have a great blog John…n great profile too…it inspires me alot to move on



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed

%d bloggers like this: