ORA-00030

oerr ora 00030
00030, 00000, "User session ID does not exist."
// *Cause:  The user session ID no longer exists, probably because the
//          session was logged out.
// *Action: Use a valid session ID.

select sid,serial#,machine from gv$session  where machine like 'qone%';

select sid,serial#,machine from gv$session  where machine not like 'qone%';

alter system kill session 'sid,serail#'; 

select spid from v$process where addr in (select paddr from v$sesson where sid in ('4381'));

ps -ef|grep 237266

kill -9 237266