Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2004
    Posts
    24

    Unanswered: impact on internet response time if the batch running on oracle database

    Hi:

    I have an extract batch scheduled that runs daily from 8 pm to 8:15 pm and extracts all ddl's of database objects (Only limited to Procedures, Functions, Triggers & Packages) on ORACLE server.

    I am wondering, if any of internet applications are running on that database, how would be the impact on internet response time?

    I would be glad to know, If anyone has the answer.

    Thanks in advance, Madhavi.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >If anyone has the answer.
    It depends upon details which you neglected to provide.
    What's preventing YOU from measuring actual response time before during & after the batch job runs?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Aug 2004
    Posts
    24
    I have no authorization to do all those tests. Thus, I have no details to provide. I am only responsible for documenting it. I was expecting a general answer that someone sure (oracle experts) could have an idea on this.

    Thanks anyway, Madhavi.

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Its impossible to quantify as it depends on what your users are doing, how many there are, your network, your server, your os and finally your database. The only way to find out is to have some sort of metric you can get your DBAs to measure while doing the job.

    Alan

  5. #5
    Join Date
    Aug 2004
    Posts
    24
    Thanks!

    What you said is right.

    Madhavi.

Posting Permissions

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