-
Recent Posts
Recent Comments
- yangtingkun on 非空字段空值对查询的影响
- Eric Zong on 非空字段空值对查询的影响
- Kamus on Oracle Ace Director
- 设置全局死锁优先级 | yangtingkun on RAC全局死锁检测时间
- ORA-600(krbounotread_noctx)错误 | yangtingkun on ORA-600(krboReadBitmap_badbitmap)错误
Archives
- December 2020
- February 2019
- December 2018
- November 2018
- October 2018
- July 2018
- June 2018
- May 2018
- July 2016
- July 2013
- June 2013
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
Categories
Meta
Tag Archives: shutdown abort
DML_LOCKS设置为0导致SHUTDOWN IMMEDIATE失败
DML_LOCKS参数设置系统中允许DML锁的数量，如果将这个参数设置为0，会禁止ENQUEUE的产生，有可能轻微的提升系统的性能。 不过如果将这个参数设置为0，带来的后果会严重很多： SQL> SHOW parameter dml_locks NAME TYPE VALUE ———————————— ———– —————————— dml_locks INTEGER 264 SQL> ALTER system SET dml_locks = 0 scope = spfile; System altered. SQL> shutdown immediate DATABASE closed. DATABASE dismounted. ORACLE instance shut down. SQL> startup … Continue reading
Posted in ORACLE
Tagged create index, dml_locks, DROP TABLE, enqueue, ora-62, shutdown abort, shutdown immediate, truncate table
Leave a comment
SHUTDOWN IMMEDIATE出现ORA-27144错误
客户的10.2.0.1 RAC for AIX数据库在关闭一个节点时碰到这个错误。 告警日志中信息如下： Tue Jan 10 21:11:42 2012 Shutting down instance (immediate) License high water mark = 721 Tue Jan 10 21:11:42 2012 Stopping Job queue slave processes Tue Jan 10 21:11:42 2012 Job queue slave processes stopped … Continue reading
Posted in BUG
Tagged ORA-27144, ORA-27300, ORA-27301, ORA-27302, shutdown abort, shutdown immediate
Leave a comment