PeopleSoft_table Lock...

Following is query used to check if any locking is there in Database.

select obj.object_name, lck.session_id, lck.oracle_username,
lck.os_user_name, lck.process, lck.locked_mode
from sys.all_objects obj, sys.v_$locked_object lck
where obj.object_id = lck.object_id
order by obj.object_name, lck.os_user_name;

If any rows are there...its also one of reason for freezing of Application Designer.