My Oracle Support Banner

Slowness In D2-UTCD Job (Billing Job) (Doc ID 2973518.1)

Last updated on DECEMBER 19, 2023

Applies to:

Oracle Utilities Meter Data Management - Version to [Release 2.3 to 2.5]
Information in this document applies to any platform.


On : version, System Wide

Slowness in D2-UTCD job (Billing job)

Saw slowness in D2-UTCD job. As investigating with this, saw this top query in OEM while this job is running.

SQL ID: 9mmm7f28b3kxg – query (below) on alignment and delay rule doesn’t use the MSRMT_DTTM column which is the primary key of MSRMT table.

Query of SQL ID: 9mmm7f28b3kxg
select count(*) as col_0_0_ from D1_MSRMT measuremen0_ where (measuremen0_.MEASR_COMP_ID=:1 )AND(measuremen0_.MSRMT_USE_FLG<>:2 )AND(measuremen0_.MSRMT_LOCAL_DTTM>:3 )AND(measuremen0_.MSRMT_LOCAL_DTTM<=:4 /*com.splwg.d1.domain.admin.usageRule.applyUsageRule.AlignmentAndDelayAlgComp_Impl*/)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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