I have previously introducedExplain Oracle Database Administrator's weekly responsibilities,Explain the daily task responsibilities of the Oracle Database AdministratorNext, we will introduce the monthly responsibilities and daily management of Oracle Database administrators ".
Monthly work
(1). Analyze Tables/Indexes/Cluster
Analyze table estimate statistics sample 50 percent;
(2). Check the table space fragments.
Analyze database fragmentation Based on weekly checks this month and find the corresponding solution
(3). Seek opportunities for database performance Adjustment
Compare daily monitoring reports on database performance and determine whether it is necessary to adjust database performance
(4). database performance Adjustment
Adjust the performance if necessary
(5) propose the next space management plan
Based on weekly monitoring, this paper proposes an improvement method for space management.
Routine Oracle DBA management
Objective: This document provides detailed information on the results of daily, monthly, and annual running of one or more ORACLE databases and their inspection results, in the appendix of the document, you will see all the check, modified SQL and PL/SQL code.
Directory
1. Routine Maintenance Procedures
A. Check all started instances
B. Search for some new warning logs
C. Check whether DBSNMP is running
D. Check whether the database backup is correct
E. Check whether the files backed up to the tape are correct.
F. Check whether the database performance is normal and reasonable, and whether there is sufficient space and resources.
G. Copy the document logs to the backup database.
H. Read the DBA user manual frequently.
2. Night Maintenance Program
A. Collect VOLUMETRIC Data
3. weekly maintenance
A. Find the objects that break the rules.
B. check whether any security policy violations occur.
C. view the SQL * NET log of the error location
D. archive all warning logs
E. Visit the supplier's home page frequently.
4. Monthly Maintenance Program
A. view the growth rate that harms the database
B. Review previous database optimization performance adjustments
C. view the I/O screen neck issues
D. Review FRAGMENTATION
E. Future execution plan
F. View adjustment points and Maintenance
- Two processes that are easily overlooked in Oracle databases
- Oracle Database Structure Overview
- How to manage Oracle databases