19.19
Hit a prod issue last week middle of the day, ORA-4031 memory errors. Any session trying to login got the 4031 including as sysdba on host. Turns out it was a bug, but root cause not important for this discussion.
Rather than shutdown the database which causes its own problems, we killed the pids of all LOCAL=NO sessions which frees up enough memory for us to get in to locate the offending culprit chewing the memory and kill that which worked for us.
Got me thinking afterwards, is there an order of preference of what processes you would kill to free up memory in such an event that wouldnt bring the database down?
For example Job processes? “j00n”.