Oracle DBA Monthly Procedures Checklist


Oracle DBA Monthly Procedures Checklist

A.  Look for Harmful Growth Rates

1.   Review changes in segment growth when compared to previous reports to identify segments with a harmful growth rate.

B.  Review Tuning Opportunities

1.   Review common Oracle tuning points such as cache hit ratio, latch contention, and other points dealing with memory management.  Compare with past reports to identify harmful trends or determine impact of recent tuning adjustments.

C.  Look for I/O Contention

1.   Review database file activity.  Compare to past output to identify trends that could lead to possible contention.

D.  Review Fragmentation

1.   Investigate fragmentation (e.g. row chaining, etc.).

E.  Project Performance into the Future

1.   Compare reports on CPU, memory, network, and disk utilization from both Oracle and the operating system to identify trends that could lead to contention for any one of these resources in the near future.

2.   Compare performance trends to Service Level Agreement to see when the system will go out of bounds

F.   Perform Tuning and Maintenance

1.   Make the adjustments necessary to avoid contention for system resources.  This may include scheduled down time or request for additional resources.

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...