package_state_sync_max_size

Description

The package_state_sync_max_size parameter specifies the maximum length of a package state (package state management) that can be serialized.

Privilege requirements

• Query the parameter

  The sys tenant and all user tenants can use the SHOW PARAMETERS statement or the GV$OB_PARAMETERS view to query the parameter.

• Modify the parameter

  The sys tenant and user tenants can modify the parameter.

Attributes

Considerations

• The package_state_sync_max_size parameter specifies the maximum length of a package state (package state management) that can be serialized. In an ODP deployment scenario, if the length of a package state variable that needs to be synchronized exceeds the specified value, ODP synchronizes a special value to ensure that the original node continues to execute the subsequent statements.

• In a distributed plan scenario, if a remote node constructs a package state and receives a specific value, an error is returned. This error occurs when an SQL statement contains a user-defined function (UDF) or a trigger and explicitly specifies the parallel_enable clause. To resolve this issue, you can remove the parallel_enable clause or increase the value of the package_state_sync_max_size parameter.

Examples

Set the maximum length of a package state (package state management) that can be serialized to 8193.

obclient> ALTER SYSTEM SET package_state_sync_max_size=8193;