ora-600 [15804] while query

select trunc(trans_date),count(1) from htd_bill_master

group by trunc(trans_date)

order by trunc(trans_date);

select trunc(trans_date),count(1) from htd_bill_master

*

ERROR at line 1:

ORA-12801: error signaled in parallel query server P002

ORA-00600: internal error code, arguments: [15804], [8], [13], [12], [0], [], [], []

 

Reparse the statement by any of these methods:

1,Flush the shared pool
2,Change the case of the statement
3,Add comments in the statement


OR

Run the query serially,For example:

SELECT /*+ NO_PARALLEL(hr_emp) */ last_name
FROM employees hr_emp;

 

lab2>ALTER SYSTEM FLUSH SHARED_POOL;

 

System altered.

 

lab2>select trunc(trans_date),count(1) from htd_bill_master

  2  group by trunc(trans_date)

  3  order by trunc(trans_date);

 

TRUNC(TRA   COUNT(1)

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

17-AUG-09      25477

19-AUG-09      10618

22-AUG-09          2

09-SEP-09      10239

18-SEP-09        245

22-SEP-09          2

13-OCT-09     284021

 

7 rows selected.