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…

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