Analyzing Performance of Publications With the Consperf Utility
(Doc ID 1901221.1)
Last updated on MAY 15, 2018
Applies to:Oracle Database Mobile Server - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 11.1 to 11.3]
Information in this document applies to any platform.
The Consperf utility profiles your subscriptions and may modify how the publication item is executed if the utility determines that there is a more performant option. The Consperf tool evaluates how the SQL within the publication item interacts with our Data Synchronization query templates. The first synchronization is always a complete refresh, which is a direct invocation of the query. On subsequent synchronizations, the query templates determine incremental refreshes. This improves your performance from not having to perform a complete refresh each time you synchronize. However, the interaction of our query templates and your SQL may not be optimal, which is discovered by the Consperf tool. We either modify the query template or type of logical delete or insert for you or you can adjust your SQL to be more performant in regards to our templates.
In addition, application developers and administrators use this utility to analyze the performance of subscriptions and identify potential bottlenecks during synchronization.
This tool generates the following two primary analysis reports:
Timing statistics for publication items
Explain plans for publications
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!