Determine the Session Waiting for a Shared Resource to be Released
Here’s how to find out which session is waiting for a shared resource to be released: Column host format a6;Column username format a10;Column os_user format a8;Column program format a30;Column tsname