Delay/Latency In FLISR Switch Sheet Creation
(Doc ID 2905332.1)
Last updated on OCTOBER 31, 2022
Applies to:
Oracle Network Management for Utilities - DMS - Version 2.3.0.2.0 to 2.5.0.2.0 [Release 2.3 to 2.5]Oracle Utilities Network Management System - Version 2.3.0.2.0 to 2.5.0.2.0 [Release 2.3 to 2.5]
Information in this document applies to any platform.
Symptoms
On : 2.3.0.2.0 version, Web DMS
Seeing a delay/latency in FLISR Switch Sheet Creation
We are experiencing an issue on their where it consistently takes ~25 seconds for the FLISR Switch Sheet to generate.
- Ran a test by creating a FLISR switching plan
- Ran the command Action any.TCDBService dump
- Reviewed the "sql command history" in the TCDBService log and identified a query that is consistently taking the about the time reported to generate the plan
Example
09/22/22 14:29:16: TCDBService 0x506,ctp=11033c948,"DBService::query" SQL
TIMING 23275 ms, rows=1, sql=[sql command: 'select step.step_idx,
js.event_idx, js.assoc_id from swman_step step inner join job_steps js on
step.step_idx = js.step_idx left outer join swman_sheet sheet on
step.seq_sheet_id = sheet.seq_sheet_id where sheet.switch_sheet_cls=:cls and
sheet.switch_sheet_idx=:idx and step.act_key > 2 and js.event_idx in (SELECT
ncg FROM temp_ncgs)' from (1/41:15139314.0):112 at Sep 22 14:28:52
dbrdwr=11141516 returned: 1 after 23275 ms]
The AWR report shows a SQL execution elapsed time closely matching the ~24 seconds of timing (SQL ordered by Elapsed Time table, row 3, elapsed time showing 23.37(s) which also confirms where the FLISR plan generation time is being spent.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
Fix Description |
Migration |
References |