Further Information Required On MaxDepthOfTheQuery Enterprise Parameter

(Doc ID 1913170.1)

Last updated on SEPTEMBER 22, 2017

Applies to:

Siebel CRM - Version 8.1.1.11 SIA [23030] and later
Information in this document applies to any platform.

Goal

Regarding MaxDepthOfTheQuery parameter:

a) Which units the parameter value refers to (We are assuming Bytes based on the suggested values of 1024 and 2048 in Bookshelf)
b) What is the maximum number this value can be set to?
c) What are the negative impacts of setting this value on the enterprise level?
d) What are the risks of changing this parameter from the default value of 500?
e) In terms of impacts of increasing this parameter, should we expect resource usage to increase? For example, is more RAM going to be used? Or more CPU?
f) Could you provide an example of what excessive number of OR clauses? Would 1000 OR clauses be considered an excessive number?
g) Should be change the value to 4096, would it be supported without any impact on performance or resource usage? 

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms