ORA-01555 triggered from OEM queries
Hi All,
DB Alert logs is always flooded from the following error message with query duration is 0 seconds. It seems to be triggered from OEM. Any suggestion to fix this ?
Enterprise Manager Cloud Control 13c Release 4
Oracle Database 12.2.0.1
2023-12-05T10:00:19.028313+08:00
ORA-01555 caused by SQL statement below (SQL ID: acdn4nsq1w3gs, Query Duration=0 sec, SCN:
0x0000008770d642e7
):
2023-12-05T10:00:19.028430+08:00
WITH unified_ash AS (
SELECT /*+ NO_MERGE */ *
FROM TABLE(GV$(CURSOR(
SELECT TRUNC(:"SYS_B_000"*((CAST(a.sample_time_utc AS DATE))-TO_DATE(:"SYS_B_001",:"SYS_B_002") )) as t,
TRUNC(:"SYS_B_003"*((CAST(a.sample_time_utc AS DATE))-TO_DATE(:"SYS_B_004",:"SYS_B_005") ) / :"SYS_B_006" )+:"SYS_B_007" as bucket_number,