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

Last updated on AUGUST 04, 2010

Applies to:

Oracle Server - 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms