Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Saturday, 26 December 2015

Highest Time taken to Manage Full and Incremental Backup

select rownum as rank
       , DECODE(backup_type,'D','Full','I','Incremental'
           ,'L','Archive Log',backup_type) backup_type
       ,round(max_secs/60) mins
FROM ( select name , backup_type , max(elapsed_seconds)  max_secs
     from rc_backup_set bs, rc_database d
     where bs.db_key = d.db_key
     group by name, backup_type
     order by max(elapsed_seconds) desc
WHERE rownum <= 10
order by backup_type;

Note: This is the highest time taken to complete a full and incremental backup. it is not the
average time to accomplish the backup. The highest time for a backup can be any reason for a particular day backup. Always consider the average time for a backup.


  1. wow really nice posts i wanna thank you for this. Definitely it will be useful. Thank you for the posts and please keep update like this.

    digital marketing training Chennai

  2. This is valuable information , i so really very impressed after refer that post.
    It is very useful for me.
    iOS Training in Chennai

  3. Really amazing and this was much impressive and thank you for updating like this with this site. Thank you for updating.

    Web Designing Training in Chennai

  4. ARINET DBA Services is a Chicago, IL based association set up in 2013. Uniting over 100+ years of consolidated contribution in giving quality Oracle database Support organizations to American associations, we've given the assorted alternatives about remote dba aces, remote dba associations, remote dba strengthen, database administration, prophet remote, dba remote, database affiliation, prophet dba fortify, Oracle sponsorship and Oracle Consultants.

  5. Database means to maintain and organize all the files in a systematic format where the data can be easily accessible when needed.
    Oracle DBA training in chennai | Oracle training in chennai | Oracle course in Chennai

  6. Nice Article It Is... Well defined

    Thanks for sharing with us!!!

    Visit Below link to learn Oracle DBA..

  7. Great post! I am actually getting ready to across this information, It's very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.

    ccna training in chennai saidapet

  8. nice blog too informative. looking and reading your points its so impressive. doing more blog like this. i really appreciated doing like this.
    PHP Training Institute in Chennai


  9. I feel happy about and I really like this learning more about this topic. keep sharing your information regularly for my future reference.

    SEO Training Institute in Chennai

  10. I just want to say I’m new to blogs and seriously loved this web site. Probably I’m likely to bookmark your blog post . You really have great stories. Regards for revealing your web site.

    Web development company in Chennai

  11. your information is really nice and it is very much interesting as well as i got more information from your blog i like this blog.

    cognos Training in Chennai

  12. I like your blog it is really interesting , thus this blog is nice and very well done , i like your ideas it is really mind blowing thus it is very much interesting too.

    Informatica Training in Chennai

  13. These blogs are really very well done and it is good to hear those things it is very much interesting too, as i cam to know many things about your blog.

    cognos Training in Chennai

  14. Superb Blog. I really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your updation.
    Oracle Training Institute in chennai

  15. Hi…
    Thank you for Sharing this useful Blog.
    I think it is very helpful to who are ready to learn or start their career with Oracle DBA.

  16. This article information was so nice. Which is very much useful for me and impressed by reading. Oracle DBA Online Training Videos

  17. Such a great articles in my carrier, It's wonderful commands like easiest understand words of knowledge in information's.

    digital marketing company in chennai
    seo company in chennai

  18. DEAR SIR,
    Which operating system use in company for database

    like linux,unix or window

  19. Thanks for the post for online training on Oracle DBA visit tekslate.

  20. This is a great post. I like this topic.This site has lots of advantage. It helps me in many ways.Thanks for posting this again.
    Back to original

  21. This post is really nice and informative. The explanation given is really comprehensive and informative..
    PHP Training in Chennai

  22. wow really superb you had posted one nice information through this. Definitely it will be useful for many people. So please keep update like this.

    SEO Company in India

  23. Awesome resources!
    Thanks for sharing such good article.

    Current Job opening

  24. Great post.
    It really helped me to learn something new. So thanks.
    Best software company in Bangalore

  25. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.

    Best Implant Clinic In Chennai

  26. Superb i really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.

    Base SAS Training in Chennai

  27. A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.

    Best Dental Clinic In Tambaram

  28. This content creates a new hope and inspiration with in me. Thanks for sharing article like this. The way you have stated everything above is quite awesome. Keep blogging like this. Thanks.

    Base SAS Training in Chennai

  29. Hi,
    This article information was so nice and informative . Which is very much useful for me and the way you presented is very simple and impressive .
    Thank you.

  30. Awesome resources!
    Thanks for sharing such good article. This is really helpful.

    Vintage Tiles
    Rustic Tiles
    Mosaic Tiles

  31. Hi,
    This is valuable blog.Thanks for sharing such a nice article.keep posting this.
    oracle fusion SCM online training

  32. Hi,
    this is very interesting topic.
    Thanks for sharing such a nice topic.
    oracle fusion hCM online training

  33. I just floundered simultaneous your blog and wanted to say that I have really liked reading your blog posts. Anyway, I’ll be subscribing to your provisions and I hope you post again soon.
    Digital Marketing Course in Chennai
    Best Digital Marketing Training in Chennai
    SEO Training Institute

  34. Excellent Blog very imperative good content, this article is useful to beginners and real time
    employees.Thank u for sharing...
    Oracle ADF Online Training
    Oracle DBA Online Training
    Oracle APPS Online Training


  35. Wonderful blog.. Thanks for sharing informative Post. Its very useful to me.

    Installment loans
    Payday loans
    Title loans

  36. Nice blog. Really helpful information about Oracle …. Please keep update some more…………

  37. Good content in this post and site. We need more fresh and good content like this.Thanks for posting great stuff it’s very useful to me.

    Oracle Fusion financial


  38. Really Good blog post.provided a helpful information.I hope that you will post more updates like this.
    Digital marketing company in Chennai

  39. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic.

    Pawn Shop

    Pawn Loans

    Pawn Shops

    Pawn Loan

    Pawn Shop near me

  40. Really nice blog!goood information.Thanks for sharing

    Oracle Weblogic Server Training

  41. Really Useful Information, I am following this blog from the past three months and i had an Urgent care Service In Us And learnt A lot From the blog posts.i just want to say thank for the blog.really thanks For Sharing.

  42. It's A Great Pleasure reading your Article Bala Guntipalli Thanks for posting.

  43. Really A great informative blog post this blog provides only valuable information on Salesforce Certification Training.Thanks For Sharing.