Simplifying oracle Concepts: script to kill the session in Oracle RAC

Wednesday, 22 February 2017

script to kill the session in Oracle RAC

select 'alter system kill session '''||sid||','||serial#||',@'||inst_id||''';' from gv$session where USERNAME='XXXX';

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)