oracle 查询dba_free_space报错，ORA-00600: internal error code, arguments: [ktsxtffs-3], [8], [0], [], [], [], [], [], [], [], [], []

我来答

Dream

2021-03-23

oracle

查询视图中的SQL，
单独执行sys.xktfbfe 系统基表的时候不报错，通过内连接 select * from sys.ts ts, sys.x $ktfbfe f, sys.file$ fi where ts.ts# = f.ktfbfetsn
and f.ktfbfetsn = fi.ts#
and f.ktfbfefno = fi.relfile#查询报错，如下：
ORA-00600: internal error code, arguments: [ktsxtffs-3], [8], [0], [], [], [], [], [], [], [], [], []

我来答

添加附件

问题补充

4条回答

默认

最新

章芋文

在MOS上查到几个bug，不过都是升级到12C而且在pdb环境中才出现这个问题

ORA-600: [ktsxtffs-3], [2], [0] Observed In Alert Log Of Upgraded Database to 12.2
ORA-600 [ktsxtffs-3] On Querying x$ktfbfe After Plugging In a 11.2.0.4 Upgraded Database Into a 12.1.0.2 Container(Doc ID 2065246.1)
Bug 21783939 - ORA-600: [ktsxtffs-3] When Querying x$ktfbfe After Plugin of a Database