{"id":18,"date":"2012-07-30T08:26:52","date_gmt":"2012-07-30T07:26:52","guid":{"rendered":"http:\/\/www.rdlpconsultants.co.uk\/blog\/?p=18"},"modified":"2014-09-28T21:48:09","modified_gmt":"2014-09-28T20:48:09","slug":"odi-session","status":"publish","type":"post","link":"https:\/\/www.rdlpconsultants.co.uk\/blog\/?p=18","title":{"rendered":"ODI Session"},"content":{"rendered":"<p>SELECT LEVEL<br \/>\n, ss.parent_sess_no<br \/>\n, ss.sess_no<br \/>\n, CONNECT_BY_ROOT<br \/>\nss.sess_name root_sess_name<br \/>\n, LPAD(&#8216;&gt; &#8216;,3*(LEVEL-1),&#8217;-&#8216;) || sess_name sess_name<br \/>\n, ss.sess_beg<br \/>\n, ss.sess_end<br \/>\n, stl.rows_processed<br \/>\n, ss.sess_dur<br \/>\n, ss.sess_status<br \/>\nFROM\u00a0 odi_atlas_work.snp_session ss<br \/>\n, (SELECT sess_no<br \/>\n, SUM(ABS(nb_row)) rows_processed<br \/>\nFROM odi_atlas_work.snp_sess_task_log<br \/>\nWHERE TRUNC(task_beg) &gt;= &#8217;01-JUL-2011&#8242;<br \/>\nAND TRUNC(task_end) &lt; &#8217;02-JUL-2011&#8217;<br \/>\nGROUP BY sess_no ) stl<br \/>\nWHERE\u00a0\u00a0\u00a0\u00a0\u00a0 ss.sess_no = stl.sess_no<br \/>\nAND UPPER(ss.agent_name) = &#8216;APOLLOSERVER&#8217;<br \/>\nSTART WITH ss.parent_sess_no IS NULL<br \/>\nAND ss.sess_beg &gt;= &#8217;01-JUL-2011&#8242;<br \/>\nAND ss.sess_end &lt; &#8217;02-JUL-2011&#8242;<br \/>\nCONNECT BY PRIOR ss.sess_no = ss.parent_sess_no<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT LEVEL , ss.parent_sess_no , ss.sess_no , CONNECT_BY_ROOT ss.sess_name root_sess_name , LPAD(&#8216;&gt; &#8216;,3*(LEVEL-1),&#8217;-&#8216;) || sess_name sess_name , ss.sess_beg , ss.sess_end , stl.rows_processed , ss.sess_dur , ss.sess_status FROM\u00a0 odi_atlas_work.snp_session ss , (SELECT sess_no , SUM(ABS(nb_row)) rows_processed FROM odi_atlas_work.snp_sess_task_log WHERE TRUNC(task_beg) &gt;= &#8217;01-JUL-2011&#8242; AND TRUNC(task_end) &lt; &#8217;02-JUL-2011&#8217; GROUP BY sess_no ) stl WHERE\u00a0\u00a0\u00a0\u00a0\u00a0 ss.sess_no = stl.sess_no AND [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-18","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/18","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=18"}],"version-history":[{"count":2,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions"}],"predecessor-version":[{"id":66,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=\/wp\/v2\/posts\/18\/revisions\/66"}],"wp:attachment":[{"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=18"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=18"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rdlpconsultants.co.uk\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=18"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}