Re: HELP: Oracle Data Dictionary

You can get the sid from v$lock and correlate it to the osuser, and machine in v$session.
below are two queries which provide all the info. you want (assuming I understood your request!!)

select * from v$lock;

col sid for 999999
col event for a30
set linesize 100
col OSUSER for a10
select a.sid, serial#, event, process, osuser,sql_address, sql_hash_value from v$session a, v$session_wait b
where a.sid = b.sid

-- 
Ralph Byrd
Lockheed Missiles and Space Company
rbyrd_at_sunnyvale.is.lmsc.lockheed.com
+1 408-524-6663