ORA-07445: exception encountered: core dump [qeshIHInsertPRow()+89] on 10.2.0.4
Hi All,
i have an issue that on 10.2.0.4 database on RAC environment , below Error Occuring
ORA-07445: exception encountered: core dump [qeshIHInsertPRow()+89] [SIGSEGV] [Address not mapped to object] [0x0000F2D88] [] []
This occured only one time.
The Stack trace is as following:
funlockfile <- qeshIHInsertPRow <- qeshHDGrow <- qeshPTInsertPRowForGBY <- qeshGBYProcessPart <- qeshGBYGetNextRow
The SqL statement is :
SELECT AVG(COUNT(*)) FROM DR$WWSBR_DOC_CTX_INDX$I GROUP BY TOKEN_TEXT HAVING COUNT(*) > 1;
The Plan table is :
----------------------------------------------------------+-----------------------------------+
| Id | Operation | Name | Rows | Bytes | Cost | Time |
----------------------------------------------------------+-----------------------------------+
| 0 | SELECT STATEMENT | | | | 316K | |
| 1 | SORT AGGREGATE | | 1 | 34 | 316K | 01:05:48 |
| 2 | FILTER | | | | | |
| 3 | HASH GROUP BY | | 1 | 34 | 316K | 01:05:48 |
| 4 | INDEX FAST FULL SCAN | DR$WWSBR_DOC_CTX_INDX$X| 170M | 5794M | 304K | 01:02:15 |