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 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

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;

  COUNT(*)
----------
    743331

Cause

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
Symptoms
Cause
Solution
References


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