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 2.3.0.2.0 to 2.5.0.1.1 [Release 2.3 to 2.5]Information in this document applies to any platform.
Goal
On : 2.3.0.2.0 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*/)
Solution
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
| Goal |
| Solution |
| References |