My Oracle Support Banner

Slow Performance with SQL Server And Increase In Invalid Cursor State Errors (Doc ID 2567976.1)

Last updated on JULY 25, 2019

Applies to:

Oracle Documaker - Version 12.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.6 version, Documaker Server

ACTUAL BEHAVIOR
---------------
Customer upgraded to IDS 2.9 and Studio 12.6. As part of this upgrade, they moved from Windows Server 2008 and SQL Server 2008 to Windows Server 2016 and SQL Server 2016. Using the SERVERTIMESPENT value from the send.msg, a number of transactions take over 10 seconds, and even the ones under 10 seconds are much higher than prior to the upgrade.  DBAs checked and they're seeing deadlocks. These deadlocks seem to correlate with the "Invalid Cursor State" errors - and that is based
on what is shown as the "victim" of the deadlock. 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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