00046.Oracle用户进程杀死

SQL> descv$session;

SQL> set line120

SQL> col  username for a30

SQL> select  sid,serial#,username,type from v$session;

 

       SID   SERIAL# USERNAME                      TYPE

-------------------- ------------------------------ --------------------

         1          1                                BACKGROUND

         2          1                                BACKGROUND

         3          1                                BACKGROUND

         4          1                                BACKGROUND

SQL> alter system kill  session '123,10345';