{"id":772,"date":"2019-02-03T07:37:00","date_gmt":"2019-02-03T07:37:00","guid":{"rendered":"http:\/\/blog.idesglobal.com\/?p=772"},"modified":"2019-02-03T07:37:00","modified_gmt":"2019-02-03T07:37:00","slug":"om-att-halla-inaktiva-sessioner-vid-liv","status":"publish","type":"post","link":"https:\/\/blog.idesglobal.com\/index.php\/2019\/02\/03\/om-att-halla-inaktiva-sessioner-vid-liv\/","title":{"rendered":"Om att h\u00e5lla inaktiva sessioner vid liv"},"content":{"rendered":"<p>F\u00f6r att f\u00f6rhindra att inaktiva sessioner blir avbrutna kan man konfigurera s\u00e5 att test av anslutningen utf\u00f6rs med givet tidsintervall. Inst\u00e4llningen heter <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/18\/netrf\/parameters-for-the-sqlnet-ora-file.html#GUID-1070805B-0703-457C-8D2E-4EEC26193E5F\">SQLNET.EXPIRE_TIME<\/a> och tiden mellan verifieringarna anges i minuter. Se exempel nedan.<\/p>\n<pre class=\"oac_no_warn\" dir=\"ltr\">SQLNET.EXPIRE_TIME=10<\/pre>\n<p>Det \u00e4r p\u00e5 Oracle-servern i filen SQLNet.ora inst\u00e4llningen anges. Filen \u00e5terfinns p\u00e5\u00a0[oracle installation]\\network\\admin<\/p>\n<p>Att s\u00e4tta ett v\u00e4rde p\u00e5 inst\u00e4llningen \u00e4r fr\u00e4mst aktuellt om man upplevt problem att anslutningar blivit brutna n\u00e4r man varit inaktiv. Hur t\u00e4tt man b\u00f6r testa beror p\u00e5 hur l\u00e5ng tid en session brukar kunna vara inaktiv innan den blir avbruten. Oavsett om det \u00e4r brandv\u00e4gg\/skyddsprogramvara eller n\u00e5got annat som klipper inaktiva sessioner s\u00e5 f\u00e5r man prova sig fram vad som \u00e4r ett lagom v\u00e4rde. Att ange ett l\u00e4gre v\u00e4rde inneb\u00e4r\u00a0mer n\u00e4tverkstrafik. Ett h\u00f6gre v\u00e4rde inneb\u00e4r klippt session. Oracles rekommendation \u00e4r 10 minuter. Fast den \u00e4r per default inte uppsatt vilket tolkas som 0 vilket inneb\u00e4r inaktiverad.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>F\u00f6r att f\u00f6rhindra att inaktiva sessioner blir avbrutna kan man konfigurera s\u00e5 att test av anslutningen utf\u00f6rs med givet tidsintervall. Inst\u00e4llningen heter SQLNET.EXPIRE_TIME och tiden mellan verifieringarna anges i minuter. Se exempel nedan. SQLNET.EXPIRE_TIME=10 Det \u00e4r p\u00e5 Oracle-servern i filen SQLNet.ora inst\u00e4llningen anges. Filen \u00e5terfinns p\u00e5\u00a0[oracle installation]\\network\\admin Att s\u00e4tta ett v\u00e4rde p\u00e5 inst\u00e4llningen \u00e4r fr\u00e4mst [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[30,50,56,64,80,84],"class_list":["post-772","post","type-post","status-publish","format-standard","hentry","category-support","tag-avbrott","tag-expire_time","tag-keep-alive","tag-oracle","tag-session","tag-sqlnet-ora"],"_links":{"self":[{"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/posts\/772","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/comments?post=772"}],"version-history":[{"count":0,"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/posts\/772\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/media?parent=772"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/categories?post=772"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.idesglobal.com\/index.php\/wp-json\/wp\/v2\/tags?post=772"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}