Execution Time of Rules in Data Validation Manager (DVM) (Doc ID 2223947.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

Goal

On : 8.1.1.11.16 [IP2013] version, Client Functionality

Requirement: Performance analysis that identifies the execution time of every rule in the Data Validation Manager (DVM) Rule Sets

Process:

To analyze particular performance problems, the user examines log files to locate execution times of workflows, workflow steps, SQL statements, etc.
Problematic point is to analyze performance of Rule Sets that are validations for Orders.
There are 20 rules in the DVM Rule Set to validate Order.

After increasing the log level of all Events to 5, the log still does not capture information showing when Siebel started to validate specific rules.

Is there a way to identify execution time of each Rule in Data Validation Manager (DVM)?

Desired Behavior:

Users want to parse the log file and create a report  similar to below:

Start of "Order Validation" DVM
Rule # - Execution start - [Duration]
Rule 1# - 2016-12-27 13:00:00 [10s]
Rule 2# - 2016-12-27 13:00:10 [55s]
Rule 3# - 2016-12-27 13:01:05 [50s]
Rule 4# - 2016-12-27 13:01:35 [30s]
End of "Order Validation" DVM
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.