{"id":834,"date":"2026-03-26T16:32:14","date_gmt":"2026-03-26T13:32:14","guid":{"rendered":"https:\/\/oraclius.com.tr\/?p=834"},"modified":"2026-03-27T12:30:55","modified_gmt":"2026-03-27T09:30:55","slug":"q1","status":"publish","type":"post","link":"https:\/\/oraclius.com.tr\/tr\/q1\/","title":{"rendered":"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL"},"content":{"rendered":"\n
SELECT \n    lo.inst_id,\n    s.sid,\n    s.serial#,\n    s.username,\n    s.osuser,\n    s.machine,\n    s.program,\n    lo.oracle_username,\n    o.owner,\n    o.object_name,\n    o.object_type,\n    CASE lo.locked_mode\n        WHEN 0 THEN 'None'\n        WHEN 1 THEN 'Null'\n        WHEN 2 THEN 'Row-S (SS)'\n        WHEN 3 THEN 'Row-X (SX)'\n        WHEN 4 THEN 'Share'\n        WHEN 5 THEN 'S\/Row-X (SSX)'\n        WHEN 6 THEN 'Exclusive'\n        ELSE 'Unknown'\n    END AS lock_mode,\n    s.status,\n    s.logon_time\nFROM gv$locked_object lo\nJOIN dba_objects o \n    ON lo.object_id = o.object_id\nJOIN gv$session s \n    ON lo.session_id = s.sid\n   AND lo.inst_id = s.inst_id\nORDER BY lo.inst_id, s.sid;<\/code><\/pre>\n\n\n\n
\ud83e\udde0 A\u00e7\u0131klama<\/h1>\n\n\n\n
Bu sorgu, Oracle Database \u00fczerinde:<\/p>\n\n\n\n
\ud83d\udc49 Hangi session hangi objeyi hangi lock ile kilitlemi\u015f<\/strong>
sorusunun cevab\u0131n\u0131 detayl\u0131 \u015fekilde verir.<\/p>\n\n\n\n
\u00d6zellikle:<\/p>\n\n\n\n
    \n
  • Lock problemlerini analiz etmek<\/li>\n\n\n\n
  • Blocking session\u2019lar\u0131 bulmak<\/li>\n\n\n\n
  • DML\/DDL \u00e7ak\u0131\u015fmalar\u0131n\u0131 incelemek
    i\u00e7in kullan\u0131l\u0131r.<\/li>\n<\/ul>\n\n\n\n
    \n\n\n\n
    \ud83d\udce6 Kullan\u0131lan View\u2019lar<\/h1>\n\n\n\n
    \ud83d\udd39 GV$LOCKED_OBJECT<\/code><\/h3>\n\n\n\n
      \n
    • Kilitlenen objeleri getirir<\/li>\n\n\n\n
    • Hangi session\u2019\u0131n lock tuttu\u011funu g\u00f6sterir<\/li>\n<\/ul>\n\n\n\n
      \ud83d\udd39 DBA_OBJECTS<\/code><\/h3>\n\n\n\n
        \n
      • Object ID \u2192 object name \u00e7evirisi yap\u0131l\u0131r<\/li>\n\n\n\n
      • Tablo, index, vb. bilgileri verir<\/li>\n<\/ul>\n\n\n\n
        \ud83d\udd39 GV$SESSION<\/code><\/h3>\n\n\n\n
          \n
        • Session detaylar\u0131n\u0131 verir:\n
            \n
          • kullan\u0131c\u0131<\/li>\n\n\n\n
          • makine<\/li>\n\n\n\n
          • program<\/li>\n\n\n\n
          • durum<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
            \n\n\n\n
            \ud83d\udd11 Kolon A\u00e7\u0131klamalar\u0131<\/h1>\n\n\n\n
            \ud83d\udc64 Session Bilgileri<\/h3>\n\n\n\n
              \n
            • SID \/ SERIAL#<\/strong> \u2192 Session kimli\u011fi (kill etmek i\u00e7in kullan\u0131l\u0131r)<\/li>\n\n\n\n
            • USERNAME<\/strong> \u2192 Oracle kullan\u0131c\u0131s\u0131<\/li>\n\n\n\n
            • OSUSER<\/strong> \u2192 \u0130\u015fletim sistemi kullan\u0131c\u0131s\u0131<\/li>\n\n\n\n
            • MACHINE<\/strong> \u2192 Ba\u011flan\u0131lan client makine<\/li>\n\n\n\n
            • PROGRAM<\/strong> \u2192 Uygulama (\u00f6rn: JDBC, TOAD)<\/li>\n<\/ul>\n\n\n\n
              \n\n\n\n
              \ud83d\udce6 Object Bilgileri<\/h3>\n\n\n\n
                \n
              • OWNER<\/strong> \u2192 Schema sahibi<\/li>\n\n\n\n
              • OBJECT_NAME<\/strong> \u2192 Kilitlenen obje<\/li>\n\n\n\n
              • OBJECT_TYPE<\/strong> \u2192 TABLE \/ INDEX \/ vb.<\/li>\n<\/ul>\n\n\n\n
                \n\n\n\n
                \ud83d\udd12 Lock Bilgisi<\/h3>\n\n\n\n
                \ud83d\udd39 0 \u2014 None<\/h2>\n\n\n\n
                \ud83d\udc49 Kilitleme yok<\/strong><\/p>\n\n\n\n
                  \n
                • Objede aktif bir lock yoktur<\/li>\n\n\n\n
                • Genelde transient (ge\u00e7ici) durumlarda g\u00f6r\u00fcl\u00fcr<\/li>\n<\/ul>\n\n\n\n
                  \ud83e\udde0 Yorum:<\/p>\n\n\n\n
                  \n
                  \u00c7o\u011fu zaman pratikte \u00e7ok anlaml\u0131 de\u011fildir<\/p>\n<\/blockquote>\n\n\n\n
                  <\/p>\n\n\n\n
                  \ud83d\udd39 1 \u2014 Null (N)<\/h2>\n\n\n\n
                  \ud83d\udc49 En d\u00fc\u015f\u00fck seviyeli lock<\/strong><\/p>\n\n\n\n
                    \n
                  • Asl\u0131nda \u201cger\u00e7ek\u201d bir kilit de\u011fildir<\/li>\n\n\n\n
                  • Sadece:\n
                      \n
                    • obje \u00fczerinde bir i\u015flem yap\u0131labilece\u011fini g\u00f6sterir<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
                      \ud83d\udc49 \u00d6zellik:<\/p>\n\n\n\n
                        \n
                      • Hi\u00e7bir \u015feyi bloklamaz<\/li>\n\n\n\n
                      • Di\u011fer t\u00fcm lock\u2019larla uyumludur<\/li>\n<\/ul>\n\n\n\n
                        \ud83e\udde0 Yorum:<\/p>\n\n\n\n
                        \n
                        Oracle\u2019\u0131n i\u00e7sel lock mekanizmas\u0131 i\u00e7in placeholder gibi \u00e7al\u0131\u015f\u0131r<\/p>\n<\/blockquote>\n\n\n\n
                        <\/p>\n\n\n\n
                        \ud83d\udd39 2 \u2014 Row-S (SS \u2013 Row Share)<\/h2>\n\n\n\n
                        \ud83d\udc49 Sat\u0131r seviyesinde i\u015flem yap\u0131lacak<\/strong><\/p>\n\n\n\n
                          \n
                        • Genelde:\n
                            \n
                          • SELECT ... FOR UPDATE<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
                            \ud83d\udc49 \u00d6zellik:<\/p>\n\n\n\n
                              \n
                            • \u2714\ufe0f Okuma serbest<\/li>\n\n\n\n
                            • \u2714\ufe0f DML genelde serbest<\/li>\n\n\n\n
                            • \u274c G\u00fc\u00e7l\u00fc lock\u2019lar engellenir<\/li>\n<\/ul>\n\n\n\n
                              \ud83e\udde0 Yorum:<\/p>\n\n\n\n
                              \n
                              \u201cBen sat\u0131rlarla ilgileniyorum, ama sistemi kilitlemiyorum\u201d<\/p>\n<\/blockquote>\n\n\n\n
                              <\/p>\n\n\n\n
                              \ud83d\udd39 3 \u2014 Row-X (SX \u2013 Row Exclusive)<\/h2>\n\n\n\n
                              \ud83d\udc49 DML i\u015flemi var<\/strong><\/p>\n\n\n\n
                                \n
                              • Olu\u015fur:\n
                                  \n
                                • INSERT<\/code><\/li>\n\n\n\n
                                • UPDATE<\/code><\/li>\n\n\n\n
                                • DELETE<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
                                  \ud83d\udc49 \u00d6zellik:<\/p>\n\n\n\n
                                    \n
                                  • \u2714\ufe0f Okuma serbest<\/li>\n\n\n\n
                                  • \u2714\ufe0f Di\u011fer DML i\u015flemleri m\u00fcmk\u00fcn<\/li>\n\n\n\n
                                  • \u274c Share ve daha g\u00fc\u00e7l\u00fc lock\u2019lar engellenir<\/li>\n<\/ul>\n\n\n\n
                                    \ud83e\udde0 Yorum:<\/p>\n\n\n\n
                                    \n
                                    En yayg\u0131n lock t\u00fcr\u00fc \u2014 normal \u00e7al\u0131\u015fma durumu<\/p>\n<\/blockquote>\n\n\n\n
                                    <\/p>\n\n\n\n
                                    \ud83d\udd39 4 \u2014 Share (S)<\/h2>\n\n\n\n
                                    \ud83d\udc49 Okuma kilidi<\/strong><\/p>\n\n\n\n
                                      \n
                                    • Olu\u015fur:\n
                                        \n
                                      • LOCK TABLE ... IN SHARE MODE<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
                                        \ud83d\udc49 \u00d6zellik:<\/p>\n\n\n\n
                                          \n
                                        • \u2714\ufe0f Okuma serbest<\/li>\n\n\n\n
                                        • \u274c DML i\u015flemleri bloklan\u0131r<\/li>\n<\/ul>\n\n\n\n
                                          \ud83e\udde0 Yorum:<\/p>\n\n\n\n
                                          \n
                                          \u201cBu veri de\u011fi\u015fmesin, sadece okunsun\u201d<\/p>\n<\/blockquote>\n\n\n\n
                                          <\/p>\n\n\n\n
                                          \ud83d\udd39 5 \u2014 S\/Row-X (SSX \u2013 Share Row Exclusive)<\/h2>\n\n\n\n
                                          \ud83d\udc49 Karma lock (Share + Exclusive)<\/strong><\/p>\n\n\n\n
                                            \n
                                          • Hem:\n
                                              \n
                                            • payla\u015f\u0131m (share)<\/li>\n\n\n\n
                                            • hem de\u011fi\u015fiklik niyeti (exclusive)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
                                              \ud83d\udc49 \u00d6zellik:<\/p>\n\n\n\n
                                                \n
                                              • \u2714\ufe0f Okuma genelde m\u00fcmk\u00fcn<\/li>\n\n\n\n
                                              • \u274c DML b\u00fcy\u00fck \u00f6l\u00e7\u00fcde k\u0131s\u0131tlan\u0131r<\/li>\n\n\n\n
                                              • \u274c Di\u011fer g\u00fc\u00e7l\u00fc lock\u2019lar bloklan\u0131r<\/li>\n<\/ul>\n\n\n\n
                                                \ud83e\udde0 Yorum:<\/p>\n\n\n\n
                                                \n
                                                Karma\u015f\u0131k ve genelde problemli lock t\u00fcr\u00fc<\/p>\n<\/blockquote>\n\n\n\n
                                                <\/p>\n\n\n\n
                                                \ud83d\udd39 6 \u2014 Exclusive (X)<\/h2>\n\n\n\n
                                                \ud83d\udc49 Tam kilit<\/strong><\/p>\n\n\n\n
                                                  \n
                                                • Olu\u015fur:\n
                                                    \n
                                                  • ALTER TABLE<\/code><\/li>\n\n\n\n
                                                  • DROP TABLE<\/code><\/li>\n\n\n\n
                                                  • TRUNCATE<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
                                                    \ud83d\udc49 \u00d6zellik:<\/p>\n\n\n\n
                                                      \n
                                                    • \u274c Okuma yok (\u00e7o\u011fu durumda bekler)<\/li>\n\n\n\n
                                                    • \u274c Yazma yok<\/li>\n\n\n\n
                                                    • \u274c Tam bloklama<\/li>\n<\/ul>\n\n\n\n
                                                      \ud83e\udde0 Yorum:<\/p>\n\n\n\n
                                                      \n
                                                      En a\u011f\u0131r lock \u2014 sistemde beklemelerin ana sebebi<\/p>\n<\/blockquote>\n\n\n\n
                                                      <\/p>\n\n\n\n
                                                      \u2699\ufe0f Genel \u00d6zet Tablosu<\/p>\n\n\n\n
                                                      De\u011fer<\/th>Lock Ad\u0131<\/th>Okuma<\/th>Yazma<\/th>A\u00e7\u0131klama<\/th><\/tr><\/thead>
                                                      0<\/td>None<\/td>\u2714\ufe0f<\/td>\u2714\ufe0f<\/td>Lock yok<\/td><\/tr>
                                                      1<\/td>Null<\/td>\u2714\ufe0f<\/td>\u2714\ufe0f<\/td>Placeholder<\/td><\/tr>
                                                      2<\/td>Row-S (SS)<\/td>\u2714\ufe0f<\/td>\u2714\ufe0f<\/td>Hafif lock<\/td><\/tr>
                                                      3<\/td>Row-X (SX)<\/td>\u2714\ufe0f<\/td>\u2714\ufe0f<\/td>DML lock<\/td><\/tr>
                                                      4<\/td>Share (S)<\/td>\u2714\ufe0f<\/td>\u274c<\/td>Okuma kilidi<\/td><\/tr>
                                                      5<\/td>SSX<\/td>\u2714\ufe0f<\/td>\u274c (\u00e7o\u011fu)<\/td>Karma lock<\/td><\/tr>
                                                      6<\/td>Exclusive (X)<\/td>\u274c<\/td>\u274c<\/td>Tam kilit<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
                                                      \n\n\n\n
                                                      \u2699\ufe0f Di\u011fer<\/h3>\n\n\n\n
                                                        \n
                                                      • STATUS<\/strong> \u2192 Session aktif mi<\/li>\n\n\n\n
                                                      • LOGON_TIME<\/strong> \u2192 Ne zamand\u0131r ba\u011fl\u0131<\/li>\n<\/ul>\n\n\n\n
                                                        \n\n\n\n
                                                        \ud83d\ude80 Ne Zaman Kullan\u0131l\u0131r?<\/h1>\n\n\n\n
                                                          \n
                                                        • \u201cTablo neden kilitli?\u201d sorusunda<\/li>\n\n\n\n
                                                        • Uygulama tak\u0131ld\u0131\u011f\u0131nda<\/li>\n\n\n\n
                                                        • Deadlock \/ blocking analizinde<\/li>\n\n\n\n
                                                        • Performans troubleshooting s\u0131ras\u0131nda<\/li>\n<\/ul>\n\n\n\n
                                                          \n\n\n\n
                                                          \ud83d\udca1 Not<\/h1>\n\n\n\n
                                                          Bu sorgu:<\/p>\n\n\n\n
                                                            \n
                                                          • Tablo seviyesinde lock bilgisini g\u00f6sterir (TM lock)<\/strong><\/li>\n\n\n\n
                                                          • Sat\u0131r bazl\u0131 kilitleri (TX lock<\/strong>) direkt g\u00f6stermez<\/li>\n<\/ul>\n\n\n\n
                                                            <\/p>\n","protected":false},"excerpt":{"rendered":"
                                                            \ud83e\udde0 A\u00e7\u0131klama Bu sorgu, Oracle Database \u00fczerinde: \ud83d\udc49 Hangi session hangi objeyi hangi lock ile kilitlemi\u015fsorusunun cevab\u0131n\u0131 detayl\u0131 \u015fekilde verir. \u00d6zellikle: \ud83d\udce6 Kullan\u0131lan View\u2019lar \ud83d\udd39 GV$LOCKED_OBJECT \ud83d\udd39 DBA_OBJECTS \ud83d\udd39 GV$SESSION \ud83d\udd11 Kolon A\u00e7\u0131klamalar\u0131 \ud83d\udc64 Session Bilgileri \ud83d\udce6 Object Bilgileri \ud83d\udd12 Lock Bilgisi \ud83d\udd39 0 \u2014 None \ud83d\udc49 Kilitleme yok \ud83e\udde0 Yorum: \u00c7o\u011fu zaman pratikte \u00e7ok […]<\/p>\n","protected":false},"author":1,"featured_media":55,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[161],"tags":[],"class_list":["post-834","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-useful-queries"],"yoast_head":"\nLocklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL<\/title>\n<meta name=\"description\" content=\"SELECT lo.inst_id, s.sid, s.serial#, s.username, s.osuser, s.machine, s.program, lo.oracle_username, o.owner, o.object_name, o.object_type, CASE\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/oraclius.com.tr\/tr\/q1\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL\" \/>\n<meta property=\"og:description\" content=\"SELECT lo.inst_id, s.sid, s.serial#, s.username, s.osuser, s.machine, s.program, lo.oracle_username, o.owner, o.object_name, o.object_type, CASE\" \/>\n<meta property=\"og:url\" content=\"https:\/\/oraclius.com.tr\/tr\/q1\/\" \/>\n<meta property=\"og:site_name\" content=\"oraclius\" \/>\n<meta property=\"article:published_time\" content=\"2026-03-26T13:32:14+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-27T09:30:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"YUNUS EMRE ATAY\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"YUNUS EMRE ATAY\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/\"},\"author\":{\"name\":\"YUNUS EMRE ATAY\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"headline\":\"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL\",\"datePublished\":\"2026-03-26T13:32:14+00:00\",\"dateModified\":\"2026-03-27T09:30:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/\"},\"wordCount\":480,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"image\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"articleSection\":[\"Useful-Queries\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/\",\"name\":\"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"datePublished\":\"2026-03-26T13:32:14+00:00\",\"dateModified\":\"2026-03-27T09:30:55+00:00\",\"description\":\"SELECT lo.inst_id, s.sid, s.serial#, s.username, s.osuser, s.machine, s.program, lo.oracle_username, o.owner, o.object_name, o.object_type, CASE\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/#primaryimage\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"contentUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"width\":512,\"height\":512},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/q1\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\\\/\\\/oraclius.com.tr\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#website\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/\",\"name\":\"oraclius\",\"description\":\"Linux, SQL, Oracle rehberleri ve daha fazlas\u0131 i\u00e7in oraclius.com.tr\u2019yi ziyaret edin.\",\"publisher\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\"},\"alternateName\":\"oracle\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/oraclius.com.tr\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/#\\\/schema\\\/person\\\/15e2f7b9dc977c71806301e629135e09\",\"name\":\"YUNUS EMRE ATAY\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"url\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"contentUrl\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\",\"width\":512,\"height\":512,\"caption\":\"YUNUS EMRE ATAY\"},\"logo\":{\"@id\":\"https:\\\/\\\/oraclius.com.tr\\\/wp-content\\\/uploads\\\/2024\\\/12\\\/oradb.jpeg\"},\"description\":\"oracle\",\"sameAs\":[\"https:\\\/\\\/oraclius.com.tr\",\"https:\\\/\\\/instagram.com\\\/lemratal\",\"https:\\\/\\\/linkedin.com\\\/in\\\/emreatayy\",\"https:\\\/\\\/www.youtube.com\\\/@lemratal\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL","description":"SELECT lo.inst_id, s.sid, s.serial#, s.username, s.osuser, s.machine, s.program, lo.oracle_username, o.owner, o.object_name, o.object_type, CASE","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/oraclius.com.tr\/tr\/q1\/","og_locale":"tr_TR","og_type":"article","og_title":"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL","og_description":"SELECT lo.inst_id, s.sid, s.serial#, s.username, s.osuser, s.machine, s.program, lo.oracle_username, o.owner, o.object_name, o.object_type, CASE","og_url":"https:\/\/oraclius.com.tr\/tr\/q1\/","og_site_name":"oraclius","article_published_time":"2026-03-26T13:32:14+00:00","article_modified_time":"2026-03-27T09:30:55+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","type":"image\/jpeg"}],"author":"YUNUS EMRE ATAY","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"YUNUS EMRE ATAY","Tahmini okuma s\u00fcresi":"3 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/oraclius.com.tr\/q1\/#article","isPartOf":{"@id":"https:\/\/oraclius.com.tr\/q1\/"},"author":{"name":"YUNUS EMRE ATAY","@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"headline":"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL","datePublished":"2026-03-26T13:32:14+00:00","dateModified":"2026-03-27T09:30:55+00:00","mainEntityOfPage":{"@id":"https:\/\/oraclius.com.tr\/q1\/"},"wordCount":480,"commentCount":0,"publisher":{"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"image":{"@id":"https:\/\/oraclius.com.tr\/q1\/#primaryimage"},"thumbnailUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","articleSection":["Useful-Queries"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/oraclius.com.tr\/q1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/oraclius.com.tr\/q1\/","url":"https:\/\/oraclius.com.tr\/q1\/","name":"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL","isPartOf":{"@id":"https:\/\/oraclius.com.tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/oraclius.com.tr\/q1\/#primaryimage"},"image":{"@id":"https:\/\/oraclius.com.tr\/q1\/#primaryimage"},"thumbnailUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","datePublished":"2026-03-26T13:32:14+00:00","dateModified":"2026-03-27T09:30:55+00:00","description":"SELECT lo.inst_id, s.sid, s.serial#, s.username, s.osuser, s.machine, s.program, lo.oracle_username, o.owner, o.object_name, o.object_type, CASE","breadcrumb":{"@id":"https:\/\/oraclius.com.tr\/q1\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/oraclius.com.tr\/q1\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/oraclius.com.tr\/q1\/#primaryimage","url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","contentUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","width":512,"height":512},{"@type":"BreadcrumbList","@id":"https:\/\/oraclius.com.tr\/q1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/oraclius.com.tr\/"},{"@type":"ListItem","position":2,"name":"Locklanan Objeleri ve Session\u2019lar\u0131 G\u00f6steren SQL"}]},{"@type":"WebSite","@id":"https:\/\/oraclius.com.tr\/#website","url":"https:\/\/oraclius.com.tr\/","name":"oraclius","description":"Linux, SQL, Oracle rehberleri ve daha fazlas\u0131 i\u00e7in oraclius.com.tr\u2019yi ziyaret edin.","publisher":{"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09"},"alternateName":"oracle","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/oraclius.com.tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/oraclius.com.tr\/#\/schema\/person\/15e2f7b9dc977c71806301e629135e09","name":"YUNUS EMRE ATAY","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","url":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","contentUrl":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg","width":512,"height":512,"caption":"YUNUS EMRE ATAY"},"logo":{"@id":"https:\/\/oraclius.com.tr\/wp-content\/uploads\/2024\/12\/oradb.jpeg"},"description":"oracle","sameAs":["https:\/\/oraclius.com.tr","https:\/\/instagram.com\/lemratal","https:\/\/linkedin.com\/in\/emreatayy","https:\/\/www.youtube.com\/@lemratal"]}]}},"_links":{"self":[{"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts\/834","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/comments?post=834"}],"version-history":[{"count":3,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts\/834\/revisions"}],"predecessor-version":[{"id":851,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts\/834\/revisions\/851"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/media\/55"}],"wp:attachment":[{"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/media?parent=834"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/categories?post=834"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/tags?post=834"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}