Kill processes in Unix/Linux while shutting down the database
                                                 Last update (2012-06-12 22:30:17)
                                                                                                                   Date added (2008-05-12 18:42:24)

Summary
When you shutdown the database with the immediate option you have to wait for all processes to terminate. Shutting down a database with 3000 sessions may take some time!

If the database SID for example is DWH01 then you can execute at the Unix shell this command to kill all the oracle sessions to speed up the procedure.
$ ps -ef|grep 'oracleDWH01 (LOCAL=NO)'|grep -v grep|awk '{print$2}'|xargs -i kill {}

OR

for i in `ps -ef|oracleDWH01 (LOCAL=NO)|grep -v  grep|awk '{print$2}'`
do
kill -9 $i
done
Tip: It doesn't kill the smon and pmon processes, only the LOCAL=NO

Other links
Kill idle E-Business Suite application users
Kill oracle idle session because of security reason
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search