My Oracle Support Banner

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

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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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