Export overhead
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Export overhead

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    62
    Hello,

    I am doing the production full database export with consistent=Y option 2:00 am everyday and It only takes about 15 minutes. the size of file is after gzipping only less than 15 M.

    Our system administrator asked me to change backup time to 11:00 pm.

    I wonder what kind of overhead is related to export process in the database level?
    I prefer 2:00 am to 11:00pm, since less people is connected to the database.

    Could anybody can answer this for me?

  2. #2
    Join Date
    Nov 2000
    Location
    Atlanta, GA, USA
    Posts
    85
    How long does the export take? I'm assuming it's taking less than 5 minutes for a dump of 15 meg compressed. If this is correct, my opinion is that it will not make any difference whether you do it at 2am or 11:pm .

  3. #3
    Join Date
    Nov 2000
    Posts
    62
    You are right. it takes 2 or 3 minutes.
    I already chaged cronjob to 11:00 pm.

    What if it takes 30 or more?

    Thanks.


  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    If people are working at 11pm, then you may want to consider using the option --> consistent=y for the export.

  5. #5
    Join Date
    Nov 2000
    Posts
    62
    I already export data using consistent=y option.
    Anyway, Thank you for the help.

  6. #6
    Join Date
    Jun 2000
    Posts
    104
    hello,
    I export at 2:00 pm and 9:00 pm and I see it takes -40 min at 2:00 and 10 min at 9:00 .whats the possible cause??
    no.of users at 9:00 pm as 0 and 2:00 pm users 15.

  7. #7
    Join Date
    Nov 2000
    Posts
    62
    Wow, That is very interesting.

    I don't really know, but I guess that your Operating System resource is shared by many other processes at 9:00 , so it takes too long.
    If you find why please let me know.
    I will search the answer by myself.


  8. #8
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    drishti,
    If you are EXPORTing with consistent=Y then Export time will vary a lot with the number of users doing transactions because a lot of rollback info is used to make it consistent.

    - Rajeev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width