oracle命令登录，锁死解决办法

/*********************** oracle 命令行登录*************************************************/

1.
sqlplus /nolog
SQL> conn(与connect一样) 用户名/密码@数据库名 as sysdba

2.
sqlplus "/as sysdba"

3.
sqlplus as sysoper(以oper身份登录)
或者
sqlplus as sysdba(以管理员身份登录)

/******************** 锁死解决办法 ***************************/

SQL> select session_id from v$locked_object;

SESSION_ID
----------
       56

SQL> SELECT sid, serial#, username, osuser FROM v$session where sid = 56;

       SID    SERIAL# USERNAME                       OSUSER
---------- ---------- ------------------------------ ------------------------------
       56         2088 ghb                          fy

SQL> ALTER SYSTEM KILL SESSION '56,2088';