What is the signature mode of remote dependency?

What is the signature mode of remote dependency?

Rating:

The signature mode of remote dependency is one of the two remote dependency modes that are used by Oracle server to manage remote dependencies among objects. The REMOTE_DEPENDENCIES_MODE parameter must be set to SIGNATURE in order to specify the signature mode of remote dependency.

When the signature mode is used to manage remote dependencies, Oracle server records both the timestamp and the signature for each PL/SQL program unit. The signature of a PL/SQL program unit contains the following information:

The name of the program unit (the package, procedure, or function name)

The datatypes of each of the parameters of the subprogram

The modes of the parameters (IN, OUT, or IN OUT)

The number of parameters

The datatype of the return value for a function

The timestamp and signature of a remote procedure are stored in the remote procedure as well as in the local procedure that is dependent on the remote procedure. When the dependent local procedure is executed, the two signatures of the referenced remote procedure are compared. If the signatures match, the local procedure is executed successfully, no matter whether the timestamps match or not. In this way, the signature mode of remote dependency allows remote procedures to be recompiled without affecting the dependent local procedures. On the other hand, with the timestamp method, an error is raised if the timestamps do not match.

Using the signature mode alleviates some of the disadvantages with the timestamp remote dependency mode. A disadvantage of the timestamp mode is that it is unnecessarily restrictive. Recompilation of dependent objects across the network is often performed when it is not strictly necessary, thereby leading to performance deterioration.

Rating: