logon触发器for dba

DBA管理工作中有时候需要用到logon触发器解决很多问题：

来自yxyup。

----trace-----
create or replace trigger exp_login
after logon on database
declare
v_sid number;
v_serial number;
begin
select sid into v_sid from v$session where lower(program) like 'exp%';
select serial# into v_serial from v$session where sid=v_sid;
sys.dbms_system.set_sql_trace_in_session(v_sid,v_serial,true);
exception
when others then
dbms_output.put_line('login trigger error:' || sqlerrm);
end exp_login;
/

---export modify parameters----
create or replace trigger exp_login_mod
after logon on database
declare
v_sid number;
v_serial number;
begin
select sid,serial# into v_sid ,v_serial from v$session where lower(program) like 'exp%' ;
sys.dbms_system.set_int_param_in_session(v_sid ,v_serial,'db_file_multiblock_read_count',128);
sys.dbms_system.set_bool_param_in_session(v_sid ,v_serial,'_serial_direct_read', true);
sys.dbms_system.set_sql_trace_in_session(v_sid,v_serial,true);
exception
when others then
dbms_output.put_line('login trigger error:' || sqlerrm);
end exp_login;
/

---import modify parameters----
create or replace trigger exp_login_mod
after logon on database
declare
v_sid number;
v_serial number;
begin
select sid,serial# into v_sid ,v_serial from v$session where lower(program) like 'exp%' ;
sys.dbms_system.set_int_param_in_session(v_sid, v_serial,'db_file_multiblock_read_count', 128);
sys.dbms_system.set_int_param_in_session(v_sid, v_serial, 'sort_area_size', 104857600);
sys.dbms_system.set_int_param_in_session(v_sid, v_serial, 'sort_area_retained_size', 104857600);
sys.dbms_system.set_int_param_in_session(v_sid, v_serial, 'sort_multiblock_read_count', 128);
exception
when others then
dbms_output.put_line('login trigger error:' || sqlerrm);
end exp_login;
/

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

转载于:http://blog.itpub.net/756652/viewspace-242481/