Note
- For V4.3.x, this parameter was introduced in V4.3.4.
- For V4.2.1, this parameter was introduced in V4.2.1 BP7. For V4.2.x other than V4.2.1, this parameter was introduced in V4.2.5.
Description
The json_document_max_depth parameter specifies the maximum number of nested levels allowed in a JSON document.
Privilege requirements
Query the parameter
The
systenant and all user tenants can execute theSHOW PARAMETERSstatement or view theGV$OB_PARAMETERSview to query this parameter.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
Attribute |
Description |
|---|---|
| Type | Int |
| Default value | 100 |
| Value range | [100, 1024] |
| Modifiable | Yes. You can execute the ALTER SYSTEM SET statement to modify this parameter. |
| Effective immediately | No. The setting takes effect immediately. |
Considerations
We recommend that you do not use a JSON data structure with too many nested levels. On the one hand, a deeply nested JSON data structure reduces readability and maintainability. On the other hand, parsing and serializing deeply nested JSON data usually consumes more time and computing resources, which reduces performance efficiency.
Example
Set the maximum number of nested levels allowed in a JSON document to 100.
obclient> ALTER SYSTEM SET json_document_max_depth=100;