oracle 巡检 健康检查模版.doc

Oracle DB Healthcheck Report XXXXX（CHINA）Ltd. Document information Service Name: Oracle HealthCheck Report Supporting Engineer: Document Version: 1．0 Service Phrase: ，200Document Version Date: 19 7 , 2009 Author: Prepared Date: 19 7 , 2009 Reviewer: Review Date: Accept List acceptor Aim date TEL/DAX: Revision History Version: Version Date: Revisor: Description.: File Name: 1.0 19 7, 2009 Bryan Miao Draft oracle HealthCheckdoc notice The report doesn’t represent any official standpoint. It is only used to discuss technological information.  Contents Chapter 1 Document IXSDoduction 4 1.1 Aim of the Document 4 1.2 Maintenance 4 1.3 Owner of the Document 4 Chapter 2 Service IXSDoduction 5 2.1 Aim of Service 5 2.2 Service Staff 5 2.3 Items to be Checked 5 2.4 summary of check-up 6 Chapter 3 Configuration information of system and database 6 3.1. Configuration of host and OS 7 3.2. Database configuration 8 3.3. system wait event 28 3.4. Net8 configuration 28 Chapter 4 System availability 31 4.1. BACKUP 31 4.2. RESTORE 31 4.3. DB monitor 31 Chapter 5 SYSTEM INTEGRITY 34 5.1 POLICY OF SECURUTY 34 Chapter 6 SYSTEM PERFORMENCE 35 6.1. OS PERFORMANCE INFO 35 6.2. DB PERFORMANCE 38 6.3. Other info（lock, enqueue, latch） 40 CHAPTER 7 APPENDIX 40 7.1 ORACLE DATABASE STATSPACK RESPORT 40  Chapter 1 Document IXSDoduction Aim of the Document Oracle database health check-up is the important part of the integrated services supported by XX China. The aim of the document is to confirm the content and effect of the database health check and to help the XXXXX to know the current condition of the database. Maintenance The report of the health check-up service will be created by the engineers of XXX China after the check is completed, and will be submitted to the XXXXX. Owner of the Document If you have any questions or suggestions to the document, please contact Ji Lei, who is the engineers of the XXX China.  Chapt