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

    Script – List Objects being accessed by a particular SID

    July 1st, 2009 | Tags: , | Category: Scripts | Leave a comment

    Script – Temporary tablespace usage

    June 30th, 2009 | Tags: , , , | Category: Monitoring, Scripts | One comment

    Monitor long running operations using v$session_longops

    June 30th, 2009 | Tags: , , , | Category: Administration, Monitoring, Scripts | Leave a comment

    Monitor Data Guard Log Shipping

    June 30th, 2009 | Tags: , , | Category: Monitoring, Scripts | Leave a comment

    Identify active transactions in undo and rollback segments

    June 29th, 2009 | Tags: , , , | Category: Monitoring, Scripts | Leave a comment

    Locked Sessions and Locked Objects

    June 29th, 2009 | Tags: , , , , | Category: Monitoring, Scripts | Leave a comment

    Identify database idle sessions

    June 29th, 2009 | Category: Scripts | Leave a comment

    Identify database SID based on OS Process ID

    June 29th, 2009 | Tags: , , | Category: Scripts | Leave a comment

    Identify OS process ID based on database SID

    June 29th, 2009 | Tags: , , | Category: Scripts | Leave a comment

    List all tablespaces with free space < 10%

    June 29th, 2009 | Category: Scripts | Leave a comment

    Monitor the Flashback area space usage

    June 29th, 2009 | Tags: , , , | Category: Scripts | Leave a comment

    Identify 'hot' objects when faced with 'Cache Buffers Chains Latch' wait event

    June 29th, 2009 | Tags: , , , | Category: Scripts | Leave a comment

    Monitor space used in ASM Disk Groups

    June 29th, 2009 | Tags: , , , | Category: Administration, Scripts | One comment

    Determing the optimal UNDO tablespace size

    June 24th, 2009 | Tags: , , | Category: Administration, Scripts | Leave a comment

    Query the RMAN catalog to check backup status

    June 23rd, 2009 | Category: Administration, Scripts | One comment

    Script- Track redo generation by day

    June 20th, 2009 | Tags: , , , | Category: Monitoring, Scripts | One comment

    Recompiling Objects based on dependencies

    June 20th, 2009 | Category: Administration, Scripts | Leave a comment

    Using DBMS_SCHEDULER to run a UNIX shell script

    June 18th, 2009 | Tags: , , | Category: Administration, Scripts | One comment

    Trigger to use with Data Guard to change service name

    June 18th, 2009 | Category: Administration, Scripts | Leave a comment

    Redo Log File Switches – By hour of the day

    June 18th, 2009 | Tags: , , , | Category: Monitoring, Scripts | Leave a comment
    « Newer Entries  
      Older Entries »