Oracle 收集进程信息（ heapdump or event ）【 备忘 】

1、heapdump

select pid from v$process p,v$session s where p.addr=s.paddr and sid=<sid>;
oradebug setorapid <pid>
oradebug unlimit
oradebug dump errorstack 3
oradebug dump heapdump 536870917
oradebug tracefile_name -- show the path and filename information
oradebug close_trace

2、event

alter system set events '4030 trace name errorstack level 3; name heapdump level 536870917';
-- get tracefile name
alter system set events '4030 trace name errorstack off';
alter system set events '4030 trace name heapdump off';