{"id":22,"date":"2011-03-07T14:27:51","date_gmt":"2011-03-07T14:27:51","guid":{"rendered":"http:\/\/tomas.papp.me.uk\/?p=22"},"modified":"2011-05-06T19:58:38","modified_gmt":"2011-05-06T19:58:38","slug":"polovanie-na-databazove-linky","status":"publish","type":"post","link":"https:\/\/tomas.papp.me.uk\/?p=22","title":{"rendered":"polovanie na databazove linky"},"content":{"rendered":"<p>Ci uz ste fanusikom db liniek alebo nie..faktom je..ze&#8230;veci sa kazia;) A nikdy nieje na skodu vediet presne identifikovat master session a ku nej prisluchajucu\u00a0 db link slave session..Ocenite to hlavne vo viacnodovom RAC prostredi<\/p>\n<pre>\r\nSelect \/*+ ORDERED *\/\r\nsubstr(s.ksusemnm,1,10)||'-'|| substr(s.ksusepid,1,10)\u00a0\u00a0\u00a0\u00a0\u00a0 \"ORIGIN\",\r\nsubstr(g.K2GTITID_ORA,1,35) \"GTXID\",\r\nsubstr(s.indx,1,4)||'.'|| substr(s.ksuseser,1,5) \"LSESSION\" ,\r\ns2.username,\r\nsubstr(\r\ndecode(bitand(ksuseidl,11),\r\n1,'ACTIVE',\r\n0, decode( bitand(ksuseflg,4096) , 0,'INACTIVE','CACHED'),\r\n2,'SNIPED',\r\n3,'SNIPED',\r\n'KILLED'\r\n),1,1\r\n) \"S\",\r\nsubstr(w.event,1,10) \"WAITING\"\r\nfrom\u00a0 x$k2gte g, x$ktcxb t, x$ksuse s, v$session_wait w, v$session s2\r\nwhere\u00a0 g.K2GTDXCB =t.ktcxbxba\r\nand\u00a0\u00a0 g.K2GTDSES=t.ktcxbses\r\nand\u00a0 s.addr=g.K2GTDSES\r\nand\u00a0 w.sid=s.indx\r\nand s2.sid = w.sid;\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Ci uz ste fanusikom db liniek alebo nie..faktom je..ze&#8230;veci sa kazia;) A nikdy nieje na skodu vediet presne identifikovat master session a ku nej prisluchajucu\u00a0 db link slave session..Ocenite to hlavne vo viacnodovom RAC prostredi Select \/*+ ORDERED *\/ substr(s.ksusemnm,1,10)||&#8217;-&#8216;|| substr(s.ksusepid,1,10)\u00a0\u00a0\u00a0\u00a0\u00a0 &#8220;ORIGIN&#8221;, substr(g.K2GTITID_ORA,1,35) &#8220;GTXID&#8221;, substr(s.indx,1,4)||&#8217;.&#8217;|| substr(s.ksuseser,1,5) &#8220;LSESSION&#8221; , s2.username, substr( decode(bitand(ksuseidl,11), 1,&#8217;ACTIVE&#8217;, 0, decode( bitand(ksuseflg,4096) [&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-22","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\/22","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=22"}],"version-history":[{"count":2,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":40,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=\/wp\/v2\/posts\/22\/revisions\/40"}],"wp:attachment":[{"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tomas.papp.me.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}