ORACLE 10G 怎么不能解除用户的锁定

Question

用sys链接完
敲完 alter user 用户名 account unlock；
等了有半个多小时都没反应。
谢谢帮解答一下

Answer 1

看看v$session_wait中在等待什么？

Answer 2

select wait_time from v$session_wait 里面的是零和一

Answer 3

select event,seq#,sid from v$session_wait;

Answer 4

这样吧,做个系统的dumporadebug setmypidoradebug unlimitedoradebug dump systemstat 10;90s..oradebug dump systemstat 10;90s..oradebug dump systemstat 10;oradebug tracefile_name;<==这里输出的结果就是要看的dump部分了,上传上来或者发到

Answer 5

SQL> select event,seq#,sid from v$session_wait;EVENT                                                                  SEQ#
---------------------------------------------------------------- ----------
       SID
----------
pmon timer                                                                5
       170rdbms ipc message                                                       378
       157rdbms ipc message                                                         6
       154
EVENT                                                                  SEQ#
---------------------------------------------------------------- ----------
       SID
----------
rdbms ipc message                                                        78
       156rdbms ipc message                                                        10
       169rdbms ipc message                                                         3
       160
EVENT                                                                  SEQ#
---------------------------------------------------------------- ----------
       SID
----------
rdbms ipc message                                                         3
       161rdbms ipc message                                                         3
       162rdbms ipc message                                                         3
       163
EVENT                                                                  SEQ#
---------------------------------------------------------------- ----------
       SID
----------
rdbms ipc message                                                       168
       165rdbms ipc message                                                        39
       166rdbms ipc message                                                        76
       167
EVENT                                                                  SEQ#
---------------------------------------------------------------- ----------
       SID
----------
rdbms ipc message                                                         5
       168smon timer                                                                1
       164SQL*Net message to client                                                11
       158
已选择15行。SQL>

Answer 6

....现在还是hang住的吗?如果没有hang了,这些信息就没用了.

Answer 7

???我是说,你捕捉到这些信息的时候,你开始hang住的那个会话已经恢复正常了吧.还是?.....