lfree 发表于 2016-12-15 15:44
1.数据库版本,os
2.看看语句,找到一个链接
http://blog.itpub.net/24867611/viewspace-735356/
1. 数据库是11.2.0.4的版本,db server是linux 系统 Linux 2.6.18,所以会和数据库的版本有关吗?网上有搜说这个是bug,但是不知道在这个数据库版本里面是否还是bug
2.语句是
20:52:33 SQL> update table_A set distribfeepost =(select fundstrc from table_B where table_B.portfolio = table_A.portfolio)
20:52:33 2where exists(select * from table_B where table_B.portfolio = table_A.portfolio);
876 rows updated.
Elapsed: 00:00:00.02
20:52:33 SQL> commit;
ERROR:
ORA-03114: not connected to ORACLE
commit
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [17147], [0x7F42D2E32BE8], [], [],
[], [], [], [], [], [], [], []
Process ID: 21535
Session ID: 1435 Serial number: 41649
SQL> ALTER TABLE table_A ADD (
2FOFID NVARCHAR2(1) DEFAULT('0'),
3ETFIDNVARCHAR2(1) DEFAULT('0'),
4SUBAVAILTYPENVARCHAR2(1) DEFAULT('1')
5);
ERROR:
ORA-03114: not connected to ORACLE
ALTER TABLE table_A ADD (
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [17147], [0x1AA2E2DE8], [], [], [],
[], [], [], [], [], [], []
Process ID: 12917
Session ID: 2873 Serial number: 28757
table_A 和table_B的数据量都不多,但是column很多,table_A有123 列,table_B有224列, 不知道这个有没有影响
3. 看了下您给的link,因为这个error是12月5日发现的,所以现在去看那个core dump,找不到了,所以不确定这个optimizer_dynamic_sampling参数修改后是否对我的case有用
谢谢^-^
|