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: Which RBS is my Update using ?

Re: Which RBS is my Update using ?

From: srivenu <srivenu_at_hotmail.com>
Date: 12 Sep 2002 23:00:58 -0700
Message-ID: <1a68177.0209122200.1a9a1a9c@posting.google.com> 






select rn.name


from v$rollname rn,v$transaction t,v$session s
where rn.usn=t.xidusn


and t.addr=s.taddr


and audsid=userenv('sessionid')



regards


Srivenu
Received on Fri Sep 13 2002 - 01:00:58 CDT












Original text of this message













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