My Oracle Support Banner

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

Last updated on JUNE 23, 2022

Applies to:

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


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?


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

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