AIX 交换分区使用

前端之家收集整理的这篇文章主要介绍了AIX 交换分区使用前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。




1) ps gv | head -n 1; ps gv | egrep -v "RSS" | sort +6b -7 -n -r
( SIZE―The actual amount of paging space allocated for this process )

2)svmon -P | grep -p PID



select b.spid,a.sid,a.serial#,a.username,a.osuser from v$session a,v$process bwhere a.paddr = b.addr and b.spid = '&spid'order by b.spid;select a.sid,a.status,a.program,b.event,to_char(a.logon_time,'dd-mon-yy hh24:mi') logoN_TIME,to_char(Sysdate,'dd-mon-yy--hh24:mi') CURRENT_TIME,(a.last_call_et / 3600) "Hrs connected" from v$session a,v$session_wait bwhere a.sid = &sid and a.sid = b.sid;select p.spid server_pid,s.sid oracle_sid,s.machine client_machine,i.host_name server_machine from gv$session s,gv$process p,gv$instance Iwhere p.inst_id = s.inst_id and p.addr = s.paddr and i.inst_id = s.inst_id and p.spid = '&server_pid';SELECT s.sid,p.spid "OS Pid",s.module,s.process,s.username "Username",s.osuser "OS User",s.program "Program",a.sql_id,substr(a.sql_text,1,550) "sql Text" FROM v$session s,v$sqlarea a,v$process pWHERE s.sql_hash_value = a.hash_value(+) AND s.sql_address = a.address(+) AND s.paddr = p.addr and s.sid = (select s.sid from v$session s,v$process p where s.paddr = p.addr and p.spid = &p);

猜你在找的Oracle相关文章