{"id":952,"date":"2024-12-27T19:47:44","date_gmt":"2024-12-27T19:47:44","guid":{"rendered":"https:\/\/w3buddy.com\/?p=952"},"modified":"2026-01-15T13:15:51","modified_gmt":"2026-01-15T07:45:51","slug":"monitor-long-operations-in-oracle","status":"publish","type":"post","link":"https:\/\/w3buddy.com\/blog\/monitor-long-operations-in-oracle\/","title":{"rendered":"Monitor Long Operations in Oracle"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Use the following script (<strong>@longops.sql<\/strong>) to monitor long-running operations in Oracle:<\/p>\n\n\n\n<pre class=\"wp-block-prismatic-blocks\"><code class=\"language-sql\">COLUMN sid FORMAT 9999\nCOLUMN serial# FORMAT 9999999\nCOLUMN machine FORMAT A30\nCOLUMN progress_pct FORMAT 99999999.00\nCOLUMN elapsed FORMAT A10\nCOLUMN remaining FORMAT A10\n\nSELECT s.sid,\n       s.serial#,\n       s.machine,\n       ROUND(sl.elapsed_seconds\/60) || ':' || MOD(sl.elapsed_seconds,60) elapsed,\n       ROUND(sl.time_remaining\/60) || ':' || MOD(sl.time_remaining,60) remaining,\n       ROUND(sl.sofar\/sl.totalwork*100, 2) progress_pct\nFROM   v$session s,\n       v$session_longops sl\nWHERE  s.sid     = sl.sid\nAND    s.serial# = sl.serial#;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">This script provides real-time details on session progress, elapsed time, and remaining time for long-running operations.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use the following script (@longops.sql) to monitor long-running operations in Oracle: This script provides real-time details on session progress, elapsed time, and remaining time for long-running operations.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAowu461DA:productID":"","footnotes":""},"categories":[1225],"tags":[],"class_list":["post-952","post","type-post","status-publish","format-standard","hentry","category-database"],"_links":{"self":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/comments?post=952"}],"version-history":[{"count":1,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/952\/revisions"}],"predecessor-version":[{"id":953,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/posts\/952\/revisions\/953"}],"wp:attachment":[{"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/media?parent=952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/categories?post=952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/w3buddy.com\/blog\/wp-json\/wp\/v2\/tags?post=952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}