By using our website, you agree to the use of our cookies.
By using our website, you agree to the use of our cookies.

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 Mixed Mode Auditing is enabled…

THE FAILED LOGINS METRIC QUERY IS VERY SLOW BECAUSE OF AUD$ TABLE SIZE

  SYMPTOMS The Oracle Enterprise Manage Cloud Control 13c is used to monitor the Oracle database. The Failed Logins Metric is enabled and by default executed every 30 minutes. The related metric queries with SQL_ID 83jcj6at6ugq3 (12c) and 1c74605ddbvjt (11gR2) are very slow and causes high IO in the monitored…

HOW TO TERMINATE ALL IDLE SESSIONS/PROCESSES IN AN ORACLE DATABASE AUTOMATICALLY

GOAL There are lots of idle sessions/processes in my database. All inactive(Idle) sessions must be disconnected automatically after 8 hours since they have become inactive(idle). SYMPTOMS The following statement shows IDLE time for all INACTIVE sessions in a database SET LINES 300 SET PAGES 999 COL DATABASE_USER FOR A20 COL…

EM Event: Warning:ORCL_dbpilot.net – Metrics Process Limit % is at 98

  SYMPTOMS Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0.0) sends you emails like the EM Event: Warning:ORCL_dbpilot.net – Metrics Process Limit % is at 98 with the following error messages Host=dbpilot.net Target type=Database Instance Target name=ORCL_dbpilot.net Categories=Capacity Message=Metrics Process Limit % is at 98 Severity=Warning Event reported time=Aug…

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. The body of the query…

WordPress Theme built by Shufflehound. dbpilot.net by Victor Khalturin ©