{"id":216,"date":"2013-02-05T14:17:13","date_gmt":"2013-02-05T14:17:13","guid":{"rendered":"http:\/\/tomas.papp.me.uk\/?p=216"},"modified":"2013-02-05T14:21:58","modified_gmt":"2013-02-05T14:21:58","slug":"trace-by-sqlid-v-oracle-11g","status":"publish","type":"post","link":"https:\/\/tomas.papp.me.uk\/?p=216","title":{"rendered":"Trace by sqlid v Oracle 11g"},"content":{"rendered":"<pre>alter system set events 'sql_trace [sql:60x3man71byuz] level 12';<\/pre>\n<pre>alebo<\/pre>\n<pre>SQL&gt; -- Setting Oracle PID to trace and verify by crossing the result of the system pid\r\nSQL&gt; oradebug setorapid 25\r\nOracle pid: 25, Unix process pid: 4850, image: oracle@oel (TNS V1-V3)\r\nSQL&gt; -- nolimit to tracefile\r\nSQL&gt; oradebug unlimit\r\nStatement processed.\r\nSQL&gt; -- tracing SQL_Optimizer computation for a specific sql (here's our sql_id)\r\nSQL&gt; oradebug event\r\nSQL&gt; trace[RDBMS.SQL_Optimizer.*][sql:2zg40utr7a08n]\r\nStatement processed.\r\nSQL&gt; -- obtain the trace file name\r\nSQL&gt; oradebug tracefile_name\r\n\/u01\/app\/oracle\/diag\/rdbms\/orcl\/orcl\/trace\/orcl_ora_4850.trc<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>alter system set events &#8216;sql_trace [sql:60x3man71byuz] level 12&#8217;; alebo SQL&gt; &#8212; Setting Oracle PID to trace and verify by crossing the result of the system pid SQL&gt; oradebug setorapid 25 Oracle pid: 25, Unix process pid: 4850, image: oracle@oel (TNS V1-V3) SQL&gt; &#8212; nolimit to tracefile SQL&gt; oradebug unlimit Statement processed. SQL&gt; &#8212; tracing SQL_Optimizer [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-216","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/216","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=216"}],"version-history":[{"count":2,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/216\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/216\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=216"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=216"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=216"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}