That’s Me

Gavin Soorma
  • Oracle Certified Professional
    • 7.3, 8i, 9i,10g, 11g
  • 11i Apps DBA OCP
    •
  • 10g RAC OCE
    •
  • Certified GoldenGate Implementation Specialist
    •
  • 10g OCM
    •
  • 11g OCM
    •

    Feedback

    2,409,840 hits

    Thanks A MILLION for your support!

    Please send me your valuable feedback and suggestions

    Using DBMS_ADVANCED_REWRITE with an HINT to change the execution plan

    June 29th, 2011 | Category: Administration, Performance Tuning | One comment

    Restoring Optimizer Statistics

    March 29th, 2011 | Tags: , , | Category: Performance Tuning | Leave a comment

    Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites

    February 21st, 2011 | Tags: , , , , | Category: Administration, Performance Tuning | Leave a comment

    Upgrade to 11g and ensure Optimizer Plan Stability using SQL Plan Baselines

    February 15th, 2011 | Tags: , , , | Category: Oracle 11g release 2, Performance Tuning | 3 comments

    Solving a 10g Bind Variable Peeking problem by granting and revoking privileges

    August 23rd, 2010 | Tags: , , , | Category: Administration, Performance Tuning | Leave a comment

    Using DBMS_XPLAN to obtain the EXPLAIN PLAN of a SQL Statement

    July 19th, 2010 | Tags: , , | Category: Performance Tuning | Leave a comment

    Using the AWR History Tables to compare performance - Part 2

    April 1st, 2010 | Tags: , , | Category: Performance Tuning | Leave a comment

    Using the AWR History Tables to compare performance

    April 1st, 2010 | Tags: , , | Category: Performance Tuning | One comment

    11g Optimizer Plan Stability

    January 25th, 2010 | Tags: , , , , | Category: Oracle 11g, Performance Tuning | Leave a comment

    11g Optimizer Plan Stabilty using SQL Plan Baselines

    July 30th, 2009 | Tags: , , , , | Category: Oracle 11g, Performance Tuning | Leave a comment

    Exporting and Importing AWR snapshot data

    July 25th, 2009 | Tags: , , , , | Category: Administration, Performance Tuning | One comment

    Performance Tuning Tips and Techniques

    July 17th, 2009 | Tags: , , , , , , , , , , | Category: Performance Tuning, Unix | Leave a comment

    Script – Sessions with high physical reads

    July 9th, 2009 | Tags: , , , , | Category: Performance Tuning, Scripts | Leave a comment

    Script – Latch Contention (top 5 latches)

    July 6th, 2009 | Tags: , , , | Category: Performance Tuning, Scripts | Leave a comment

    Script – Top SQL (Physical Reads)

    July 6th, 2009 | Tags: , , | Category: Performance Tuning, Scripts | Leave a comment

    Script – Top SQL (Buffer Gets)

    July 6th, 2009 | Tags: , , | Category: Performance Tuning, Scripts | Leave a comment

    Script – Segments with highest I/O activity

    July 6th, 2009 | Tags: , , , | Category: Administration, Performance Tuning, Scripts | Leave a comment

    Oracle Wait Events causes and resolutions

    July 3rd, 2009 | Tags: , , | Category: Performance Tuning | 7 comments

    Script – What Wait Events Are Sessions Waiting On

    July 2nd, 2009 | Tags: , , | Category: Performance Tuning, Scripts | Leave a comment

    Script – Sessions Waiting On A Particular Wait Event

    July 2nd, 2009 | Tags: , , | Category: Performance Tuning, Scripts | Leave a comment
     
      Older Entries »