last updated: wednesday, 2004-10-27 0:39 eygle 【扩展信息:ora-600[12333]错误小结及跟】
--how to set events with spfile and etc. 本文发表于itpub技术丛书«oracle数据库dba专题技术精粹»,未经许可,严禁转载本文. 原文出处: http://www.eygle.com/faq/oracle9i.new.feature.spfile.05.htm 七. 设置events事件 events事件是oracle的重要诊断工具及问题解决办法,很多时候需要通过events设置来屏蔽或者更改oracle的行为,下面我们来看一下怎样修改spfile,增加events事件设置: sql> alter system set event=´10841 trace name context forever´ scope=spfile; system altered. sql> startup force; oracle instance started. total system global area 101782380 bytes fixed size 451436 bytes variable size 75497472 bytes database buffers 25165824 bytes redo buffers 667648 bytes database mounted. database opened. sql> show parameter event name type value ------------------------------------ ----------- ------------------------------ event string 10841 trace name context forever 顺便提一句,10841事件是用于解决oracle9i中jdbc thin driver问题的一个方法,如果你的alert.log文件中出现以下错误提示:wed jan 7 17:17:08 2004 errors in file /opt/oracle/admin/phsdb/udump/phsdb_ora_1775.trc: ora-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] wed jan 7 17:17:18 2004 errors in file /opt/oracle/admin/phsdb/udump/phsdb_ora_1777.trc: ... 下一页