My Oracle Support Banner

How To Enable QUERYTRACEON 9481 With MS SQL Server? (Doc ID 2393457.1)

Last updated on MAY 01, 2018

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Microsoft Windows x64 (64-bit)

Goal

Customer is encountering a performance issue for a query after the upgraded to SQL Server 2014. In the SQL Query window, when we use the "QUERYTRACEON" option along with Siebel's default "FAST 40" option, the query runs fine.

How to enable the additional OPTION (FAST 40, QUERYTRACEON 9481) in Siebel?
 

Solution

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
Goal
Solution


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