Search

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
       ,name
       , 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.

52 comments:

  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

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

    ReplyDelete
  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

    ReplyDelete
  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.

    ReplyDelete
  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

    ReplyDelete
  6. Nice Article It Is... Well defined

    Thanks for sharing with us!!!

    Visit Below link to learn Oracle DBA..

    http://tekclasses.in/

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete

  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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

    ReplyDelete
  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.

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

    ReplyDelete
  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

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

    like linux,unix or window

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

    ReplyDelete
  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

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

    ReplyDelete
  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

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

    Current Job opening

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

    ReplyDelete
  25. wow really nice. It will be helpful for the people those who are ready to crack the interview and please also for remind what they have learned throughout concept.

    Best Dental Clinic In Adyar

    ReplyDelete
  26. 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

    ReplyDelete
  27. 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

    ReplyDelete
  28. 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

    ReplyDelete
  29. 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

    ReplyDelete
  30. 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.

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

    Vintage Tiles
    Rustic Tiles
    Mosaic Tiles

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

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

    ReplyDelete
  34. 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

    ReplyDelete
  35. 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

    ReplyDelete


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

    Installment loans
    Payday loans
    Title loans

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

    ReplyDelete