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;
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