(Vivek Sharma) There are various reasons that can cause a query to have multiple child cursors causing severe latch contention at the database level. One of these is optimizer_mismatch.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help