CalDAV Protocol Bad SQL Performance, Synchornization Taking Up Several Minutes And Timing Out. (Doc ID 2709029.1)

Last updated on APRIL 02, 2024

Applies to:

Symptoms

Customer configure MS Outlook with CalDAV Synchronizer plug-in to synchronize Calendar appointment between MS Outlook and Siebel Application using CalDAV Protocol.

After configured CalDAV Synchronizer MS Outlook plugin and Siebel Enterprise as per Document Configuring Support for New CalDAV or CardDAV Publishing (Doc ID 2220138.1) the MS Outlook users were able to synchronize appointment on MS OUtlook.

During the load tests the MS Outlook users noticed that the synchronization was taking several minutes and eventually never completed and timeout. The following Document New Column WEBDAV_UID Introduced In IP 2016 Causing Long Running Queries, Synchronization Takes Significantly Longer After Patch 3.10 (Doc ID 2439101.1)  but even after creating the recommended indexes the performance of the queries did not improve.

The same query below that is observed on Doc ID 2439101.1 is still taking up to 5 minutes to be executed for a single appointment:

The Oracle Database version been used is Oracle 19c and following parameter is been used:
OPTIMIZER_FEATURES_ENABLE='19.0.0.0'

After reviewing the Document Performance Tuning Guidelines for Siebel CRM Application on Oracle Database (Doc ID 2077227.2) > Oracle 12c and 19c > Oracle Database 19c Recommendations a change was made for the parameter OPTIMIZER_FEATURES_ENABLE='12.2.0.1.0'. Using this setting the performance of the query above changed to couple of seconds, but the change affected other queries on Siebel Application which were performing well with OPTIMIZER_FEATURES_ENABLE='19.0.0.0'.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.