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

Thread: Performance Issues

  1. 07-07-2003, 12:22 PM #1
    DMstreet
    DMstreet is offline Junior Member
    Join Date
    Jun 2003
    Location
    London, UK
    Posts
    8

    Performance Issues

    Question

    What are the performance issues to look out for when loading data into the database at intervals during the day into a production database.

    Assuming am using SQL*Loader or Import utility.

    What are the alternatives apart from the obvious loading data at the end of business.
    Reply With Quote Reply With Quote
  2. 07-07-2003, 04:54 PM #2
    irehman
    irehman is offline Senior Member
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    Depends on the amount of data, constraints on the tables, and number of users connected, it is not a good practise to load large chunck of data into production during normal business hours.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width