_convert_set_to_join default

From: Noveljic Nenad <nenad.noveljic_at_vontobel.com>
Date: Thu, 1 Mar 2018 14:30:20 +0000
Message-ID: <21902_1519914638_5A980E8E_21902_3416_1_ECDEF0CC6716EC4596FCBC871F48292AB1962915_at_ZRH-S231>

Could you please check the value of _convert_set_to_join on your database?

I'm trying to figure out what kind of condition might have flipped it to FALSE (the value wasn't set in the spfile):

select a.ksppinm name,b.ksppstvl value,b.ksppstdf deflt,   decode
(a.ksppity, 1,

'boolean', 2,
'string', 3,
'number', 4,
'file', a.ksppity) type,

a.ksppdesc description
sys.x$ksppi a,
sys.x$ksppcv b
a.indx = b.indx
a.ksppinm like '%convert_set_to_join%'
order by
name ;



--------- ----------------------------------------

TRUE boolean
enables conversion of set operator to join

I'm on Solaris x86-64 (not sure if it matters).




Please consider the environment before printing this e-mail. Bitte denken Sie an die Umwelt, bevor Sie dieses E-Mail drucken.

<html xmlns="http://www.w3.org/1999/xhtml">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">p { font-family: Arial;font-size:9pt }</style>
<br>Important Notice</br>
<br>This message is intended only for the individual named. It may contain confidential or privileged information. If you are not the named addressee you should in particular not disseminate, distribute, modify or copy this e-mail. Please notify the sender immediately by e-mail, if you have received this message by mistake and delete it from your system.</br>
<br>E-mail transmission may not be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. Also processing of incoming e-mails cannot be guaranteed. All liability of the Vontobel Group and its affiliates for any damages resulting from e-mail use is excluded. You are advised that urgent and time sensitive messages should not be sent by e-mail and if verification is required please request a printed version.<br/>

Received on Thu Mar 01 2018 - 15:30:20 CET

Original text of this message