应用程序中固定值太多,将oracle的参数cursor_sharing改为similar后,oracle数据自动进入quiesce模式,不知道为什么。
环境:
操作系统:HP-UX ccasDB1 B.11.23 U ia64 1741494710 unlimited-user license
oracle:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for HPUX: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
执行命令:
alter system set cursor_sharing=similar scope=both;
alter.log日志的内容:
Tue Sep 07 11:35:24 EAT 2010
ALTER SYSTEM SET cursor_sharing='SIMILAR' SCOPE=BOTH;
Tue Sep 07 11:44:41 EAT 2010
Database out of quiesce mode
Tue Sep 07 11:45:09 EAT 2010
Thread 1 advanced to log sequence 1770 (LGWR switch)
Current log# 22 seq# 1770 mem# 0: /dev/vg01/rccadb_data_raw_5g_07
Tue Sep 07 11:49:22 EAT 2010
Database in quiesce mode
需手工将数据库状态改为unquiesce.
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7214331/viewspace-672885/ ,如需转载,请注明出处,否则将追究法律责任。