???????????????ο????????????????????????????????????????????????????????????????????JOB???????????????????????????????????????NORMAL??????????????????
????????????1????????????????????????й?????????????????????????????????????????????kill?????????????????????????????????????????
????????????????ι?????????MOS???????￡?
????http://blog.csdn.net/haibusuanyun/article/details/50285527
????????????????SHUTDOWN: Active processes prevent shutdown operation
????http://blog.csdn.net/haibusuanyun/article/details/47073459
?????????????SHUTDOWN: waiting for active calls to complete.????
???????ο?MOS?????
????Shutdown Immediate Hangs / Active Processes Prevent Shutdown (??? ID 416658.1)
????Alert Log: Shutdown Waiting for Active Calls to Complete (??? ID 1039389.6)
????What Is The Fastest Way To Cleanly Shutdown An Oracle Database? (??? ID 386408.1)
????-----------------------------------------?ο????????￡?
?????????????
???????????????
????--?????LOCAL=NO??????????????KILL??
????ps -ef|grep LOCAL=NO|wc -l
????ps -ef|grep LOCAL=NO
????lsnrctl stop
???????????????JOB--?????????????????
????ps -ef|grep ora_j
??????????????????δ????--????????δ?????????????????????
????sqlplus '/ as sysdba'
????select status??instance_name??to_char(startup_time??'yyyy/mm/dd hh24:mi:ss') starttime from gv$instance;
????select open_mode??name from v$database;
????????д?????????
????select count(*) from v$transaction;
????select count(*) from v$session_longops where time_remaining>0;
????????д???????????
????select sum(used_ublk) from v$transaction; ---????д?????????ο??????
????select START_TIME??STATUS from v$transaction;
????????д???????????/??????????OPEN???????????
????select * from v$fast_start_transactions;
????select * from v$fast_start_servers;
?????塢??????????????????л?log
????--?????????????????????
??????????μ???????????????д????????????????????????????С??????????????????????
????alter system checkpoint;
?????л?????????
????SQL> alter system switch logfile;
??????????μ???
????alter system checkpoint;
???????л?????????
????SQL> alter system switch logfile;
???????????-??????????????????Ч????HANG????????
??????????й?????????????????′??????????????μ?????????й???
????SQL> shutdown immediate;