oracle常用命令2
查看集群状态： crsctl stat res -t --oracle(用户名)
集群启动：crsctl start crs --root(用户名)
集群停止：crsctl stop crs --root(用户名) -f
集群，数据库日志查看
10g:
/oracle/product/admin/<dbname>/bdump/alert_<SID>.log
/oracle/product/CRS/log/<hostname>/crsd/crsd.log
11g:
/oracle/diag/rdbms/<dbname>/<SID>/trace/alert_<SID>.log
/grid/grid_home/log/<hostname>/crsd/crsd.log
12c:
/oracle/diag/rdbms/<dbname>/<SID>/trace/alert_<SID>.log
/grid/grid_base/diag/crs/<hostname>/crs/trace/crsd.trc
收集awr，ash报告
Sqlplus "/ as sysdba" << EOF
/$ORACLE_HOME/rdbms/admin/awrrpt.sql
EOF
Sqlplus <<EOF
sys/change_on_install(默认密码) as sysdba
/$ORACLE_HOME/rdbms/admin/ashrpt.sql
EOF
查看实例状态
Sqlplus /nolog <<EOF
conn /as sysdba
Select instance_name,status form v$instance;
EOF
查看实例节点会话连接数
Sqlplus / as sysdba <<EOF
Select count(*) form v$session;
EOF
查看节点进程数
查看允许的最大进程数
Sqlplus / as sysdba <<EOF
show paramerter processes;
EOF
查看当前节点的进程数
Sqlplus / as sysdba <<EOF
Select count(*) form v$process;
EOF
查看死锁状态
Sqlplus / as sysdba <<EOF
select username,lockwait,status,machine,program from v$session where sid in (select session_id from v$locked_object);
EOF
username：死锁语句所用的数据库用户
lockwait：死锁状态，如果有内容表示被死锁
status：状态，active表示被死锁
machine：死锁语句所在的机器
program：产生死锁的语句主要来自哪个应用程序
查询被死锁的语句
Sqlplus / as sysdba <<EOF
select sql_text from v$sql_ where hash_value in (select sql_hash_value from v$session where sid in (select session_id from v$locked_object));
EOF
杀死指定会话
Sqlplus / as sysdba <<EOF
alter system kill session 'sid,serial#';
EOF
