I performing query operation in database, the SQL is as follows:
The select a.c ol1, a.c ol2, a.c ol3 from TAB where a stat='0' and type='1' and code='2' order by col2 desc, col3 asc.
Results: ORA - 03113: the communication channel file at the end of the process ID: 11892 session ID: serial number: 58109

Then look at oracle log files are as follows:
Trace the file/u01/app/base/diag/RDBMS/orcl12c/former/Trace/orcl_ora_11892 TRC
The Oracle Database Enterprise Edition 12 c Release 12.1.0.2.0-64 - bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORACLE_HOME=/u01/app/base/db_home
Linux System name:
The Node name: FSS.
Release: 2.6.32-431. The el6. X86_64
Version: # 1 SMP Fri Nov 22 03:15:09 UTC 2013
Machine: x86_64
The Instance name: former
Redo thread mounted by this instance: 1
Oracle process number: 88
Unix process pid: 11892, image: oracle @ FSS.


* * * 2017-11-03 15:23:41. 746
* * * the SESSION ID: (6.58109) 2017-11-03 15:23:41. 746
* * * CLIENT ID: () the 2017-11-03 15:23:41. 746
* * * SERVICE NAME: (orcl12c.us.oracle.com) 2017-11-03 15:23:41. 746
* * * the MODULE NAME: (PL/SQL Developer) 2017-11-03 15:23:41. 746
* * * CLIENT DRIVER: () the 2017-11-03 15:23:41. 746
* * * the ACTION NAME: (SQL & lt; B4 & gt; - the select DISTINCT bill. ID, bill BILL_TYPE_CODE, bill. RE) 2017-11-03 15:23:41. 746
* * * the CONTAINER ID: (1) the 2017-11-03 15:23:41. 746

Exception [type: SIGSEGV, Address not mapped to the object] [ADDR: 0 x4] [PC: 0 xcdfb0c6, QCDLGCD () + 70] [flags: 0 x0, count: 1)
DDE: Problem Key 'ORA 7445 [QCDLGCD] was flood controlled (0 x6) (24725) incident:
ORA-07445: 鍑虹幇寮傚父阌栾: 镙稿绩杞偍 [qcdlgcd()+70] [SIGSEGV] [ADDR:0x4] [PC:0xCDFB0C6] [Address not mapped to object] []
Dumping swap information
The Memory (the Avail/Total)=355.41 M/15950.90 M
Swap (the Avail/Total)=2047.99 M/2047.99 M
Ssexhd: crashing the process...
Shadow_Core_Dump=PARTIAL
Ksdbgcra: writing the core file to the directory '/u01/app/base/diag/RDBMS/orcl12c/former/cdump'


Everyone a great god, and ask what's the problem?

CodePudding user response:

The original poster is your TAB table is actually a complex view? Is likely to be the winning ~ stepped on a BUG

CodePudding user response:

I look up the information along while, also feel is oracle bug, but I don't know where to begin, a great god give some ideas

CodePudding user response:

ORA - 07445 is a bug of Oracle,
Need to know what TAB specific,

CodePudding user response:

refer to the second floor badehuang response:

I look up the information along while, also feel is oracle bug, but I don't know where to begin, a great god give some ideas

Since this is a BUG, no idea at all,
I just MOS has examined the corresponding BUG is with index related to join, so look at the SQL execution plan, if there are any index join and so on, modifying the SQL, or table structure, make SQL don't go try this operation,

CodePudding user response:

Alter session set "_fix_control"='14191778-0;
Try this one, and then execute your SQL