skip to main
|
skip to sidebar
Krams Oracle Blog
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Subscribe To Kram66
Posts
Atom
Posts
Comments
Atom
Comments
Blog Archive
▼
2008
(15)
▼
September
(5)
Steps to create ASM disk group
Kill users script
Oracle RAC 10gR2 OCR and Voting Information
Kill Users killing Portal
See what objects are pinned
►
August
(10)
About Me
Kram66
Melbourne, Australia
View my complete profile
No comments:
Post a Comment