DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Dataloads in 2 different boxes

  1. #1
    Join Date
    Jul 2003
    Location
    Cincinnati
    Posts
    68

    Dataloads in 2 different boxes

    Hi..

    I have users complaining about an QA and Dev environment dataloads. They are using SQL loader to load and QA box is taking 2.5 hrs where as the DEV is taking only 1 hour for 250K records.. [only an example]

    I want to know where to start and what are the ways to monitor such loads as they happen midnight everyday. Stuff like statspack are snapshots at 2 different timings, but they might not help me here.. Let me know, what should be my plan of action.

    Thanks, ST2003

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    why is statspack of no use to you?
    I'm stmontgo and I approve of this message

  3. #3
    Join Date
    Jul 2003
    Location
    Cincinnati
    Posts
    68
    The amount of data is same between the loads of 2 boxes. Which part of statspack will tell me, which execution took how long? Should I run this at the beginning of the load and at the end of the load or how? Secondly, what should I monitor while this gets executed?
    Thx, ST2003
    ~

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