The Application DBA  

Oracle SQL Trace Scripts

trace_session.sql - Enable event 10046 tracing at the session level.
trace_logon.sql - Enable event 10046 tracing at logon by creating a logon trigger. Useful for tracing a single user.
trace_db_logon.sql - Enable event 10046 tracing at logon by creating a database logon trigger. Useful for tracing all sessions.
trace_user_on.sql - Enable event 10046 tracing for another database session. Use dispusr.sql script to determine the SID and SERIAL#.
trace_user_off.sql - Disable event 10046 tracing for another database session. Use dispusr.sql script to determine the SID and SERIAL#.
trace_onlogon.sql - Enable extended SQL tracing at logon by creating a database logon trigger. Useful for tracing all sessions.
trace_monitor_off.sql - Disable extended SQL tracing with dbms_monitor.
trace_monitor_on.sql - Enable extended SQL tracing with dbms_monitor.

 

Copyright 1998-2013 AppsDBA Consulting. All Rights Reserved.