oradebug

http://www.juliandyke.com/Diagnostics/Tools/ORADEBUG/ORADEBUG.php
https://www.ashisuto.co.jp/tech-note/article/20140307_oracle.html

oradebug help

-- ダンプ取得

oradebug setmypid
oradebug tracefile_name
alter session set tracefile_identifier=test;
oradebug tracefile_name

oradebug dumplist

alter session set max_dump_file_size ='1G';

oradebug dump systemstate 10

oradebug dump buffers 1
oradebug dump buffers 2
oradebug dump buffers 3
oradebug dump buffers 4

oradebug dump enqueues 1

oradebug dump file_hdrs 1

oradebug dump redohdr 1

oradebug dump controlf 1

oradebug dump library_cache 1

oradebug dump heapdump 1

-- バックグランドプロセスのサスペンド

select t1.name, t2.pid
from v$bgprocess t1 inner join v$process t2
on t1.paddr = t2.addr
order by t1.name
;

oradebug setorapid 2
oradebug suspend
oradebug resume