Oracle helpful commands

to check database running mode

select open_mode from v$database;

Identify Dead User Processes

ps -ef | grep LOCAL | grep oracle$ORACLE_SID

List Dead User Process ID

ps -ef | grep LOCAL | grep oracle$ORACLE_SID | awk '{print $2}'

Kill De...