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' |
DBA FUS >
|
|
|
DBA FUS >
SQL to kill off multiple sessions all waiting for the same library cache pinposted Sep 11, 2010, 5:22 AM by Sachchida Ojha
|