PeopleSoft Learning

SQL to find the locked objects in the database.

select b.object_name,a.session_id,a.oracle_username,os_user_name ,
locked_mode from v$locked_object a, all_objects b where a.object_id = b.object_id order by b.object_name;