Category: High IO Load

THE FAILED LOGINS AND THE FAILED LOGINS (HISTORICAL) METRICS ARE EXTREMELY SLOW RESULTING IN HIGH IO AND CPU CONSUMPTION

  SYMPTOMS The Oracle Enterprise Manager Cloud Control 13c Release 3 and The Oracle Management Agent 13c release 3 are used to monitor the Oracle database 12.1.0.1.0. Both The Failed Logins and Failed Logins (Historical) Metric are enabled and execute on a regular base. The…

STANDARD EM QUERY WITH SQL_ID dx4nqvbtu06bx IS VERY SLOW AND USES LOTS OF TEMPORARY SPACE

  ISSUE The standard recurring query of the Enterprise Manager Cloud Control 13c Release 3 with sql_id dx4nqvbtu06bx is running slow and using huge amount of temporary tablespace while executing in a databases of the release 11.2.0.4. The query dx4nqvbtu06bx is executed every 15-20 minutes….

Oracle Blog at dbpilot.net, Victor Khalturin