Use the following script to generate SQL to kill off multiple sessions all waiting for the same library cache pin

DBA's Home Page - A website for Oracle, Greenplum and PostgreSQL DBA's‎ > ‎DBA's Forum, Routine Tasks and Activities‎ > ‎

Use the following script to generate SQL to kill off multiple sessions all waiting for the same library cache pin

posted May 20, 2012, 6:17 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