{"id":204,"date":"2012-03-02T03:44:09","date_gmt":"2012-03-02T03:44:09","guid":{"rendered":"http:\/\/oranotes.tuktaroff.com\/?page_id=204"},"modified":"2012-03-07T04:36:40","modified_gmt":"2012-03-07T04:36:40","slug":"trace","status":"publish","type":"page","link":"http:\/\/oranotes.tuktaroff.com\/?page_id=204","title":{"rendered":"Trace"},"content":{"rendered":"<p><code><\/p>\n<pre class=\"qcode\">\r\n-- trace on\r\nalter session set sql_trace=true;\r\n\r\nsys.dbms_system.set_sql_trace_in_session(SID, serial#, true);\r\n\r\nsys.dbms_system.set_ev(SID, serial#, 10046, 12, '');\r\n\r\nDBMS_MONITOR.session_trace_enable (\r\n    session_id => 15,\r\n    serial_num => 1234);\r\n\r\n-- trace off\r\nalter session set sql_trace=false;\r\n\r\nexec dbms_system.set_ev(18,1217,10046,0,'');\r\n\r\nDBMS_MONITOR.session_trace_disable (\r\n    session_id => 15,\r\n    serial_num => 1234);\r\n\r\n<\/pre>\n<p><\/code><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8212; trace on alter session set sql_trace=true; sys.dbms_system.set_sql_trace_in_session(SID, serial#, true); sys.dbms_system.set_ev(SID, serial#, 10046, 12, &#8221;); DBMS_MONITOR.session_trace_enable ( session_id => 15, serial_num => 1234); &#8212; trace off alter session set sql_trace=false; exec dbms_system.set_ev(18,1217,10046,0,&#8221;); DBMS_MONITOR.session_trace_disable ( session_id => 15, serial_num => 1234);<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":14,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-204","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P2NVny-3i","_links":{"self":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/204","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=204"}],"version-history":[{"count":3,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/204\/revisions"}],"predecessor-version":[{"id":290,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/204\/revisions\/290"}],"up":[{"embeddable":true,"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=\/wp\/v2\/pages\/14"}],"wp:attachment":[{"href":"http:\/\/oranotes.tuktaroff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=204"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}