| 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. |
