trace
emcs
55次下载
544次浏览
2019-07-24
4.5

脚本内容

--SQL 10046 alter session set tracefile_identifier='enmo10046'; alter session set events '10046 trace name context forever, level 12'; run your sql; alter session set events '10046 trace name context off'; --如果会话已经运行了,可以用oradebug conn / as sysdba oradebug setospid 16835 oradebug unlimit oradebug event 10046 trace name context forever,level 12 oradebug event 10046 trace name context off --systemstate dump sqlplus -prelim / as sysdba oradebug setmypid oradebug unlimit; oradebug dump systemstate 266; --wait for 1 min oradebug dump systemstate 266; --wait for 1 min oradebug dump systemstate 266; oradebug tracefile_name; --hanganalyze oradebug setmypid oradebug unlimit; oradebug dump hanganalyze 3 --wait for 1 min oradebug dump hanganalyze 3 --wait for 1 min oradebug dump hanganalyze 3 oradebug tracefile_name;

评论

贡献排行榜