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

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…

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 had an unhandled exception. ORA-04030:…

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 ©