DBA FUS‎ > ‎

SQL to kill off multiple sessions all waiting for the same library cache pin

posted Sep 11, 2010, 5:22 AM by Sachchida Ojha
SELECT 'alter system kill session ''' || s.sid || ','  || s.serial# || ''';'
  FROM x$kglpn p, v$session s
  WHERE p.kglpnuse=s.saddr
  AND kglpnhdl='value of p1raw'
Comments