oracle入门课程ocp教程les20.pdfVIP

Objectives After completing this lesson, you should be able to do the following: • Use the Oracle tuning methodology to diagnose and resolve performance problems • Use Oracle tools to diagnose performance problems • Understand the goals of the workshop Approach to Workshop • Group-oriented and in ctive • Intensive hands-on diagnosis and problem resolution • Proactive particip volvement Information • Small startup – Shares a Sun server with 10 other companies – Presently has four employees that use the database • Looking to expand shortly to 20 database users • System was set up by a part-time trainee DBA • System performance is very slow Physical Workshop Configuration Each account is set up in the following manner: • All workshop files are located in E:\Labs\Wkshop • All the data files are located at E:\ORANT\ORA92\ORADATA\ORCL • The E:\ORANT\ORA92\ADMIN\ORCL\BDUM directory is used for instance-specific trace files. Workshop Database Configuration • The database consists of a sample schema. • Users log in as oltp or dss depending on the nature of their work. • End users have access to sample schema objects. • There are seven tablespaces: system, undotbs, temp, users, indx, sample, tools. • The DBA account is system/oracle. • The sys account is sys/oracle. Workshop Procedure 1. Choose a scenario. 2. Create a Statspack report. 3. Run the workload generator. 4. Create a Statspack report. 5. Determine what changes should take ce. 6. Implement the changes. 7. Return to the second step to check that the changes have made an improvement. 8. When the changes have improved performance, choose another scenario.