电邮接到：XXX业务系统ip_xxx库需要停库，当然我们所想到的就是登进去执行一把shutdown immediate
当然我们得注意查看alert_sid.log，其中我发现
Wed Sep 19 11:23:36 GMT+08:00 2012Shutting down instance (immediate)
Wed Sep 19 11:23:36 GMT+08:00 2012Shutting down instance: further logons disabled
Wed Sep 19 11:23:39 GMT+08:00 2012Stopping background process CJQ0
Wed Sep 19 11:23:39 GMT+08:00 2012Stopping background process QMNC
Wed Sep 19 11:23:41 GMT+08:00 2012Stopping background process MMNL
Wed Sep 19 11:23:42 GMT+08:00 2012Stopping background process MMON
License high water mark = 1574
Wed Sep 19 11:23:43 GMT+08:00 2012Process OS id : 16319426 alive after kill
Errors in file /oracle/admin/jzjs/udump/jzjs_ora_18612510.trc
Wed Sep 19 11:23:47 GMT+08:00 2012Waiting for Job queue slaves to complete
Wed Sep 19 11:23:47 GMT+08:00 2012Job queue slave processes stopped
Wed Sep 19 11:28:47 GMT+08:00 2012Active call for process 12124640 user 'oracle' program 'oracle@jszwdb01'
Active call for process 15598262 user 'oracle' program 'oracle@jszwdb01'
Active call for process 10814508 user 'oracle' program 'oracle@jszwdb01'
System State dumped to trace file /oracle/admin/jzjs/udump/jzjs_ora_18612510.trc
Wed Sep 19 11:29:59 GMT+08:00 2012SHUTDOWN: waiting for active calls to complete.
Wed Sep 19 11:43:48 GMT+08:00 2012MMNL absent for 1254 secs; Foregrounds taking over
Wed Sep 19 12:25:04 GMT+08:00 2012SHUTDOWN: Active sessions prevent database close operation
Wed Sep 19 12:25:04 GMT+08:00 2012Instance shutdown cancelled
因为我没有通过kill当前的job，印象中Oracle shutdown，如果在30分钟还有一些job无法关闭的话，那么数据库将取消停库操作，那么我们看时间从11:23到12:25都一个小时了，那么我执行一下alter system checkpoint;然后在切一下日志alter system switch logfile;
那我现在将当前消耗数据库PGA占用内存进程找出来，然后kill掉，再进行停库操作。
jszwdb01 [/oracle/admin/jzjs/bdump]$ ps -ef |grep -i local
oracle 2359530 1 0 12:49:51 - 0:00 oraclejzjs (LOCAL=NO)
oracle 2621506 1 0 12:55:52 - 0:05 oraclejzjs (LOCAL=NO)
oracle 2818050 1 0 12:55:41 - 0:01 oraclejzjs (LOCAL=NO)
oracle 3408120 1 0 14:18:15 - 0:00 oraclejzjs (LOCAL=NO)
oracle 4522014 1 1 12:55:49 - 0:41 oraclejzjs (LOCAL=NO)
oracle 4587542 1 39 12:54:15 - 22:25 oraclejzjs (LOCAL=NO)
oracle 4784346 1 0 12:54:12 - 0:02 oraclejzjs (LOCAL=NO)
oracle 5505164 1 0 13:30:41 - 0:00 oraclejzjs (LOCAL=NO)
oracle 5636152 1 0 12:55:48 - 0:01 oraclejzjs (LOCAL=NO)
oracle 6160434 1 0 12:52:34 - 0:00 oraclejzjs (LOCAL=NO)
oracle 6553610 1 0 13:10:09 - 0:01 oraclejzjs (LOCAL=NO)
oracle 7274674 1 0 13:08:01 - 0:30 oraclejzjs (LOCAL=NO)
oracle 7340092 1 0 12:52:22 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7667964 1 0 12:53:31 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7798852 1 0 12:53:30 - 0:00 oraclejzjs (LOCAL=NO)
oracle 8192200 1 0 13:12:02 - 0:07 oraclejzjs (LOCAL=NO)
oracle 8585360 1 1 12:56:08 - 0:27 oraclejzjs (LOCAL=NO)
oracle 9764988 1 3 14:23:21 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9896124 1 0 13:54:22 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10420372 1 0 14:23:27 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10879002 1 11 14:23:31 - 0:01 oraclejzjs (LOCAL=NO)
oracle 11010194 1 0 14:02:04 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11927590 1 0 13:28:43 - 0:28 oraclejzjs (LOCAL=NO)
oracle 12124250 1 0 13:02:06 - 0:35 oraclejzjs (LOCAL=NO)
oracle 12320884 1 0 14:18:01 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12386336 1 29 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12517476 1 0 12:55:56 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12910716 1 7 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13041816 1 0 12:56:50 - 0:39 oraclejzjs (LOCAL=NO)
oracle 13238522 1 0 13:31:07 - 0:17 oraclejzjs (LOCAL=NO)
oracle 13303974 1 3 13:13:23 - 1:04 oraclejzjs (LOCAL=NO)
oracle 13566110 1 0 13:07:44 - 0:35 oraclejzjs (LOCAL=NO)
oracle 13959228 1 0 12:51:06 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14024728 1 0 12:55:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14155852 1 97 14:16:40 - 2:53 oraclejzjs (LOCAL=NO)
oracle 14221556 1 0 13:00:24 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14418054 1 0 13:31:23 - 0:21 oraclejzjs (LOCAL=NO)
oracle 14549176 1 0 13:57:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14811282 1 0 12:55:37 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15270086 1 0 12:55:32 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15532084 1 0 14:20:42 - 0:07 oraclejzjs (LOCAL=NO)
oracle 15663144 1 0 13:01:40 - 0:02 oraclejzjs (LOCAL=NO)
oracle 15859822 1 0 14:01:42 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15925496 1 0 12:50:01 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16056396 1 0 12:55:50 - 0:02 oraclejzjs (LOCAL=NO)
oracle 16121998 1 0 13:49:22 - 0:29 oraclejzjs (LOCAL=NO)
oracle 16253012 1 0 12:50:01 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16318596 1 0 13:51:01 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16580708 1 0 12:49:58 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16842948 1 0 13:52:31 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17236082 1 0 13:02:32 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18612376 1 1 13:31:42 - 0:36 oraclejzjs (LOCAL=NO)
oracle 18677794 1 7 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 19005604 1 0 13:25:50 - 0:23 oraclejzjs (LOCAL=NO)
oracle 19464402 1 0 14:01:43 - 0:00 oraclejzjs (LOCAL=NO)
oracle 19857510 1 1 13:13:08 - 0:18 oraclejzjs (LOCAL=NO)
oracle 20119740 1 0 14:04:56 - 0:00 oraclejzjs (LOCAL=NO)
oracle 20709514 1 0 12:58:15 - 0:22 oraclejzjs (LOCAL=NO)
oracle 20906072 1 95 14:17:23 - 2:52 oraclejzjs (LOCAL=NO)
oracle 22020242 1 0 13:18:26 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22085640 1 0 12:49:51 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22478916 1 1 12:49:47 - 0:37 oraclejzjs (LOCAL=NO)
oracle 22610034 1 0 14:23:32 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22872262 1 69 12:53:17 - 39:07 oraclejzjs (LOCAL=NO)
oracle 23068776 1 0 12:55:54 - 0:04 oraclejzjs (LOCAL=NO)
oracle 23199966 1 0 12:49:41 - 0:20 oraclejzjs (LOCAL=NO)
oracle 917976 1 0 14:01:34 - 0:00 oraclejzjs (LOCAL=NO)
oracle 1442208 1 0 12:49:50 - 0:00 oraclejzjs (LOCAL=NO)
oracle 6095158 1 0 13:46:18 - 0:00 oraclejzjs (LOCAL=NO)
oracle 6422908 1 0 14:19:13 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7602508 1 1 14:08:50 - 0:08 oraclejzjs (LOCAL=NO)
oracle 8519962 1 0 13:08:23 - 0:20 oraclejzjs (LOCAL=NO)
oracle 8651234 1 0 13:03:44 - 0:00 oraclejzjs (LOCAL=NO)
oracle 8716660 1 3 12:52:17 - 3:18 oraclejzjs (LOCAL=NO)
oracle 8847774 1 0 12:50:00 - 0:00 oraclejzjs (LOCAL=NO)
oracle 8978786 1 0 12:57:35 - 0:33 oraclejzjs (LOCAL=NO)
oracle 9175316 1 0 13:51:25 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9503056 1 0 14:23:36 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10027454 1 0 13:04:52 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10158502 1 0 12:53:42 - 0:39 oraclejzjs (LOCAL=NO)
oracle 11272598 1 0 12:53:20 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11665912 1 0 12:50:00 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11862278 1 0 12:50:10 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11927982 1 0 12:49:59 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12058910 1 0 12:49:59 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12517800 1 0 14:23:34 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12583308 1 0 12:49:58 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12648908 1 1 13:02:56 - 1:32 oraclejzjs (LOCAL=NO)
oracle 13369844 1 0 13:27:56 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13566380 1 6 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13894140 1 0 12:49:58 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14156284 1 0 12:49:58 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14680502 1 47 13:43:29 - 7:14 oraclejzjs (LOCAL=NO)
oracle 14811396 1 0 14:21:08 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14877006 1 0 12:55:58 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15008008 1 0 14:00:20 - 0:02 oraclejzjs (LOCAL=NO)
oracle 15270278 1 0 14:03:00 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15794680 1 1 13:13:58 - 0:52 oraclejzjs (LOCAL=NO)
oracle 15860070 1 0 12:56:03 - 0:26 oraclejzjs (LOCAL=NO)
oracle 16122238 1 0 13:03:18 - 0:25 oraclejzjs (LOCAL=NO)
oracle 16253400 1 0 13:29:39 - 0:18 oraclejzjs (LOCAL=NO)
oracle 16581018 1 1 13:26:05 - 0:34 oraclejzjs (LOCAL=NO)
oracle 17170826 1 1 14:15:27 - 0:05 oraclejzjs (LOCAL=NO)
oracle 17629678 1 0 12:49:51 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17760650 1 86 14:17:14 - 2:52 oraclejzjs (LOCAL=NO)
oracle 18809334 1 1 14:14:48 - 0:04 oraclejzjs (LOCAL=NO)
oracle 19202504 1 0 14:17:12 - 0:00 oraclejzjs (LOCAL=NO)
oracle 20447652 1 1 14:23:33 - 0:00 oraclejzjs (LOCAL=NO)
oracle 21561602 1 47 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 21758306 1 0 13:30:35 - 0:23 oraclejzjs (LOCAL=NO)
oracle 21889490 1 0 14:01:29 - 0:03 oraclejzjs (LOCAL=NO)
oracle 22151430 1 0 12:55:45 - 0:27 oraclejzjs (LOCAL=NO)
oracle 3998328 1 0 13:15:30 - 0:21 oraclejzjs (LOCAL=NO)
oracle 5636712 1 0 13:04:26 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7602710 1 0 13:30:06 - 0:16 oraclejzjs (LOCAL=NO)
oracle 8192690 1 0 13:16:47 - 0:08 oraclejzjs (LOCAL=NO)
oracle 8585886 1 0 13:13:19 - 0:00 oraclejzjs (LOCAL=NO)
oracle 8782554 1 0 13:05:13 - 0:55 oraclejzjs (LOCAL=NO)
oracle 10683096 1 3 13:25:36 - 1:44 oraclejzjs (LOCAL=NO)
oracle 11141712 1 26 12:58:23 - 12:32 oraclejzjs (LOCAL=NO)
oracle 11207346 1 0 14:03:10 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11797092 1 0 13:07:30 - 0:24 oraclejzjs (LOCAL=NO)
oracle 11993654 1 6 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12780254 1 0 13:25:11 - 0:31 oraclejzjs (LOCAL=NO)
oracle 13238902 1 0 12:55:48 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13304380 1 0 12:55:57 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13370014 1 1 12:58:44 - 0:53 oraclejzjs (LOCAL=NO)
oracle 13632174 1 1 14:12:23 - 0:07 oraclejzjs (LOCAL=NO)
oracle 13763246 1 0 12:59:01 - 0:24 oraclejzjs (LOCAL=NO)
oracle 13828792 1 0 12:52:26 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13959694 1 0 13:07:48 - 1:39 oraclejzjs (LOCAL=NO)
oracle 14025442 1 0 12:55:43 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14090920 1 0 13:31:24 - 0:51 oraclejzjs (LOCAL=NO)
oracle 14484032 1 0 13:04:56 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14811826 1 0 12:55:55 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14877436 1 6 12:58:20 - 5:01 oraclejzjs (LOCAL=NO)
oracle 15008436 1 0 13:27:05 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15204948 1 0 12:55:34 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15270516 1 0 13:59:05 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15336010 1 0 13:24:23 - 0:33 oraclejzjs (LOCAL=NO)
oracle 15598264 1 0 12:50:00 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15729278 1 0 13:47:23 - 9:27 oraclejzjs (LOCAL=NO)
oracle 16188094 1 0 12:53:21 - 0:32 oraclejzjs (LOCAL=NO)
oracle 16253658 1 5 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16450278 1 66 14:20:12 - 1:45 oraclejzjs (LOCAL=NO)
oracle 16777788 1 4 13:27:49 - 0:51 oraclejzjs (LOCAL=NO)
oracle 16843362 1 0 13:14:32 - 0:20 oraclejzjs (LOCAL=NO)
oracle 17039892 1 0 13:05:23 - 1:25 oraclejzjs (LOCAL=NO)
oracle 17236536 1 0 14:17:02 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17302236 1 0 14:22:50 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17367780 1 0 12:49:52 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17498634 1 0 12:57:39 - 0:41 oraclejzjs (LOCAL=NO)
oracle 17695316 1 0 12:56:34 - 0:25 oraclejzjs (LOCAL=NO)
oracle 17826334 1 68 14:23:07 - 0:15 oraclejzjs (LOCAL=NO)
oracle 17891988 1 4 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18088614 1 0 12:55:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18285114 1 53 14:17:32 - 2:47 oraclejzjs (LOCAL=NO)
oracle 19661312 1 2 13:28:14 - 0:52 oraclejzjs (LOCAL=NO)
oracle 20316706 1 0 13:08:09 - 0:19 oraclejzjs (LOCAL=NO)
oracle 20447762 1 0 13:33:52 - 1:03 oraclejzjs (LOCAL=NO)
oracle 20906518 1 0 14:22:54 - 0:00 oraclejzjs (LOCAL=NO)
oracle 21758672 1 0 12:56:51 - 0:03 oraclejzjs (LOCAL=NO)
oracle 22020860 1 2 14:23:37 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22086256 1 4 14:23:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22282898 1 0 13:33:26 - 0:15 oraclejzjs (LOCAL=NO)
oracle 1377246 1 0 12:49:45 - 0:02 oraclejzjs (LOCAL=NO)
oracle 1967068 1 1 13:05:32 - 0:50 oraclejzjs (LOCAL=NO)
oracle 5243842 1 0 14:01:58 - 0:05 oraclejzjs (LOCAL=NO)
oracle 5374940 1 0 13:37:15 - 0:00 oraclejzjs (LOCAL=NO)
oracle 5833578 1 0 12:55:51 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9634708 1 0 12:52:29 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9896714 1 0 12:53:24 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10289930 1 0 12:55:52 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10421016 1 0 13:22:42 - 0:24 oraclejzjs (LOCAL=NO)
oracle 10814348 1 0 12:58:25 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10945522 1 0 12:55:30 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11076380 1 0 14:03:37 - 0:02 oraclejzjs (LOCAL=NO)
oracle 11273050 1 0 13:24:55 - 0:26 oraclejzjs (LOCAL=NO)
oracle 11797390 1 0 12:55:52 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12256042 1 0 12:50:44 - 0:06 oraclejzjs (LOCAL=NO)
oracle 12387306 1 0 12:50:41 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13173522 1 0 12:50:11 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13370248 1 75 14:23:26 - 0:06 oraclejzjs (LOCAL=NO)
oracle 13566852 1 0 12:50:10 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13960080 1 0 13:39:12 - 0:01 oraclejzjs (LOCAL=NO)
oracle 14549936 1 0 12:50:00 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14746496 1 7 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14942986 1 0 13:08:14 - 0:43 oraclejzjs (LOCAL=NO)
oracle 15074264 1 0 12:49:59 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15336328 1 0 13:22:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15860600 1 0 12:49:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15926230 1 0 12:49:51 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17171300 1 0 14:03:18 - 0:02 oraclejzjs (LOCAL=NO)
oracle 17761182 1 0 12:55:37 - 0:03 oraclejzjs (LOCAL=NO)
oracle 18285448 1 0 13:18:07 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18940738 1 4 14:23:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 20251420 1 0 14:02:01 - 0:00 oraclejzjs (LOCAL=NO)
oracle 20513678 1 0 14:14:56 - 0:03 oraclejzjs (LOCAL=NO)
oracle 21168936 1 0 12:50:10 - 0:00 oraclejzjs (LOCAL=NO)
oracle 21365544 1 0 12:49:46 - 0:01 oraclejzjs (LOCAL=NO)
oracle 21758828 1 0 12:49:45 - 0:07 oraclejzjs (LOCAL=NO)
oracle 21824482 1 0 13:29:46 - 0:51 oraclejzjs (LOCAL=NO)
oracle 2425972 1 0 12:49:52 - 0:00 oraclejzjs (LOCAL=NO)
oracle 2622700 1 0 12:53:00 - 0:03 oraclejzjs (LOCAL=NO)
oracle 2688186 1 0 12:49:52 - 0:00 oraclejzjs (LOCAL=NO)
oracle 3146914 1 0 13:01:59 - 0:01 oraclejzjs (LOCAL=NO)
oracle 3605600 1 0 12:52:29 - 0:01 oraclejzjs (LOCAL=NO)
oracle 4654334 1 4 12:59:01 - 0:22 oraclejzjs (LOCAL=NO)
oracle 5113002 1 0 12:53:35 - 0:00 oraclejzjs (LOCAL=NO)
oracle 5964856 1 1 13:06:09 - 0:32 oraclejzjs (LOCAL=NO)
oracle 7406706 1 0 14:03:10 - 0:03 oraclejzjs (LOCAL=NO)
oracle 7472158 1 0 13:59:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7930984 1 1 13:31:00 - 0:23 oraclejzjs (LOCAL=NO)
oracle 8258664 1 0 12:50:51 - 0:00 oraclejzjs (LOCAL=NO)
oracle 8455190 1 0 13:13:10 - 0:07 oraclejzjs (LOCAL=NO)
oracle 9045180 1 0 12:55:44 - 0:03 oraclejzjs (LOCAL=NO)
oracle 9569362 1 4 14:23:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9634938 1 0 12:50:01 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10814516 1 0 12:50:00 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11535534 1 102 14:14:55 - 4:38 oraclejzjs (LOCAL=NO)
oracle 11666478 1 11 12:57:34 - 4:37 oraclejzjs (LOCAL=NO)
oracle 12452996 1 0 12:55:40 - 0:04 oraclejzjs (LOCAL=NO)
oracle 12715186 1 0 14:08:09 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12846178 1 95 14:23:29 - 0:05 oraclejzjs (LOCAL=NO)
oracle 14025978 1 0 12:49:46 - 0:01 oraclejzjs (LOCAL=NO)
oracle 14353592 1 0 13:16:47 - 0:08 oraclejzjs (LOCAL=NO)
oracle 14877868 1 10 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15008866 1 0 12:49:50 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15140088 1 2 14:08:44 - 0:10 oraclejzjs (LOCAL=NO)
oracle 15402196 1 0 12:55:33 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15533198 1 3 14:17:14 - 0:04 oraclejzjs (LOCAL=NO)
oracle 15598714 1 0 13:26:49 - 0:01 oraclejzjs (LOCAL=NO)
oracle 15729710 1 0 13:38:38 - 0:09 oraclejzjs (LOCAL=NO)
oracle 15795346 1 7 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15860892 1 0 12:49:52 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15926474 1 1 14:12:48 - 0:03 oraclejzjs (LOCAL=NO)
oracle 15992020 1 0 13:28:42 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16516294 1 1 12:58:29 - 1:03 oraclejzjs (LOCAL=NO)
oracle 16647344 1 0 14:16:15 - 0:03 oraclejzjs (LOCAL=NO)
oracle 16778422 1 0 12:49:50 - 0:07 oraclejzjs (LOCAL=NO)
oracle 16843900 1 3 14:15:57 - 0:06 oraclejzjs (LOCAL=NO)
oracle 17499230 1 0 14:13:29 - 0:11 oraclejzjs (LOCAL=NO)
oracle 17827060 1 0 13:13:40 - 0:28 oraclejzjs (LOCAL=NO)
oracle 17892386 1 0 13:58:47 - 0:07 oraclejzjs (LOCAL=NO)
oracle 18154652 1 0 12:55:38 - 0:04 oraclejzjs (LOCAL=NO)
oracle 19137596 1 0 12:55:42 - 0:11 oraclejzjs (LOCAL=NO)
oracle 19203072 1 0 13:36:50 - 0:00 oraclejzjs (LOCAL=NO)
oracle 19334378 1 11 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 19465312 1 6 14:23:37 - 0:00 oraclejzjs (LOCAL=NO)
oracle 19596292 1 7 14:23:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 19924070 1 1 14:09:07 - 0:05 oraclejzjs (LOCAL=NO)
oracle 20186186 1 0 12:49:50 - 0:00 oraclejzjs (LOCAL=NO)
oracle 20448458 1 10 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 20645062 1 0 13:22:29 - 0:22 oraclejzjs (LOCAL=NO)
oracle 20841548 1 0 13:58:47 - 0:00 oraclejzjs (LOCAL=NO)
oracle 21103626 1 42 12:54:06 - 22:05 oraclejzjs (LOCAL=NO)
oracle 21169192 1 0 13:36:03 - 0:00 oraclejzjs (LOCAL=NO)
oracle 2557284 1 0 13:07:04 - 0:22 oraclejzjs (LOCAL=NO)
oracle 2753930 1 0 12:58:34 - 0:41 oraclejzjs (LOCAL=NO)
oracle 3278160 1 0 12:59:51 - 0:45 oraclejzjs (LOCAL=NO)
oracle 3605806 1 0 12:55:42 - 0:00 oraclejzjs (LOCAL=NO)
oracle 3671454 1 1 12:54:18 - 0:25 oraclejzjs (LOCAL=NO)
oracle 3933596 1 0 12:50:11 - 0:00 oraclejzjs (LOCAL=NO)
oracle 5375244 1 0 12:50:10 - 0:00 oraclejzjs (LOCAL=NO)
oracle 5703084 1 0 13:36:27 - 0:00 oraclejzjs (LOCAL=NO)
oracle 6161694 1 0 14:14:41 - 0:08 oraclejzjs (LOCAL=NO)
oracle 6358272 1 5 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 6882724 1 0 13:09:32 - 0:03 oraclejzjs (LOCAL=NO)
oracle 7210386 1 0 12:50:01 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7275884 1 14 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7341550 1 19 12:58:43 - 11:40 oraclejzjs (LOCAL=NO)
oracle 7669148 1 6 13:13:05 - 2:45 oraclejzjs (LOCAL=NO)
oracle 7996754 1 1 13:14:17 - 0:53 oraclejzjs (LOCAL=NO)
oracle 8390132 1 2 12:57:24 - 1:28 oraclejzjs (LOCAL=NO)
oracle 8848704 1 0 12:50:10 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9504020 1 0 12:49:54 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9700674 1 0 13:11:09 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9831688 1 0 12:49:52 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10356088 1 0 12:57:41 - 0:22 oraclejzjs (LOCAL=NO)
oracle 10421594 1 6 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10487042 1 0 12:55:55 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10618264 1 2 13:32:32 - 1:11 oraclejzjs (LOCAL=NO)
oracle 10683832 1 5 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11535798 1 5 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11601244 1 0 14:10:28 - 0:00 oraclejzjs (LOCAL=NO)
oracle 11666926 1 0 13:24:38 - 0:28 oraclejzjs (LOCAL=NO)
oracle 11732394 1 0 13:04:07 - 0:22 oraclejzjs (LOCAL=NO)
oracle 12387764 1 0 13:40:29 - 0:22 oraclejzjs (LOCAL=NO)
oracle 12649840 1 6 14:23:36 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12912070 1 0 12:49:51 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13174182 1 0 13:41:26 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13894936 1 0 13:26:06 - 0:30 oraclejzjs (LOCAL=NO)
oracle 13960472 1 0 12:54:43 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14091716 1 36 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14550452 1 0 13:33:28 - 0:02 oraclejzjs (LOCAL=NO)
oracle 14616032 1 0 14:01:43 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14943726 1 0 14:08:59 - 0:02 oraclejzjs (LOCAL=NO)
oracle 15074782 1 0 12:53:23 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15598906 1 0 13:11:05 - 0:52 oraclejzjs (LOCAL=NO)
oracle 15664442 1 1 12:57:16 - 0:54 oraclejzjs (LOCAL=NO)
oracle 15730102 1 0 12:56:48 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15795470 1 0 12:55:36 - 0:03 oraclejzjs (LOCAL=NO)
oracle 15926610 1 0 12:59:15 - 0:25 oraclejzjs (LOCAL=NO)
oracle 16975272 1 0 13:16:52 - 0:07 oraclejzjs (LOCAL=NO)
oracle 17564980 1 0 12:54:09 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17630614 1 2 14:23:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18089320 1 0 13:03:49 - 0:22 oraclejzjs (LOCAL=NO)
oracle 19531016 1 0 12:53:06 - 0:00 oraclejzjs (LOCAL=NO)
oracle 19596608 1 0 13:05:06 - 0:29 oraclejzjs (LOCAL=NO)
oracle 20645320 1 0 13:13:19 - 0:00 oraclejzjs (LOCAL=NO)
oracle 21628372 1 0 12:49:58 - 0:00 oraclejzjs (LOCAL=NO)
oracle 21693870 1 0 14:05:26 - 0:00 oraclejzjs (LOCAL=NO)
oracle 21955860 1 0 14:23:19 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22742306 1 0 14:23:16 - 0:00 oraclejzjs (LOCAL=NO)
oracle 1115746 1 0 12:49:45 - 0:03 oraclejzjs (LOCAL=NO)
oracle 1574450 1 0 12:49:45 - 0:02 oraclejzjs (LOCAL=NO)
oracle 2492060 1 1 13:25:22 - 1:03 oraclejzjs (LOCAL=NO)
oracle 4064892 1 1 13:23:04 - 0:24 oraclejzjs (LOCAL=NO)
oracle 4851402 1 0 13:55:38 - 0:02 oraclejzjs (LOCAL=NO)
oracle 5047810 1 1 13:25:05 - 0:33 oraclejzjs (LOCAL=NO)
oracle 5441130 1 8 14:23:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 5768728 1 7 14:23:34 - 0:00 oraclejzjs (LOCAL=NO)
oracle 6161954 1 0 12:58:28 - 0:40 oraclejzjs (LOCAL=NO)
oracle 7472762 1 0 12:51:09 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7538424 1 0 12:52:19 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7603886 1 0 14:15:26 - 0:00 oraclejzjs (LOCAL=NO)
oracle 8259248 1 0 13:54:47 - 0:21 oraclejzjs (LOCAL=NO)
oracle 9242232 1 0 12:50:10 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10487470 1 1 13:31:32 - 0:59 oraclejzjs (LOCAL=NO)
oracle 10815202 1 0 12:50:10 - 0:00 oraclejzjs (LOCAL=NO)
oracle 10946210 1 0 13:29:10 - 0:22 oraclejzjs (LOCAL=NO)
oracle 11667184 22544888 0 14:23:40 pts/5 0:00 grep -i local
oracle 11732532 1 3 12:56:33 - 1:40 oraclejzjs (LOCAL=NO)
oracle 12387904 1 0 13:25:04 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12781240 1 0 13:31:16 - 0:29 oraclejzjs (LOCAL=NO)
oracle 13043354 1 0 13:14:17 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13108862 1 0 12:55:33 - 0:11 oraclejzjs (LOCAL=NO)
oracle 13436648 1 5 14:23:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13698622 1 0 14:17:09 - 0:01 oraclejzjs (LOCAL=NO)
oracle 13764224 1 2 12:56:54 - 0:53 oraclejzjs (LOCAL=NO)
oracle 14091936 1 1 13:08:19 - 0:29 oraclejzjs (LOCAL=NO)
oracle 14288526 1 0 13:31:08 - 0:00 oraclejzjs (LOCAL=NO)
oracle 14353948 1 0 14:09:08 - 0:06 oraclejzjs (LOCAL=NO)
oracle 14681764 1 0 13:22:54 - 0:29 oraclejzjs (LOCAL=NO)
oracle 15009494 1 1 13:26:21 - 0:30 oraclejzjs (LOCAL=NO)
oracle 15402618 1 0 13:04:31 - 0:22 oraclejzjs (LOCAL=NO)
oracle 15664726 1 77 14:19:22 - 2:13 oraclejzjs (LOCAL=NO)
oracle 15992416 1 6 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16057886 1 0 12:55:47 - 0:02 oraclejzjs (LOCAL=NO)
oracle 16189088 1 5 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16254488 1 0 13:02:19 - 0:08 oraclejzjs (LOCAL=NO)
oracle 16582302 1 1 13:14:15 - 0:32 oraclejzjs (LOCAL=NO)
oracle 16844400 1 0 12:49:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16909936 1 0 13:09:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17106578 1 51 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17303166 1 0 12:54:06 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17696430 1 0 12:49:45 - 0:26 oraclejzjs (LOCAL=NO)
oracle 18417214 1 0 13:51:06 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18482830 1 0 12:55:42 - 0:00 oraclejzjs (LOCAL=NO)
oracle 20383336 1 0 13:23:46 - 0:03 oraclejzjs (LOCAL=NO)
oracle 20842086 1 0 13:13:58 - 0:08 oraclejzjs (LOCAL=NO)
oracle 22087390 1 0 12:49:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22152904 1 0 13:58:00 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22808296 1 1 14:12:28 - 0:03 oraclejzjs (LOCAL=NO)
oracle 23135922 1 0 14:23:12 - 0:00 oraclejzjs (LOCAL=NO)
oracle 23660176 1 0 12:55:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 24512052 1 15 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 24708790 1 0 13:59:03 - 0:00 oraclejzjs (LOCAL=NO)
oracle 24970774 1 0 12:53:34 - 0:00 oraclejzjs (LOCAL=NO)
oracle 25036310 1 0 12:55:43 - 0:02 oraclejzjs (LOCAL=NO)
oracle 1181524 1 0 12:55:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 1443646 1 0 12:56:28 - 0:01 oraclejzjs (LOCAL=NO)
oracle 2164624 1 0 12:49:41 - 0:00 oraclejzjs (LOCAL=NO)
oracle 2623484 1 0 12:58:36 - 0:07 oraclejzjs (LOCAL=NO)
oracle 2754492 1 9 14:23:40 - 0:00 oraclejzjs (LOCAL=NO)
oracle 6162184 1 103 14:21:42 - 0:55 oraclejzjs (LOCAL=NO)
oracle 6948810 1 0 13:05:04 - 0:00 oraclejzjs (LOCAL=NO)
oracle 7079886 1 0 12:58:50 - 0:32 oraclejzjs (LOCAL=NO)
oracle 8456008 1 0 14:06:14 - 0:50 oraclejzjs (LOCAL=NO)
oracle 8521682 1 1 13:13:44 - 0:27 oraclejzjs (LOCAL=NO)
oracle 8980302 1 14 12:56:23 - 7:07 oraclejzjs (LOCAL=NO)
oracle 9176852 1 0 12:55:58 - 0:00 oraclejzjs (LOCAL=NO)
oracle 9766876 1 1 12:55:33 - 0:44 oraclejzjs (LOCAL=NO)
oracle 10356538 1 1 12:57:33 - 0:55 oraclejzjs (LOCAL=NO)
oracle 10880970 1 0 12:55:44 - 0:07 oraclejzjs (LOCAL=NO)
oracle 11274020 1 0 12:49:45 - 0:02 oraclejzjs (LOCAL=NO)
oracle 11863814 1 63 12:53:56 - 30:06 oraclejzjs (LOCAL=NO)
oracle 12126154 1 0 12:53:18 - 0:00 oraclejzjs (LOCAL=NO)
oracle 12847016 1 0 12:55:56 - 0:04 oraclejzjs (LOCAL=NO)
oracle 12978156 1 0 12:55:54 - 0:00 oraclejzjs (LOCAL=NO)
oracle 13174714 1 0 14:18:21 - 0:02 oraclejzjs (LOCAL=NO)
oracle 13240272 1 12 12:56:57 - 5:57 oraclejzjs (LOCAL=NO)
oracle 13502460 1 0 13:07:02 - 0:10 oraclejzjs (LOCAL=NO)
oracle 14223180 1 0 14:15:31 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15271788 1 0 14:15:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15533932 1 0 12:50:01 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15730652 1 0 13:11:41 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15796104 1 0 12:49:59 - 0:00 oraclejzjs (LOCAL=NO)
oracle 15992650 17629206 0 13:28:08 - 0:07 oraclejzjs (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 16058190 1 0 12:49:59 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16254732 1 0 13:13:19 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16582400 1 0 13:20:51 - 0:00 oraclejzjs (LOCAL=NO)
oracle 16713614 1 0 12:59:08 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17565444 1 10 14:23:39 - 0:00 oraclejzjs (LOCAL=NO)
oracle 17631192 1 89 14:17:01 - 2:54 oraclejzjs (LOCAL=NO)
oracle 18351990 1 0 13:12:11 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18417450 1 0 12:56:05 - 0:01 oraclejzjs (LOCAL=NO)
oracle 18483052 1 9 14:23:38 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18548550 1 6 12:56:41 - 6:51 oraclejzjs (LOCAL=NO)
oracle 18679652 1 0 13:38:48 - 0:00 oraclejzjs (LOCAL=NO)
oracle 18810782 1 0 12:54:51 - 0:57 oraclejzjs (LOCAL=NO)
oracle 20842362 1 0 12:49:53 - 0:10 oraclejzjs (LOCAL=NO)
oracle 21890884 1 0 12:49:53 - 0:00 oraclejzjs (LOCAL=NO)
oracle 22087450 1 5 14:23:37 - 0:00 oraclejzjs (LOCAL=NO)
这样你找到了pid后，可以通过kill -9 pid进行杀掉（之前查询结果没有保存，所以时间可能无法对应，但是方法就是这样），再通过shutdown immediate进行停库操做，我们继续关注alert日志，
Wed Sep 19 12:43:13 GMT+08:00 2012Shutting down instance (immediate)
Wed Sep 19 12:43:13 GMT+08:00 2012Shutting down instance: further logons disabled
License high water mark = 1574
Wed Sep 19 12:48:14 GMT+08:00 2012Active call for process 12124640 user 'oracle' program 'oracle@jszwdb01'
Active call for process 15598262 user 'oracle' program 'oracle@jszwdb01'
Active call for process 10814508 user 'oracle' program 'oracle@jszwdb01'
System State dumped to trace file /oracle/admin/jzjs/udump/jzjs_ora_11274002.trc
SHUTDOWN: waiting for active calls to complete.
All dispatchers and shared servers shutdown
Wed Sep 19 12:48:24 GMT+08:00 2012ALTER DATABASE CLOSE NORMAL
Wed Sep 19 12:48:24 GMT+08:00 2012SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Sep 19 12:48:24 GMT+08:00 2012Block change tracking service stopping.
Wed Sep 19 12:48:24 GMT+08:00 2012Stopping background process CTWR
Wed Sep 19 12:48:28 GMT+08:00 2012Shutting down archive processes
Archiving is disabled
Wed Sep 19 12:48:33 GMT+08:00 2012ARCH shutting down
ARC1: Archival stopped
Wed Sep 19 12:48:38 GMT+08:00 2012ARCH shutting down
ARC0: Archival stopped
Wed Sep 19 12:48:39 GMT+08:00 2012Thread 1 closed at log sequence 144393
Successful close of redo thread 1
Wed Sep 19 12:48:54 GMT+08:00 2012Completed: ALTER DATABASE CLOSE NORMAL
Wed Sep 19 12:48:54 GMT+08:00 2012ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
停库结束。当然我们可以通过查询当前库中正在存活的任务，然后杀掉在停库。
select sid,serial# from v$session;
alter system kill session 'sid, serial#';
shutdown immediate;
本文转自yangjunfeng 51CTO博客，原文链接:http://blog.51cto.com/yangjunfeng/998561
