package_state_sync_max_size

Description

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

Privilege requirements

• Query the parameter

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

• Modify the parameter

  The sys tenant and user tenants can modify this parameter.

Attributes

Considerations

• This parameter specifies the maximum length of a single package state that can be serialized. In an ODP deployment scenario, if the length of a package variable that needs to be synchronized exceeds the specified value, the OBServer node will synchronize a special value to ensure that ODP continues to route subsequent statements to the original node for execution.

• In distributed plan scenarios, when a remote node constructs a package state, an error is returned if a specific value is received. This error scenario occurs when an SQL statement contains a UDF (user-defined function) or a trigger and explicitly specifies the parallel_enable clause. In this case, 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 single package state (package state management) to 8193.

obclient> ALTER SYSTEM SET package_state_sync_max_size=8193;