Re: Oracle Data Warehouse

>>>>> "RBarber" == Rick Barber <RBarber_at_tor.lgs.ca> writes:

    RBarber> There will be a total user population of about 50 - 100     RBarber> online users during the day.

    RBarber> 1) how do I perform a backup in a reasonable period of

If all of the inserts and deletes happen at night, then you can do a hot backup of the tablespaces when the inserts/deletes are finished. The backup will not interfere with read-only access to your tablespaces. If that takes too long, then consider backing up your tablespaces weekly (assuming that it will be practical during the weekend) and and back up your archive logs daily.

    RBarber> time? 2) With all of the insert and delete activity how     RBarber> will I be able to do the reorgs that are necessary?

The best advice I can give you is to try to avoid having to do reorgs. One of the reasons for doing a reorg is because of a fragmented tablespace. Fragmentation can be avoided by organizing your tablespaces so that all segments are the same size. To do this, be sure that all of the objects in your tablespaces have the same value for their next parameter and that pctincrease is zero. You will probably wind up with a number of tablespaces this way.

    RBarber> 3) how can I do the nightly batch on time?

You will need to be sure that your hardware configuration has sufficient capacity. You will also need to spend some time (possibly weeks) tuning the database and the insert/delete process. If you wish do discuss details of how to do this, it might be most appropriate to send me a private communication.

-- 
==============================
Mark Grand              Voicemail: 1-800-RAPID60
RSSI