select * from v$process p where p.ADDR not in (select b.paddr from v$bgprocess b)
and p.ADDR not in ( select s.PADDR from v$shared_server s )
and p.ADDR not in ( select s.PADDR from v$session s)
and p.ADDR not in ( select s.PADDR from v$shared_server s )
and p.ADDR not in ( select s.PADDR from v$session s)
and p.USERNAME != 'SYSTEM';
查到后找到v$process中spid的值,在unix/linux下使用kill -9 spid,即可完全kill掉无效的v$process