Is any doc/white paper available for routine database maintenance tasks (specific to datawarehousing database).
Any help would be greatly appreciated.
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..
"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"
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.
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)
Click Here to Expand Forum to Full Width