tailieunhanh - Workshop Overview

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 | Workshop Overview 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 interactive Intensive hands-on diagnosis and problem resolution Proactive participant involvement Approach to Workshop Group-Oriented and Interactive The workshop is structured to enable groups of individuals to work together to perform tuning diagnostics and resolution. Each group is encouraged to share its tuning diagnostic and resolution approach with other groups in the class. Intensive Hands-On Diagnosis and Problem Resolution The intent is to provide you with as much hands-on experience as possible to diagnose and work through a performance tuning methodology, diagnosis, and resolution. The experience and knowledge gained from the first four days of this course play a major role | Workshop Overview 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 interactive Intensive hands-on diagnosis and problem resolution Proactive participant involvement Approach to Workshop Group-Oriented and Interactive The workshop is structured to enable groups of individuals to work together to perform tuning diagnostics and resolution. Each group is encouraged to share its tuning diagnostic and resolution approach with other groups in the class. Intensive Hands-On Diagnosis and Problem Resolution The intent is to provide you with as much hands-on experience as possible to diagnose and work through a performance tuning methodology, diagnosis, and resolution. The experience and knowledge gained from the first four days of this course play a major role in successfully completing the workshop. Company Information Small startup company 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 Company Information Present Situation The company has two OLTP type users and two DSS types. The system was set up by a trainee DBA and, though it works, the performance is not acceptable. The company rents space on a Sun server which it shares with 10 other companies. Due to this there is a requirement that resources used be kept to a minimum. Future Goals At present the company has 4 employees. The company is expanding and is expected to have 20 concurrent database users. You have been invited in to get the system ready for the new workload. It is expected that there will be 10 of each type of user. After collecting the statistics that you think are necessary, implement whatever database