{"id":1244,"date":"2019-12-03T14:53:22","date_gmt":"2019-12-03T06:53:22","guid":{"rendered":"http:\/\/www.821121.com\/?p=1244"},"modified":"2021-01-04T15:04:14","modified_gmt":"2021-01-04T07:04:14","slug":"%e8%8e%b7%e5%8f%96%e5%bd%93%e5%89%8d%e4%bc%9a%e8%af%9d%e7%9a%84trace%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"http:\/\/www.821121.com\/?p=1244","title":{"rendered":"\u83b7\u53d6\u5f53\u524d\u4f1a\u8bdd\u7684trace\u4fe1\u606f"},"content":{"rendered":"<p>\u67e5\u770b\u5f53\u524d\u4f1a\u8bdd\u7684SID\u548cSERIAL#<\/p>\n<pre><code class=\"language-sql\">SQL&gt;  select SID,SERIAL# from v$session where sid = (select sid from v$mystat where rownum = 1);  \n\n       SID    SERIAL#\n---------- ----------\n        82        599<\/code><\/pre>\n<p>\u542f\u52a8trace<\/p>\n<pre><code class=\"language-sql\">SQL&gt; execute dbms_system.set_sql_trace_in_session(82,599,true);   \n\nPL\/SQL procedure successfully completed.<\/code><\/pre>\n<p>\u5b8c\u6210\u540e\uff0c\u505c\u6b62trace\u3002<\/p>\n<pre><code class=\"language-sql\">SQL&gt; execute dbms_system.set_sql_trace_in_session(82,599,false);\n\nPL\/SQL procedure successfully completed.<\/code><\/pre>\n<p>\u67e5\u770btrace\u6587\u4ef6\u8def\u5f84<\/p>\n<pre><code class=\"language-sql\">SQL&gt; select a.TRACEFILE from v$process a where a.ADDR in (select paddr from v$session where sid=82);\n\nTRACEFILE\n-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\n\/u01\/app\/oracle\/diag\/rdbms\/racdb\/racdb1\/trace\/racdb1_ora_15427.trc<\/code><\/pre>\n<p>\u67e5\u770btrace\u6587\u4ef6\u5185\u5bb9<\/p>\n<pre><code class=\"language-sql\">[root@rac1 ~]# tail -f \/u01\/app\/oracle\/diag\/rdbms\/racdb\/racdb1\/trace\/racdb1_ora_15427.trc\nSTAT #140524433493112 id=7 cnt=86345 pid=5 pos=2 obj=0 op=&#039;HASH JOIN  (cr=1068 pr=0 pw=0 time=57943 us cost=294 size=9143030 card=86255)&#039;\nSTAT #140524433493112 id=8 cnt=87 pid=7 pos=1 obj=47 op=&#039;INDEX FULL SCAN I_USER2 (cr=1 pr=0 pw=0 time=7 us cost=1 size=1914 card=87)&#039;\nSTAT #140524433493112 id=9 cnt=86345 pid=7 pos=2 obj=18 op=&#039;TABLE ACCESS FULL OBJ$ (cr=1067 pr=0 pw=0 time=36404 us cost=292 size=7252056 card=86334)&#039;\nSTAT #140524433493112 id=10 cnt=0 pid=4 pos=2 obj=0 op=&#039;NESTED LOOPS  (cr=0 pr=0 pw=0 time=0 us cost=2 size=29 card=1)&#039;\nSTAT #140524433493112 id=11 cnt=0 pid=10 pos=1 obj=47 op=&#039;INDEX SKIP SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us cost=1 size=20 card=1)&#039;\nSTAT #140524433493112 id=12 cnt=0 pid=10 pos=2 obj=39 op=&#039;INDEX RANGE SCAN I_OBJ4 (cr=0 pr=0 pw=0 time=0 us cost=1 size=9 card=1)&#039;\nSTAT #140524433493112 id=13 cnt=0 pid=3 pos=2 obj=0 op=&#039;NESTED LOOPS  (cr=1 pr=0 pw=0 time=45 us cost=1 size=17 card=1)&#039;\nSTAT #140524433493112 id=14 cnt=0 pid=13 pos=1 obj=138 op=&#039;INDEX FULL SCAN I_LINK1 (cr=1 pr=0 pw=0 time=44 us cost=0 size=13 card=1)&#039;\nSTAT #140524433493112 id=15 cnt=0 pid=13 pos=2 obj=47 op=&#039;INDEX RANGE SCAN I_USER2 (cr=0 pr=0 pw=0 time=0 us cost=1 size=4 card=1)&#039;\nFETCH #140524433493112:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=1250653294,tim=1609743664086145<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u67e5\u770b\u5f53\u524d\u4f1a\u8bdd\u7684SID\u548cSERIAL# SQL&#038;gt<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[],"class_list":["post-1244","post","type-post","status-publish","format-standard","hentry","category-oracle-11g"],"_links":{"self":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1244","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1244"}],"version-history":[{"count":1,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1244\/revisions"}],"predecessor-version":[{"id":1245,"href":"http:\/\/www.821121.com\/index.php?rest_route=\/wp\/v2\/posts\/1244\/revisions\/1245"}],"wp:attachment":[{"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1244"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1244"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.821121.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1244"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}