ORACLE 10g -- IIS�B�n.NET�B�q�A�q�N�c�g蠅�L�A�\�E�l�E譟�V�E�P�A�z�V萋�^ --

�A�E�A譴蕕�z�I�T�X��Z�J�A�l�A瓩�j
�E�^�E��E蹇�V�E�m�A�k�A��A�J�A�P(�t�I�z�`) �u�F

ORACLE 10g -- IIS�B�n.NET�B�q�A�q�N�c�g蠅�L�A�\�E�l�E譟�V�E�P�A�z�V萋�^ --

M.S

v0.1, 2006-03-01

SQL�E�l�E譟�V�E�P�A茲觝��A�q�B�uIIS(.Net)�A�n�A�m�A�z�E��E蹈�[�E薀爐�H�A虍�b�P��A�I�A譴�\�A發�z�A�q�N�c�g蠅�L�A�j�B�u�E�l�E譟�V�E�P�A�l�A襪�z�A�q�B�u�J賚�H�A�L�A�J�A�L�A�\�B�v
�C荳�l�A�L�A�j�E�l�E螢��B�V�A�i�E��A�A�A�j�B�u�c�~�A�L�A�\�A�E�A�l�A��A�u�A蠅�J�A�P�B�v
�E�l�E螢��B�V�A�H�A�L�A�J�A�P�A�z�A�k�B�u�T�C�P�w�A�q�A�L�A�j�A�b�A�^�A�I�A�A�B�v
�Z�[�B�u�E�l�E螢��B�V�A�c�P��A�P�A襯�P�E��B�V�E�J�B�n�E罅�V�E�J�B�q�A�q�A�}�B�uGRANT�A�k

�B�Bgrant select any dictionary to xxx; �B�Bgrant EXECUTE ON DBMS_MONITOR to xxx;
�A�\�A�B�A�j�A�b�A�^�A�I�A�A�B�v
�A�E�A譴蕕�}�A�u�A�b�A�J�A�k�T�C�P�w�A�q�A�P�A��A�J�A�T�A�v
�A�E�A譴�I�A�q�X�A�^�I�A�L�B�u�C�\�A蕕�H�A�z�c�T�E�C�A��l�b�^�N�A�L�A�j�A皸貔��^��k�A�A�}�T�`�A�J�A�T�A�v
�`�G�A�j�E�j�V�H�A�z�^��k�A�A�q�A�F�A�A�A�j�P��A�e�A�j�A�b�A�^�A�I�A�A�A�J�A�T�B�v

1. PROCEDURE�A�lTRIGGER

CREATE PROCEDURE sqltrace_proc
    (
      i_sid     IN NUMBER
    )  IS
      -- PRAGMA AUTONOMOUS_TRANSACTION;
  BEGIN
       sys.DBMS_MONITOR.SESSION_TRACE_ENABLE(i_sid,null,true,true);
  END;
/

CREATE OR REPLACE TRIGGER iisap_sqltrace
  AFTER LOGON
  ON XXXXX.SCHEMA
  DECLARE
  v_sid     NUMBER;
  v_serial# NUMBER;
  v_program VARCHAR2(64);
  v_jobno   INTEGER;
  BEGIN
    SELECT sid,serial#,program
      INTO v_sid, v_serial#,v_program
      FROM sys.v_$session
     WHERE audsid =
     (
      SELECT USERENV('SESSIONID')
      FROM dual
     );
    IF (upper(v_program) like 'W3WP.EXE%')
--      or (upper(v_program) like 'SQLPLUS%')
    THEN
         DBMS_JOB.SUBMIT(
                         job=>v_jobno,
                         what=>'sys.sqltrace_proc(' || v_sid || ');');
    END IF;
  EXCEPTION
  when OTHERS then
      return;
--      dbms_output.put_line('err');
  END;
/

2. �P�P�\�L�w躄�

v 0.1 2006-03-01 �X虍�k