My Oracle Support Banner

ORA-600 arguments: [stsTmpIxInit_1] from Query against RESOURCE_VIEW (Doc ID 1166974.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Information in this document applies to any platform.


ORA-600 arguments: [stsTmpIxInit_1] is returned from query against resource_view:

SQL> select count(*) from resource_view;
select count(*) from resource_view
ERROR at line 1:
ORA-29903: error in executing ODCIIndexFetch() routine
ORA-00600: internal error code, arguments: [stsTmpIxInit_1], [513], [0], [], [], [], []

Trace file contains following functions and indicates that we are initializing temporary indexes.

Call Stack Function Dump:
ksfdmp stsTmpIxInit stsCreateTempSeg ssmini ssmalc sdbinb sdbput smbwrt smbput
sorput qmrvstp qmrvfi qeroifcf qeroifcsu qeroiFetch rwsfcd qergsFetch opifch2 opifch

Query against xdb$resource table succeeds:

SQL> select count(*) from xdb.xdb$resource;



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.