Check from backend which ones are "ACTIVE"
SQL> select sid,serial#,program,module,status,process,logon_time from v$session where module like'%OPP%';
---------- ---------- ------------------------------------------------
MODULE STATUS PROCESS LOGON_TIM
------------------------------------------------ -------- ------------ ---------
4748 1 JDBC Thin Client
FNDCPOPP INACTIVE 15-JUL-20
4750 3 JDBC Thin Client
FNDCPOPP INACTIVE 15-JUL-20
4753 17 JDBC Thin Client
FNDCPOPP INACTIVE 15-JUL-20
SID SERIAL# PROGRAM
---------- ---------- ------------------------------------------------
MODULE STATUS PROCESS LOGON_TIM
------------------------------------------------ -------- ------------ ---------
5769 31 JDBC Thin Client
FNDCPOPP ACTIVE 20-JUL-20
5773 10 JDBC Thin Client
FNDCPOPP ACTIVE 20-JUL-20
5780 4 JDBC Thin Client
FNDCPOPP ACTIVE 20-JUL-20
6 rows selected.
select sid,serial#,program,module,status,process,logon_time from v$session where module like'%OPP%'and status='INACTIVE';
ALTER SYSTEM KILL SESSION 'sid,serial#' IMMEDIATE;
alter system kill session '4748,1' immediate;
alter system kill session '4750,3' immediate;
alter system kill session '4753,17' immediate;
SQL> select sid,serial#,status,logon_time,module from v$session where module like'%OPP%';
---------- ---------- -------- ---------
MODULE
------------------------------------------------
5769 31 ACTIVE 20-JUL-20
FNDCPOPP
5773 10 ACTIVE 20-JUL-20
FNDCPOPP
5780 4 ACTIVE 20-JUL-20
FNDCPOPP
Check from front end.
Actual and Target processes should both be 3.
No comments:
Post a Comment