Home

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…

ORA-31671: Worker process DW00 had an unhandled exception.

  ISSUE During a datapump import you got the error like the following impdp system/password schemas=XXCDB NETWORK_LINK=PROD_SYSTEM DIRECTORY=DROPZONE LOGFILE=your_logfile.log … Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS ORA-39014: One or more workers have prematurely exited. ORA-39029: worker 1 with process name “DW00” prematurely terminated ORA-31671: Worker process DW00…

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….

WordPress Theme built by Shufflehound. DBPILOT, Victor Khalturin