{"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"],"_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}]}}