Is any doc/white paper available for routine database maintenance tasks (specific to datawarehousing database).
Any help would be greatly appreciated.
Thanks
Printable View
Is any doc/white paper available for routine database maintenance tasks (specific to datawarehousing database).
Any help would be greatly appreciated.
Thanks
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.. ;)
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)