Use regular expressions in OracleSQL to execute the reported ORA-07445 [_ intel_fast_memcpy.A () + 10]

The ORA-07445 [_ intel_fast_memcpy.A () + 10] error is reported using regular expressions in OracleSQL, which is caused by Oracle bug: 4440681, not

The ORA-07445 [_ intel_fast_memcpy.A () + 10] error is reported using regular expressions in Oracle SQL, which is caused by the Oracle bug: 4440681, not

Oracle version: 10.2.0.1

OS: Linux 64-bit

Regular expressions are used in SQL:

Select count (*)

FROM T

WHERE REGEXP_LIKE (T. NOTE, '^ (. | +) * (\ (either \) +', 'I ')

The first execution can be performed, the second execution reports ORA-7445, session interruption.

The records in the Trace file are as follows:

Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x5e, PC: [0x2a95574358, _ intel_fast_memcpy.A () + 10]

* ** 17:01:42. 331

Ksedmp: internal or fatal error

ORA-07445: predictionencountered: core dump [_ intel_fast_memcpy.A () + 10] [SIGSEGV] [Address notmapped to object] [0x00000005E] [] []

MOS has the following documents:

Ora-7445 [kghphosphatase] using REGEXP or TABLEfunctions [ID 415567.1]

In Oracle 10.1.0.4 to 10.2.0.2, use a regular expression or TABLE () function in SQL. May trigger ORA-7445 errors. What is mentioned in MOS is:

ORA-07445: exception encountered: core dump [kghalkaline () + 53]

Here the core dump is different from here, according to the description of MOS, in the use of regular expressions or table functions caused by ORA-7445 errors, core dump should also include: kghpld evarx1c lxreggenpblxregcomp lxkRegexpComp...

This error is caused by the Oracle bug 4440681. However, I have some discrepancies with this bug, but I have also ruled out several other possible causes. It is suspected that the bug is related. The Bug has been fixed in Versions later than oracle 10.2.0.3. Ask a friend to upgrade the database to 10.2.0.4 and test it.

,