My Oracle Support Banner

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 to [Release 2.3 to 2.5]
Oracle Utilities Network Management System - Version to [Release 2.3 to 2.5]
Information in this document applies to any platform.


On : 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.


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. 




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
 Fix Description

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