Improved performance in ECDA Option for Oracle

(ESD #3) In the ECDA Option for Oracle, set the rep_sparse_parse configuration parameter to 1 to allow SQL statements in Oracle syntax to pass from Replication Server clients directly to Oracle without being parsed by ECDA Option for Oracle. This improves performance since most of the SQL statements going to Oracle from Replication Server use Oracle syntax.

The default value for this parameter is 0, which means the ECDA Option for Oracle parses all SQL statements from Replication Server to Oracle.

This parameter is service-specific and dynamic and it applies only to Replication Server clients.

See the Enterprise Connect Data Access Option for Oracle 15.0 for Microsoft Windows, Linux, and UNIX Server Administration and Users Guide to set configuration parameters.