假如说是个普通的oracle进程，有什么办法通过oracle的PID查询到

发布时间：2020-12-12 13:59:59 所属栏目：百科来源：网络整理

导读：可以 AIX: #!/bin/bash ps -e -o pCPU -o pid -o user -o args | grep Oracle | sort -k 1| tail -5r spid=`ps -e -o pcpu -o pid -o user -o args | grep oracle | sort -k 1| tail -5r | awk '{print $2}'` for i in $spid do sqlplus -S /nolog EOF conn

可以

AIX:
#!/bin/bash
ps -e -o pCPU -o pid -o user -o args | grep Oracle | sort -k 1| tail -5r
spid=`ps -e -o pcpu -o pid -o user -o args | grep oracle | sort -k 1| tail -5r | awk '{print $2}'`
for i in $spid
do
sqlplus -S /nolog << EOF
conn / as sysdba
set feedback off
set linesize 200
set pagesize 70
column spid format 99999
column sid format 99999
column module format a20
column username format a8
column sql_text format a60
select distinct c.spid,b.sid,b.username,
a.module,a.hash_value,sql_text
from v$sql a,v$session b,v$process c
where a.hash_value=b.sql_hash_value and
a.address=b.sql_address and b.paddr=c.addr and c.spid =$i;
exit
EOF
done
LINUX:
ps -e -o pCPU -o pid -o user -o args | grep Oracle | sort -k 1| tail -5
spid=`ps -e -o pcpu -o pid -o user -o args | grep oracle | sort -k 1| tail -5 | awk '{print $2}'`
done

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!