ResponsiblyForecastingOracleSystemPerformance分析.pptVIP

ResponsiblyForecasting Oracle System Performance Presentation Objectives What is Oracle performance management. Know an industry standard methodology. Know about many proven models. How to begin using forecasting in your daily routine. Where to go from here. What is performance management? What is management? For a DBA, PM is both reactive and proactive. Reactive: It’s were most DBAs live. Is what we have been taught to do. Proactive: It’s where DBAs must learn and live. Forecasting is a significant part of PPM. It’s not as difficult as you might think. We must forecast methodically. We desire reproducible consistency. Without method there is chaos. With too much method, creativity is halted. Forecasting is a scientific thing, therefore we should be able to develop a method. There are many different methods. The project plan, if there is one, should embrace and enhance our method. Methodically forecasting performance Determine the “study question.” Characterize the workload. Develop the appropriate model. Validate the forecast forecast. Forecast! Determine the “study question” Each project has a fundamental question that needs answering. For example: Can the system handle the load six months from now? Will response time significantly change if we add five more CPUs? How many CPUs and IO devices do we need to keep people happy? Write it down. Get everyone to agree to it…over and over again. Characterize the workload Objective: To capture the most relevant characteristics of the real or proposed workload. Workload characterisation is simply segmenting and linking processes by common characteristics. (e.g., time of operation, CPU requirements, calls, hits, etc.) It is important because before any analysis or forecasts can be made, the workload must be understood. You can’t ask about something if you don’t know anything about it. A “capacity planning” tool must allow for flexible characterisation of the workload. Forecast model development. Every f