Solution for Oracle ORA 07445 evaopn2 () +128 error problem _oracle

Problem description

Plsql developer executes a section of SQL error:

After checking alert log detailed error message is:

Ora-07445:exception Encountered:core Dump [EVAOPN2 () +128] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

Database version

10.2.0.4.0

Problem reason

Oracle bugs caused by complex view merge problems

Solving method

1, modify the hidden parameters:

2. Use hint No_merge

Modifying the hidden parameters is too wide and can cause other problems, so the hint solution is used.

The above is a small set to introduce the Oracle ORA 07445 EVAOPN2 () +128 error problem solution, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!