SELECT 
	s.sid, 
	username AS "User", 
	program, 
	module, 
	action, 
	logon_time "Logon", 
	l.*
FROM 	
	v$session s, v$enqueue_lock l
WHERE 
	l.sid = s.sid 
AND 
	l.type = 'CF' 
AND 
	l.id1 = 0 
AND 
	l.id2 = 2;

hostgator