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