{"id":62,"date":"2007-04-18T11:25:22","date_gmt":"2007-04-18T09:25:22","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=62"},"modified":"2012-04-03T09:56:56","modified_gmt":"2012-04-03T07:56:56","slug":"sprawdzenie-kto-jest-zalogowany-do-jakiej-formatki","status":"publish","type":"post","link":"http:\/\/oracle.malin.pl\/?p=62","title":{"rendered":"SQL &#8211; Sprawdzenie kto jest zalogowany do jakiej formatki"},"content":{"rendered":"<p>Skrypt, sprawdzaj\u0105cy kto jest aktualnie zalogowany i pracuje w poszczeg\u00f3lnych formatkach:<!--more--><\/p>\n<pre lang='PLSQL'>\r\nselect s.SID, p.SPID,  \r\n\r\nround(((sysdate - logon_time)*24*60),2) \"Duration\",  \r\n\r\nlast_call_et\/60 \"Idle\",  \r\n\r\nf.user_name, u.description, s.module,s.action  \r\n\r\nfrom v$session s, v$process p, FND_SIGNON_AUDIT_VIEW f, FND_USER u  \r\n\r\nwhere p.addr = s.paddr  \r\n\r\nand s.username is not null  \r\n\r\nand f.pid = p.pid  \r\n\r\nand f.process_spid = p.spid  \r\n\r\nand f.user_id = u.user_id  \r\n\r\norder by f.user_name<\/pre>\n<p>Skrypt opracowany przez Lucka Dam\u0119tk\u0119.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Skrypt, sprawdzaj\u0105cy kto jest aktualnie zalogowany i pracuje w poszczeg\u00f3lnych formatkach:<\/p>\n","protected":false},"author":20,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[97],"tags":[225,226],"_links":{"self":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/62"}],"collection":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=62"}],"version-history":[{"count":3,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":704,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions\/704"}],"wp:attachment":[{"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}