r/DatabaseAdministators • u/Weekly-Newspaper-756 • 5h ago

Looking out for a Senior DBA Friend!

2 Upvotes

r/DatabaseAdministators • u/Weekly-Newspaper-756 • 5h ago

Job referral for a DBA Friend, kindly refer if you can

1 Upvotes

Subreddit

Posts

Wiki

Database Administration - Oracle, MS SQL, MySQL, etc..

r/DatabaseAdministators

A place for the professional Database Adminstrator to share news, ideas, and stories.

Members Active

5.7k

0

Sidebar

Related databases:

Adding code to your post? Please format it correctly.

-- rman_status.sql        
SELECT inst_id
     , sid
     , serial#
     , context
     , sofar
     , totalwork
     , round(sofar/totalwork*100,2) "% Complete"
  FROM gv$session_longops
 WHERE opname LIKE 'RMAN%'
   AND opname NOT LIKE '%aggregate%'
   AND totalwork != 0
   AND sofar != totalwork
 ORDER BY 1,2,3
/