Managing Databases using Enterprise Manager (MOSC)

MOSC Banner

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center