28 lines
676 B
SQL
28 lines
676 B
SQL
/**********************************************************************
|
|
* File: tracetrg.sql
|
|
* Type: SQL*Plus script
|
|
* Author: Tim Gorman (Evergreen Database Technologies, Inc.)
|
|
* Date: 01Dec01
|
|
*
|
|
* Description:
|
|
* SQL*Plus script containing the DDL to create a database-level
|
|
* AFTER LOGON event trigger to enable SQL Trace for a specific
|
|
* user account only. Very useful diagnostic tool...
|
|
*
|
|
* Modifications:
|
|
*********************************************************************/
|
|
set echo on feedback on timing on
|
|
|
|
spool tracetrg
|
|
|
|
create or replace trigger tracetrg
|
|
after logon
|
|
on database
|
|
begin
|
|
dbms_session.set_sql_trace(TRUE);
|
|
end;
|
|
/
|
|
show errors
|
|
|
|
spool off
|