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

Thread: Datawarehousing-Maintenance

  1. #1
    Join Date
    Sep 2003
    Posts
    19

    Datawarehousing-Maintenance

    Is any doc/white paper available for routine database maintenance tasks (specific to datawarehousing database).
    Any help would be greatly appreciated.
    Thanks
    Preeti

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    define for yourself some routine jobs/tasks (as a DBA u shud be able to)

    slimdave's comments will be perfect as he now calls himself a DW Engg..
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Erm ... nothing special really. Watch the buffer cache advices now and then, watch CPU usage, watch i/o load. everything else is just standard stuff.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Mar 2002
    Posts
    534
    Check the V$ views related to the PGA Memory.
    Check IOs of Temp tablespace (until begining of this week nobody seemd to be aware that it was by far, the most IO charged tbs in our DWH)

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