<div dir="ltr"><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">We have had ongoing performance issues w.r.t Oracle and stored persistentID -- even with retry below.</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">In moving from stored to computed  -- are these the following 2 changes to make?</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">SAML-NAMEID.PROPERTIES </div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">(the stored ID is the commented out lines)</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span></span><p class="gmail-m_8069703067985695001gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(78,144,114)"># Set to an empty property to skip hash-based generation of first stored ID</p><p class="gmail-m_8069703067985695001gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco">idp.persistentId.computed =</p><p class="gmail-m_8069703067985695001gmail-p3" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(57,51,255)"><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)">idp.persistentId.generator =<span> </span></span>shibboleth.ComputedPersistentIdGenerator</p><p class="gmail-m_8069703067985695001gmail-p3" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(57,51,255)"><span style="color:rgb(78,144,114);font-size:small;font-weight:400;background-color:rgb(255,255,255);text-decoration-style:initial;text-decoration-color:initial;float:none;display:inline">#idp.persistentId.generator = shibboleth.StoredPersistentIdGenerator</span><br></p><p class="gmail-m_8069703067985695001gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(78,144,114)">#idp.persistentId.dataSource = OracleDataSource</p><p class="gmail-m_8069703067985695001gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco">idp.persistentId.sourceAttribute =<span> </span><span class="gmail-m_8069703067985695001gmail-s2" style="color:rgb(57,51,255)">uid</span></p><p class="gmail-m_8069703067985695001gmail-p3" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(57,51,255)"><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)">idp.persistentId.salt =<span> </span></span>foobar+</p><p class="gmail-m_8069703067985695001gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(78,144,114)"><br></p><br></div><br style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">ATTRIBUTE-RESOLVER.XML</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">STORED</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span></span><p class="gmail-m_8069703067985695001gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(57,51,255)"><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)"><</span><span class="gmail-m_8069703067985695001gmail-s2" style="color:rgb(78,145,146)">resolver:DataConnector</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">id</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">=</span>"myStoredId"<span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">xsi:type</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">=</span>"dc:StoredId"<span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">generatedAttributeID</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">=</span>"persistentID"<span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">sourceAttributeID</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">=</span>"%{idp.persistentId.sourceAttribute}"<span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span class="gmail-m_8069703067985695001gmail-Apple-converted-space"> <span> </span></span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">queryTimeout</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">=</span>"PT5S"<span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">transactionRetries</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">=</span>"5"<span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">retryableErrors</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">=</span>"72000 23000"<span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)">></span></p><p class="gmail-m_8069703067985695001gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(57,51,255)"><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">  </span><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">      </span><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">      </span><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">      </span></span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)"><</span><span class="gmail-m_8069703067985695001gmail-s2" style="color:rgb(78,145,146)">resolver:Dependency</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">ref</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">=</span>"%{idp.persistentId.sourceAttribute}"<span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)">/></span></p><p class="gmail-m_8069703067985695001gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(78,145,146)"><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">   </span><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">      </span><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">      </span><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">      </span></span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)"><</span>dc:BeanManagedConnection<span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)">></span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)">OracleDataSource</span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)"></</span>dc:BeanManagedConnection<span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)">></span></p><p class="gmail-m_8069703067985695001gmail-p2" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(78,145,146)"><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(0,0,0)"><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">     </span><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">      </span><span class="gmail-m_8069703067985695001gmail-Apple-converted-space">   <span> </span></span></span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)"></</span>resolver:DataConnector<span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,145,147)">></span></p><br></div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial">COMPUTED</div><div style="font-size:small;text-decoration-style:initial;text-decoration-color:initial"><span></span><p class="gmail-m_8069703067985695001gmail-p1" style="margin:0px;font-variant-numeric:normal;font-variant-east-asian:normal;font-weight:normal;font-stretch:normal;line-height:normal;font-family:Monaco;color:rgb(57,51,255)"><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)"><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">       </span><span class="gmail-m_8069703067985695001gmail-Apple-tab-span" style="white-space:pre-wrap">      </span><span class="gmail-m_8069703067985695001gmail-Apple-converted-space">   <span> </span></span></span><span class="gmail-m_8069703067985695001gmail-s2" style="color:rgb(0,145,147)"><</span><span class="gmail-m_8069703067985695001gmail-s3" style="color:rgb(78,145,146)">resolver:DataConnector</span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">id</span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)">=</span>"myComputedId"<span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">xsi:type</span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)">=</span>"dc:ComputedId"<span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">sourceAttributeID</span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)">=</span>"%{idp.persistentId.sourceAttribute}"<span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">generatedAttributeID</span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)">=</span>"persistentID"<span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)"><span> </span></span><span class="gmail-m_8069703067985695001gmail-s4" style="color:rgb(147,33,146)">salt</span><span class="gmail-m_8069703067985695001gmail-s1" style="color:rgb(0,0,0)">=</span>"%{idp.ComputedIDDataConnector.salt}"<span class="gmail-m_8069703067985695001gmail-s2" style="color:rgb(0,145,147)">/></span></p></div><br></div>