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:50 GMT
Message-ID: <6Txmd.87020$Kl3.33743@twister.socal.rr.com> 





Richard Kuhler wrote:


> Gary wrote:

> <snip>

> 


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




> 

> select distinct sid from v$mystat;




Sorry, that was stupid, you can avoid that sort ...



select sid from v$mystat where rownum = 1;


--
Richard Kuhler


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












Original text of this message













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