An OS process and DB session which won’t die: a systematic troubleshooting approach

This week, I lent a hand to a friend who had a session stuck in the database. By the time he got in touch, he’d already terminated the session in both the database and the Operating System. He mentioned that neither the database session nor the OS process had actually died. The database session was[…]