�E�k�B�V�E�\�E��B�V�E�P�B�B�E�F�E薀�b�E襪�k�E蹈�e�E�b�A�L�A�j�A�A�A襯�T�E�e�E�L�E腑��z�k�@�A�P�A襭��v��v�t�n�N

�E�k�B�V�E�\�E��B�V�E�P�B�B�E�F�E薀�b�E襪�k�E蹈�e�E�b�A�L�A�j�A�A�A襯�T�E�e�E�L�E腑�z�k�@�A�P�A襭��v��v�t�n�N

�R鄒��B�B�B�B�j鐡�g�B�B�i�[
�R鄒��j�B2000/02/24

�V鑛�t�B�B�E�k�B�V�E�\�E��B�V�E�P�B�B�E�F�E薀�b�E�
�j睛�j�B�B�E蹈�e�E�b�A�L�A�j�A�A�A襯�T�E�e�E�L�E腑�B�R�P�A襭��v��v�t�n�N
�G�g�J��B�BOS�B�BWindows NT 4.0
�B�B�B�B�B�B�B�BOracle Oracle8 server
�Z��R��B�BORACLE�A�z�E�J�E�q�E絅�u�E襪�z�E螢��E�B�E譽�P�A�q�I��R��A�I�A譴�j�A�A�A�J�A�P

SELECT V$SESSION.SID
      ,V$SESSION.SERIAL#
      ,SUBSTR(V$SESSION.MACHINE,1,20 )
      ,SUBSTR(V$SESSION.PROGRAM,1,20 )
      ,V$SESSION.USERNAME
      ,V$SESSION.COMMAND
      ,V$SESSION.LOGON_TIME
      ,V$TRANSACTION_ENQUEUE.LMODE
      ,V$TRANSACTION_ENQUEUE.REQUEST
      ,V$TRANSACTION_ENQUEUE.BLOCK
FROM V$TRANSACTION_ENQUEUE
      ,V$SESSION
WHERE V$SESSION.SID = V$TRANSACTION_ENQUEUE.SID

V$SESSION �B�@�N�X�P��E�T�E�e�E�L�E腑�z�Z�

�P猝�� COMMAND �B�@�V�c�P��e罎�z�E�E�E�J�E�m (ﾘﾘｰｽ�v�N ﾘﾌｧﾚﾝｽ･ﾏﾆｭｱﾙ �v�~�v�E�B��v�L�v�P)

�v�C INSERT �v�E SELECT
�v�J UPDATE �v�L DELETE

V$TRANSACTION_ENQUEUE�B�B�B�@�E蹈�e�E�b�A��A�H�A�H�A�e�A�\ﾄﾗﾝｻﾞｸｼｮﾝ�A�z�Z�

�P猝�� LMODE �B�@�E�T�E�e�E�L�E腑��E蹈�e�E�b�A��T�L�A�j�A�A�A訃�� (ﾘﾘｰｽ�v�N ﾘﾌｧﾚﾝｽ･ﾏﾆｭｱﾙ �v�~�v�E�B��v�A�v�A�v�C)

�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�v�[�B�B�A�n�A�L          �v�A�B�BNULL
�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�v�C�B�B�P��J��w��        �v�E�B�B�P��E蹈�e�E�b
�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�v�G�B�B�J��w��          �v�I�B�B�J��w��B�\�P��E蹈�e�E�b
�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�v�J�B�B�m�Xﾛｯｸ

SELECT V$SESSION.SID
      ,V$SESSION.SERIAL#
      ,SUBSTR(V$SESSION.MACHINE,1,20 )
      ,SUBSTR(V$SESSION.PROGRAM,1,20 )
      ,V$SESSION.USERNAME
      ,V$SESSION.COMMAND
      ,TO_CHAR(V$SESSION.LOGON_TIME,'YYYYMMDD HH24MISS')
      ,V$TRANSACTION_ENQUEUE.LMODE
      ,V$TRANSACTION_ENQUEUE.REQUEST
      ,V$TRANSACTION_ENQUEUE.BLOCK
      ,SUBSTR(V$ACCESS.OBJECT,1,50 )
FROM V$TRANSACTION_ENQUEUE
      ,V$SESSION
      ,V$ACCESS
WHERE V$SESSION.SID = V$TRANSACTION_ENQUEUE.SID
   AND V$SESSION.SID = V$ACCESS.SID
   AND V$SESSION.STATUS = 'KILLED'
�B�B AND V$ACCESS.TYPE = 'TABLE'

V$ACCESS�B�B�B�B�B�B�B�B�B�@�N�X�R�K�E蹈�e�E�b�A�I�A譴�j�A�A�A�DB�j發�zｵﾌﾞｼﾞｪｸﾄ�B�u�I��A��A�X�A�zｵﾌﾞｼﾞｪｸﾄ�A�q�E�u�E�b�E�T�E�P�A�L�A�j�A�A�A�
�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B�B �E�T�E�e�E�L�E腑�X�V�B�A�L�A�J�A�P

�A�E�A�E�A�k�T�l�w��A�L�A�j�A�A�A觜猝��A�}VIEW�A�z�e罎�z�[貮�k�A�P�B�v
�E�jVIEW�A�z�P猝��A�q�A�g�A�A�A�j�A�}�E螢��E�B�E譽�P�A�C�Z�l�A�L�A�j�A�b�A�^�A�I�A�A�B�v

Copyright (C) 1999 System Infinity Corporation. All rights reserved.