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 b
where a.paddr = b.addr
and b.spid = '&spid'
order by b.spid;
select a.sid, a.serial#, 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 b
where 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 I
where 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 p
WHERE 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);
select sql_text
from v$sqlarea a, v$session b
where a.SQL_ID = b.PREV_SQL_ID
and b.SID = &sid;
转载于:https://blog.51cto.com/7642644/1795001