{"id":852,"date":"2026-03-27T09:22:54","date_gmt":"2026-03-27T06:22:54","guid":{"rendered":"https:\/\/oraclius.com.tr\/?p=852"},"modified":"2026-08-06T09:27:56","modified_gmt":"2026-08-06T06:27:56","slug":"rollback-object-bilgisi-sql","status":"publish","type":"post","link":"https:\/\/oraclius.com.tr\/tr\/rollback-object-bilgisi-sql\/","title":{"rendered":"Rollback + Object Bilgisi SQL"},"content":{"rendered":"\n<pre class=\"wp-block-code\"><code>SELECT \n    s.inst_id,\n    s.sid,\n    s.serial#,\n    s.username,\n    s.osuser,\n    s.machine,\n    s.program,\n\n    -- Transaction\n    t.xidusn,\n    t.used_ublk,\n    ROUND(t.used_ublk * p.value \/ 1024 \/ 1024, 2) AS undo_mb,\n\n    -- Session durumu\n    s.status,\n    s.state,\n    s.event,\n    s.seconds_in_wait,\n    s.last_call_et,\n\n    -- SQL bilgisi\n    s.sql_id,\n    q.sql_text,\n\n    -- Object bilgisi (tahmini)\n    o.owner,\n    o.object_name,\n    o.object_type,\n\n    CASE \n        WHEN s.event LIKE 'undo%' OR s.event LIKE '%rollback%'\n        THEN 'ROLLBACK'\n        ELSE 'ACTIVE'\n    END AS transaction_state\n\nFROM gv$session s\nJOIN gv$transaction t \n    ON s.saddr = t.ses_addr\n   AND s.inst_id = t.inst_id\n\nLEFT JOIN gv$sql q \n    ON s.sql_id = q.sql_id\n   AND s.inst_id = q.inst_id\n\nLEFT JOIN dba_objects o \n    ON q.sql_text LIKE '%' || o.object_name || '%'\n\nJOIN gv$parameter p \n    ON p.name = 'db_block_size'\n   AND p.inst_id = s.inst_id\n\nORDER BY t.used_ublk DESC;<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"","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-852","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\/852","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=852"}],"version-history":[{"count":1,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts\/852\/revisions"}],"predecessor-version":[{"id":853,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/posts\/852\/revisions\/853"}],"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=852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/categories?post=852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oraclius.com.tr\/tr\/wp-json\/wp\/v2\/tags?post=852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}