oracle 12C ORA-07445 12.1.0.2.0

发布时间：2020-12-12 13:34:17 所属栏目：百科来源：网络整理

导读：Mon Jun 11 14:06:23 2018 Exception [type: SIGSEGV,SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0xC9CCF40,rwsstd()+32] [flags: 0x0,count: 1] Errors in file /u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/trace/salesstdydb_p000_161906.tr

Please note:?The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

SQL> col name for a30
SQL> col description for a50

SELECT name,description from SYS.V$PARAMETER WHERE name LIKE ‘_%‘ ESCAPE ‘‘;

NAME?????????????????????????? DESCRIPTION------------------------------ --------------------------------------------------_undo_autotune???????????????? enable auto tuning of undo_retention_optimizer_use_feedback??????? optimizer use feedback

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

Mon Jun 11 14:06:23 2018 Exception [type: SIGSEGV,SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0xC9CCF40,rwsstd()+32] [flags: 0x0,count: 1] Errors in file /u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/trace/salesstdydb_p000_161906.trc? (incident=600440) (PDBNAME=SALESPDB): ORA-07445: : ?rwsstd()+32] [SIGSEGV] [ADDR:0x0] [PC:0xC9CCF40] [SI_KERNEL(general_protection)] [] Incident details in: /u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/incident/incdir_600440/salesstdydb_p000_161906_i600440.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Mon Jun 11 14:07:12 2018 Dumping diagnostic data in directory=[cdmp_20180611140712],requested by (instance=1,osid=161906 (P000)),summary=[incident=600440]. Mon Jun 11 14:07:14 2018

vi /u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/trace/salesstdydb_p000_161906.trc

Exception [type: SIGSEGV,count: 1] Incident 600440 created,dump file: /u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/incident/incdir_600440/salesstdydb_p000_161906_i600440.trc ORA-07445: 3???òì3￡′í?ó: o?D?×a′￠ [rwsstd()+32] [SIGSEGV] [ADDR:0x0] [PC:0xC9CCF40] [SI_KERNEL(general_protection)] []

ssexhd: crashing the process... Shadow_Core_Dump = PARTIAL ksdbgcra: writing core file to directory ‘/u01/app/oracle/diag/rdbms/salesstdydb/salesstdydb/cdump‘

~ ~

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=179713001088071&parent=DOCUMENT&sourceId=728311.1&id=14610432.8&_afrWindowMode=0&_adf.ctrl-state=gp38sku8n_586

Description

This bug is only relevant when using Connect By / Hierarchical Queries

A CONNECT BY query with filter/access predicates involving operators like 
DECODE,case expressions,NVL with subqueries and columns from multiple tables 
might run into compilation errors and wrong results.
 
Rediscovery Notes
 If a CONNECT BY query with subqueries in WHERE predicates fail during 
 type checking phase then you might have encountered the same problem.
 
Workaround
 alter session set "_connect_by_use_union_all" = false;