Auto trace user's session

create user user1 identified by user1;
grant conenct,resource,alter session to user1;
conn user1/user1
create or replace trigger trace_session
 after logon on user1.schema
 begin
   execute immediate 'begin dbms_session.SESSION_TRACE_ENABLE(waits=>true,binds=>true,plan_stat=>''ALL_EXECUTIONS''); end;';
 end;
/

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/37279/viewspace-2125534/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/37279/viewspace-2125534/