Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I want to know information about the session which updates a certain table

Re: I want to know information about the session which updates a certain table

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 17 Nov 2004 01:32:53 GMT
Message-ID: <9Txmd.47610$jo2.18605@twister.socal.rr.com> 





Gary wrote:


<snip>


> From the trigger, how can I tell which SID/SPID is updating

> AccountStatus?




select distinct sid from v$mystat;


--
Richard Kuhler


Received on Tue Nov 16 2004 - 19:32:53 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US