ORA-00600 "QERNSROWP"

SQL caused by, modify the wording can be

sql> select T3. source_id, T4. SOURCE_ID, COUNT (1)

2 from (select bss_id,

3 User_mobile,

4 To_char (query_time, ' Yyyymmddhh24miss ') Query_time,

5 ' TJ ' source_id,

6 area_id,

7 To_char (query_time, ' YYYYMMDD ') DT

8 from LTYYT_ST.T_MOBBIZ_BSS

9 where Operate_type in (' 1 ', ' 2 ', ' 3 ')

Ten and result = ' 0 '

One and Query_time >= to_date (' 2014-11-18 ', ' yyyy-mm-dd ')

Query_time < To_date (' 2014-11-19 ', ' yyyy-mm-dd ') t3

Full Join (select bss_id, max (query_time) QT, ' HD ' source_id

From T_ods_tmpmobbiz

Operate_type in (' 2 ', ' 3 ', ' 4 ')

Location_type <> ' yl '

Group by bss_id) T4

On t3.bss_id = t4.bss_id

Group by T3. source_id, T4. source_id;

ERROR:

Ora-00600:internal error code, arguments: [QERNSROWP], [1], [], [], [], [],

[], [], [], [], [], []

No rows selected

Execution Plan

----------------------------------------------------------

Plan Hash value:468241507

--------------------------------------------------------------------------------

--------------------------------------------------

| Id | Operation | Name | Rows | Bytes

| tempspc| Cost (%CPU) | Time | Pstart| Pstop |

--------------------------------------------------------------------------------

--------------------------------------------------

| 0 |                 SELECT STATEMENT |   |  234k| 1831

k| | 15114 (2) |       00:03:02 |       | |

|  1 |                 SORT GROUP by Nosort |   |  234k| 1831

k| | 15114 (2) |       00:03:02 |       | |

|   2 | VIEW |   Vw_foj_0 |  234k| 1831

k| | 15114 (2) |       00:03:02 |       | |

|* 3 |                 HASH JOIN Full OUTER |   |    234k| 13

m| | 15114 (2) |       00:03:02 |       | |

|     4 |                 PARTITION RANGE Single |     |    3 | 93

|     | 8 (0) |    00:00:01 |    38 | 38 |

|      5 |                 VIEW |     |    3 | 93

|     | 8 (0) |       00:00:01 |       | |

|* 6 | TABLE ACCESS by LOCAL INDEX rowid|     T_MOBBIZ_BSS |   3 | 141

|     | 8 (0) |    00:00:01 |    38 | 38 |

|* 7 | INDEX RANGE SCAN |    I_mbd_d | 26 |

|     | 2 (0) |    00:00:01 |    38 | 38 |

|     8 |                 VIEW |   |  234k| 7098

k| | 15103 (2) |       00:03:02 |       | |

|      7 2                 HASH GROUP by |   |    234k| 12

m| 16m| 15103 (2) |       00:03:02 |       | |

|* 10 | TABLE ACCESS Full |   t_ods_tmpmobbiz |    234k| 12

m| | 11793 (2) |       00:02:22 |       | |

--------------------------------------------------------------------------------

--------------------------------------------------

predicate information (identified by Operation ID):

---------------------------------------------------

3-access ("T3". bss_id "=" T4 "." bss_id ")

6-filter ("RESULT" = ' 0 ' and ("operate_type" = ' 1 ' or "operate_type" = ' 2 ' or "OPE

Rate_type "= ' 3 '))

7-access ("Query_time" >=to_date (' 2014-11-18 00:00:00 ', ' Syyyy-mm-dd hh24:mi

: SS ') and "Query_time" <to_date ('

2014-11-19 00:00:00 ', ' syyyy-mm-dd hh24:mi:ss '))

10-filter ("operate_type" = ' 2 ' or "operate_type" = ' 3 ' or "operate_type" = ' 4 ') A

ND "Location_type" <> ' yl ')

Statistics

----------------------------------------------------------

1 Recursive calls

1 db block gets

706859 consistent gets

0 physical Reads

0 Redo Size

749 Bytes sent via sql*net to client

520 bytes received via sql*net from client

2 sql*net roundtrips To/from Client

0 Sorts (memory)

0 Sorts (disk)

0 rows processed

;

This article is from "Allen Lee Oracle" blog, please make sure to keep this source http://lipengfei666666.blog.51cto.com/6384154/1639659

ORA-00600 "QERNSROWP"