Here is a query to V$SESSION_LONGOPS view that shows the status of RMAN sessions. It also calculates the percentage of the job that has been completed.

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE" FROM V$SESSION_LONGOPS WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%' AND TOTALWORK != 0 AND SOFAR <> TOTALWORK;

Sample Output:

SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE
--- ---------- ---------- ------ ---------- ----------
18 11 1 1995623 3083904 64.71
15 11 1 1863491 3599872 51.77
14 11 1 1936968 3339904 57.99
16 11 1 1843544 3083904 59.78

7 Responses so far.

  1. Sravani says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion HCM Online Training

  2. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Online Training

  3. Santhosh says:

    I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion SCM Online Training

  4. harsha says:

    Really thanks for sharing such a wonderful blog.
    Oracle Fusion Financials Online Training

  5. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

  6. Thank you for sharing such a nice and interesting blog and really very helpful article

    Oracle Fusion SCM Online Training

  7. Awesome post. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion Financials Online Training

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -