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.
Be the first to post a text review of SQLGotcha. Rate and review a project by clicking thumbs up or thumbs down in the right column.
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 use this funcionality with the new procedures sql_gotcha_pack.search_and_trace_session and sql_gotcha_pack.end_trace_session.
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
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 bugs like the one above. Amongst several changes I've added the get_this_inst_id and get_this_inst_name (internal) functions.
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 possible.
Be the first person to add a text review.
Copyright © 2009 Geeknet, Inc. All rights reserved. Terms of Use
Thanks for your rating!
Would you also like to write a review?