To release session locking database objects

select a.sid, a.serial# from v$session a, v$locked_object b, dba_objects c where b.object_id = c.object_id and a.sid = b.session_id and OBJECT_NAME='REPORTER_STATUS';

alter system kill session 'sid,serial#';