Thursday, September 11, 2008

Kill Users killing Portal

select 'alter system kill session ' || CHR(39) || sid || ',' || serial# || CHR(39) || ' immediate;' from v$session where program like 'java@itrapdop01%' or program like 'java@itrapdop02%' and status ='ACTIVE'

No comments: