Welcome, Guest! Log In | Create Account

Share

SQLGotcha

by marcel-jan

SQLGotcha helps you to find sessions in an Oracle database that you want to trace. Search for logged in users, OS users, Unix PIDs, a user's machine or the program that started the session.


http://sqlgotcha.sourceforge.net

Database Engines/Servers

Project Feed

  • sqlgotcha 4.0 beta file released: sqlgotcha_4.0b.zip

    SQLGotcha 4.0 allows you to search and trace Oracle sessions with a flexibility that was never available before. Now you can search for sessions based on all columns of the v$session view. 
    
    You also can trace with any event whatever you like.
    
    You can ...

    08:35AM on Mar 22 2007

  • sqlgotcha 3.0.2 file released: SQLGotcha3.0.2.zip

    Changes release 3.0.2: 
    - Fixed a bug that would not stop tracing event 10053 traces.
    - Adds event 10132 tracing, which shows literary SQL statements (including binds) in the trace files

    07:37AM on Feb 13 2007

  • sqlgotcha 3.0.1 file released: sqlgotcha_3.0.1.zip

    Changes release 3.0.1:
    - Fixed a bug that would result in a "ORA-1403 no data found" error when looking up the spid of a session. 
    -  I've took a good look at Steven Feuerstein's "Oracle PL/SQL Best Practises" to make my code more stable and to prevent ...

    11:43PM on Nov 22 2006

  • sqlgotcha 3.0 file released: sqlgotcha_3.0.zip

    Changes:
    - Oracle Real Application Cluster (RAC) functionality. It is not possible to start a trace on a different instance, but SQLGotcha can tell you there is a session you look for on a different instance in the RAC.
    - Event 10053 tracing is now ...

    12:09AM on Oct 03 2006

  • Code committed

    Anonymous committed patchset 1 of module CVSROOT to the SQLGotcha CVS repository, changing 11 files

    04:21PM on Sep 28 2006 by nobody

  • Project Information Updated

    marcel-jan registered the SQLGotcha project

    04:12PM on Sep 28 2006 by marcel-jan

  • Forum thread added

    Anonymous created the Welcome to Open Discussion forum thread

    04:12PM on Sep 28 2006 by nobody

  • Forum thread added

    Anonymous created the Welcome to Developers forum thread

    04:12PM on Sep 28 2006 by nobody

  • Forum thread added

    Anonymous created the Welcome to Help forum thread

    04:12PM on Sep 28 2006 by nobody

SQLGotcha Actions