Wednesday 29 July 2015

How to Kill the session

select * from v$session where sid in (select session_id from dba_ddl_locks where owner='APPS' and name='XHL_IBOM_REPORT_PRC');

owner=instance user name
name=object name

alter system kill session '984,45554';

984=sid and 45554=SERIAL#

No comments:

Post a Comment