I have multiple dbms jobs running and end users are modifying data at the same time. Sometime it looks like a session is locking some other sessions. Does someone have a sql statement to determin which session is locking the others?

Thanks,

YM