ORA-600 [rworupo.1] Using Complex Index with System Generated Column Name (Doc ID 1919983.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The alert log reports regular errors like

...
Fri Jul 25 22:00:30 2014
Errors in file /opt/oracle/diag/rdbms/flibst/FLIBST/trace/FLIBST_j001_2460.trc  (incident=41207):
ORA-00600: internal error code, arguments: [rworupo.1], [28], [27], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/flibst/FLIBST/incident/incdir_41207/FLIBST_j001_2460_i41207.trc
Fri Jul 25 22:00:37 2014
Sweep [inc][41207]: completed
...

 
The accompanying trace file shows an error, current sql, pl/sql stack, error stack and plan table like below:

Dump continued from file: /opt/oracle/diag/rdbms/flibst/FLIBST/trace/FLIBST_j001_2460.trc
ORA-00600: internal error code, arguments: [rworupo.1], [28], [27], [], [], [], [], [], [], [], [], []

========= Dump for incident 41207 (ORA 600 [rworupo.1]) ========

*** 2014-07-25 22:00:31.001
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=59b1xc51shm3u) -----
select min(minbkt),maxbkt,substrb(dump(min(val),16,0,32),1,120) minval,substrb(dump(max(val),16,0,32),1,120) maxval,sum(rep) sumrep, sum(repsq) sumrepsq, max(rep) maxrep, count(*) bktndv, sum(case when rep=1 then 1 else 0 end) unqrep from (select val,min(bkt) minbkt, max(bkt) maxbkt, count(val) rep, count(val)*count(val) repsq from (select /*+ no_expand_table(t) index_rs(t)   no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad  */"SYS_NC00018$" val, ntile(254) over (order by nlssort("SYS_NC00018$",'NLS_SORT = binary')) bkt  from "CONSOLECMUSER"."CMAS_USER_SESSION" t  where "SYS_NC00018$" is not null) group by val) group by maxbkt order by maxbkt

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x9dc4b3e0     19624  package body SYS.DBMS_STATS
0x9dc4b3e0     19969  package body SYS.DBMS_STATS
0x9dc4b3e0     22151  package body SYS.DBMS_STATS
0x9dc4b3e0     23329  package body SYS.DBMS_STATS
0x9dc4b3e0     24077  package body SYS.DBMS_STATS
0x9dc4b3e0     31145  package body SYS.DBMS_STATS

----- Call Stack Trace -----

skdstdst ksedst1 ksedst dbkedDefDump ksedmp ksfdmp dbgexPhaseII dbgexProcessError dbgeExecuteForError dbgePostErrorKGE dbkePostKGE_kgsf kgeadse kgerinv_internal kgerinv kgeasnmierr rworupo qerwnProcN qerwnFetch qervwFetch qerghFetch qervwFetch qergsFetch opifch2 opifch opipls opiodr rpidrus skgmstack rpiswu2 rpidrv psddr0 psdnal pevm_EXIM pfrinstr_EXIM pfrrun_no_tool pfrrun plsql_run peidxr_run peidxexe kkxdexe kkxmpexe kgmexwi kgmexec evapls evaopn2 kkxmexcs opiexe kpoal8 opiodr kpoodr upirtrc kpurcsc kpuexec OCIStmtExecute jslvec_execcb1 jslvswu jslve_execute0 jslve_execute rpiswu2 kkjex1e kkjsexe kkjrdp opirip opidrv sou2o opimai_real ssthrdmain main


...
============
Plan Table
============
-------------------------------------------------+-----------------------------------+
| Id  | Operation                  | Name        | Rows  | Bytes | Cost  | Time      |
-------------------------------------------------+-----------------------------------+
| 0   | SELECT STATEMENT           |             |       |       |     5 |           |
| 1   |  SORT GROUP BY             |             |   254 |   17K |     5 |  00:00:01 |
| 2   |   VIEW                     |             |   254 |   17K |     4 |  00:00:01 |
| 3   |    HASH GROUP BY           |             |   254 |   10K |     4 |  00:00:01 |
| 4   |     VIEW                   |             |   254 |   10K |     3 |  00:00:01 |
| 5   |      WINDOW SORT           |             |   254 |  7366 |     3 |  00:00:01 |
| 6   |       INDEX FAST FULL SCAN | IDX_END_DATE|   254 |  7366 |     2 |  00:00:01 |
-------------------------------------------------+-----------------------------------+

  

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