973: select
974: 'alter system kill session '||''''||s.sid||','||s.serial#||'''' kill
975: from
976: v$session s 977: , v$process p 978: , dba_objects_ae e
979: where s.type <> 'BACKGROUND'
980: and p.addr = s.paddr
981: and e.object_id = s.session_edition_id