ORACLE重启常用命令

exec dbms_workload_repository.create_snapshot; 

@?/rdbms/admin/awrrpt

@?/rdbms/admin/ashrpt.sql

@?/rdbms/admin/addmrpt.sql

shutdown immediate

startup

lsnrctl stop
lsnrctl start
lsnrctl status

ps -ef|grep test|grep LOCAL=NO|grep -v grep|awk '{print "kill -9 "$2}'|sh