• 11g Real Application Testing
  • Oracle 11g – taking High Availability to the next level
  • Partitioning – Let’s Divide a and Conquer
  • A Practical Guide to Oracle 10g RAC
  • 11g Active Data Guard
  • 11g Total Recall

  • Here are some very good presentations from various Oracle conferences which I attended and which I thought I would share with the wider community.

    I am still in the process of uploading ones which I think will be most useful, so this page will be updated on a regular basis as there are about 200 presentations to upload.

    Please Note:
    If anyone has objection to these presentations being made available for viewing by the general public or if it is in breach of any copyright restrictions, then kindly do let me know and I will remove the presentation from the web site.

    Thanks to all the authors of these presentations for their good work.

  • Oracle 10g on Solaris to Oracle RAC 11gR2 on Linux Upgrade
  • Oracle Database 11g Release 2 Security Update and Plans
  • Oracle ASM Cluster File System (ACFS)- See What’s New
  • Advanced Compression: Deep Dive into OLTP Table Compression
  • Advanced Compression – Reduce Storage, Reduce Costs, Increase Performance
  • Real-World Deployment and Best Practices with Oracle Audit Vault
  • Real-World Deployment and Best Practices with Oracle Database Vault
  • Oracle Data Warehouse Strategic Update
  • Search in Oracle 11g
  • Oracle Database 11g New Search Features and Roadmap
  • Partitioning, More Cost Savings, Better Performance, Better Management in 11g
  • Getting to know the ins and outs of Oracle Partitioning in Oracle Database 11g
  • Oracle Database Performance: Latest Developments, What’s Next
  • Oracle Database 11g SecureFiles and Database File System (DBFS)
  • Encrypt Your Application Data with Oracle Advanced Security
  • Oracle11g Transparent Data Encryption
  • What’s New for Oracle Database 11gR2 on Windows?
  • Secrets of Successful Database 11gR2 Upgrades in an E-Business Suite Environment
  • Deploying Oracle E-Business Suite on Oracle RAC 11g on AIX
  • Oracle Active Data Guard: What’s Really Under the Hood?
  • Active Data Guard Hands On Lab
  • Practical Active Session History (ASH)
  • Analyzing Application Performance in RAC
  • Anatomy of a Database Attack
  • Are You Sure You Can Recover In Any Circumstance?
  • Avoiding SQL Performance Regressions
  • Best Practices for Oracle Database and Client Deployment on Windows
  • The Most Common Upgrade Mistakes (and How to Avoid Them)
  • Oracle Database Performance Secrets Finally Revealed
  • Seamless Application Failover with Oracle Data Guard
  • Data Guard Menu
  • Three R’s of Data Warehouse Fault Tolerance
  • Best Practices for Extreme Performance with Data Warehousing on Oracle Database
  • Ten Tips on Earning and Using Your Oracle Certification
  • Online Application Upgrade of Oracle’s Bug DB with Edition-Based Redefinition
  • Edition Based Redefinition
  • Explaining the Explain Plan
  • Get the Best Out of Oracle Data Pump Functionality
  • One Command Install How to Install the Grid in ~30 minutes
  • Implementing Oracle ASM Successfully
  • Indexing New Features: Oracle 11g Release 1 and Release 2
  • Best practices on managing parallel execution in concurrent environments
  • Managing XML Content with XML DB
  • Strategies for Monitoring Large Data Centers with Oracle Enterprise Manage
  • Monitoring and Diagnosing Oracle RAC Performance with Oracle Enterprise Manager
  • Oracle Enterprise Manager Security Best Practices
  • Real-World Deployment and Best Practices with Oracle Advanced Security
  • Oracle as a Service
  • Oracle Net Services: Performance, Scalability, HA and Security Best Practices
  • Deploying Oracle Database 11g Securely on Oracle Solaris
  • Best Practices for Oracle Database Performance on Windows
  • Get the best out of Oracle Scheduler
  • Practical Performance Management for Oracle Real Application Clusters
  • Maximizing Database Performance: Performance Tuning with DB Time
  • Optimize your database using policy-managed Oracle Real Application Clusters (RAC) Databases
  • RAC – Best Practices at AT&T
  • RAC One Node – The “Always On” Single Instance Database
  • Lessons from the RAC Pack: Oracle Real Application Clusters on Oracle VM – Best Practices
  • Real-Time Data Warehousing & Fraud Detection with Oracle 11gR2
  • Real World Mission Critical Database Monitoring at AT&T with Oracle Enterprise Manager
  • RMAN-Backup and Recovery The Most Essential But The Most Ignored
  • EMC Backup and Recovery for Oracle Database 11g
  • Recovery Manager (RMAN) Configuration and Performance Tuning Best Practices
  • SQL Server to Oracle A Database Migration Roadmap
  • SQL Tuning for Smarties, Dummies and Everyone in Between
  • Gather Stats with confidence
  • Top N Query: How to use STOPKEY
  • Top Tips for getting optimal SQL execution
  • Automate a Secure Historical Data Store with Oracle Total Recall
  • Manage the Manager: Diagnosing and Tuning Oracle Enterprise Manager
  • Database Upgrade/Migration Options & Tips
  • Minimal Downtime Strategies for Planned Maintenance
  • What do I really need to know when upgrading
  • What Else Can I Do with System and Session Performance Data

  • The following two tabs change content below.

    Gavin Soorma

    Latest posts by Gavin Soorma (see all)


    1. Hi Gavin

      When do we need RAC really?

      Out of my own experience,I have seen RAC doing ‘bad’ at times.

      Performance is not so good in RAC machines(lot of ‘gc’ wait events clinging up space and time )

      Please advise


    2. Hi Shafi – there is no real right or wrong answer to this. RAC basically affords two advantages which is availability and scalability. In terms of availability if one node or server goes down, the application will continue to run on the other surviving node or nodes. Also, from the scalability point of view, RAC enables you to provide capacity on demand. So as the application user base grows, it may not always be possible to grow vertically as you may be hitting machine or OS limits in terms of adding CPU – you then need to grow or scale out horizontally by adding additional nodes to cater for increased capacity requirements. RAC is NOT the answer for all applications and needs to be carefully considered as it is a different kettle of fish as compared to a single instance database. However, as far as performing poorly goes I do not think that would be a general case for RAC – and in almost 99% of the cases, the problem always lies in the interconnect between the nodes in the cluster which is in most cases responsible for all the ‘gc’ related waits.

    3. your answer is well appreciated,thanks!

    4. Dear Gavin:
      I am using ASM RAC box(10204) on Linux RHEL3(ocfs v2,perhaps) – suddenly,there are few messages saying “ORA- Diskgroup space exhausted” while trying to add datafiles….(weirdly,the DG +DATA1 has ample amt. of freespace on it – >asmcmd df -k )

      I looked into the matter by myself and studied that there are some issues with DG rebalancing…Per some metalink notes etc,I used “alter DG rebabalance power limit 11” before I successfully added few datafiles…

      I emperically used this command twice or thrice and observed the progress of this op – v$asm_operation and >asmcmd df -k

      I understand amending Power limit(at the memory) for disk – rebalancing to higher value than default 1 etc,will hamper the performance of your whole system with more and more CPU cycles……that too being a 2tb VLDB system used for Compliance…I don’t need to take a chance either…

      What is your suggestions?


    Comments are closed.