AIX Oracle 10.2.0.5
1.现象
记一次开发人员drop表后,select count(*)竟能查!?
SQL> select count(*) from user1.test1;
COUNT(*)
----------
69211
但select*时报错ora-600:
SQL> select * from user1.test1;
Tue Jan 19 18:10:01 BEIST 2016
Errors in file /oraclelog/lqdb/udump/lqdb2_ora_13566380.trc:
ORA-00600: internal error code, arguments: [ktsircinfo_num1], [19], [758], [406427], [], [], [], []
Tue Jan 19 18:10:15 BEIST 2016
Trace dumping is performing id=[cdmp_20160119181015]
2.查看该用户user1下表test1已经不存在
SQL> select owner,table_name from dba_tables where table_name=upper('test1');
OWNER TABLE_NAME
------------------------------ ------------------------------
CHANNEL_MGR_HG test1
CHANNEL_MGR test1
以上是实例2上的现象,在实例1上select会正常报表不存在:应该是实例2缓存出现了问题。
3.重启实例2,问题解决
1.现象
记一次开发人员drop表后,select count(*)竟能查!?
SQL> select count(*) from user1.test1;
COUNT(*)
----------
69211
但select*时报错ora-600:
SQL> select * from user1.test1;
Tue Jan 19 18:10:01 BEIST 2016
Errors in file /oraclelog/lqdb/udump/lqdb2_ora_13566380.trc:
ORA-00600: internal error code, arguments: [ktsircinfo_num1], [19], [758], [406427], [], [], [], []
Tue Jan 19 18:10:15 BEIST 2016
Trace dumping is performing id=[cdmp_20160119181015]
2.查看该用户user1下表test1已经不存在
SQL> select owner,table_name from dba_tables where table_name=upper('test1');
OWNER TABLE_NAME
------------------------------ ------------------------------
CHANNEL_MGR_HG test1
CHANNEL_MGR test1
以上是实例2上的现象,在实例1上select会正常报表不存在:应该是实例2缓存出现了问题。
3.重启实例2,问题解决
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27126919/viewspace-1981988/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27126919/viewspace-1981988/