What I Learned from a Newbie Object Waited-on SeleCT DISTINCT v$session.module, Sid, username, Substr(program,1,19) PROG, sql_text, object_name From V$Session, V$Sql, dba_objects o Where v$session.status = ACTIVE And username is not null and o.object_id = row_wait_obj# And v$session.sql_hash_value = hash_value and v$session.sql_address = v$sql.address and username <> SYS
{}