Mon Dec 26 17:07:47 2005
Shutting down instance: further logons disabled
Mon Dec 26 17:07:50 2005
SMON: Parallel transaction recovery tried
Mon Dec 26 17:07:57 2005
Shutting down instance (immediate)
License high water mark = 15
Mon Dec 26 17:08:15 2005
ALTER DATABASE CLOSE NORMAL
Mon Dec 26 17:08:15 2005
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Dec 26 17:08:21 2005
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 26
Successful close of redo thread 1.
Mon Dec 26 17:08:21 2005
Completed: ALTER DATABASE CLOSE NORMAL
Mon Dec 26 17:08:21 2005
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
这是ALTER.log中的信息,提示到此后就无提示信息。shutdown immediate 命令行也不shutdown 成功!!!!!!
请问是什么原因?shutdown immediate数据库在什么情况下会执行很长时间?
正常情况下,在上面给出的提示信息下面应该会出现下列信息
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
未提交的事务我应该无法控制,客户端太多,还存不存在其他的原因致使shutdown速度慢呢?
最初由 zhxx_ora 发布
[B]应该是主要和你的会话量及事务量有关,如果不考虑客户端的感受,可以:
alter system checkpoint;
shutdown abort; [/B]
我使用的是:
alter system checkpoint;
shutdown immediate;
但依然很慢,
SQL> shutdown immediate
Database closed.
Database dismounted.
到这步就停止不前,关标倒是一直在闪
请问
alter system checkpoint;
shutdown abort;
与
alter system checkpoint;
shutdown immediate
有什么区别?????
最初由 zhxx_ora 发布
[B]应该是主要和你的会话量及事务量有关,如果不考虑客户端的感受,可以:
alter system checkpoint;
shutdown abort; [/B]
我使用的是:
alter system checkpoint;
shutdown immediate;
但依然很慢,
SQL> shutdown immediate
Database closed.
Database dismounted.
到这步就停止不前,关标倒是一直在闪
请问
alter system checkpoint;
shutdown abort;
与
alter system checkpoint;
shutdown immediate
有什么区别?????