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…

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