Friday, April 15, 2011

Things you should know while you perform Database Health Check

OS:

No of CPU.
Memory.
Swap.
TMP.
User Profile.
Kernel Parameters.
OS patches.
OS Watcher.
iostat.
vmstat.
top.


Database:

AWR Reports/Stats Pack/ADDM/ASH.
Redo Switch Time/Redo Groups.
Redo Should'nt be on RAID 5.
Redo, Controlfile,dbfiles should not be on same mount point.
Data files and indexes should be separate.
Locate all important objects of important users.
System Architecture 32/64 bit.
db user default profile.
SGA.
Datafile and Segment |Shrinkig.

No comments:

Post a Comment