My Oracle Support Banner

Further Information Required On MaxDepthOfTheQuery Enterprise Parameter (Doc ID 1913170.1)

Last updated on APRIL 01, 2019

Applies to:

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


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? 



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.