Downloaded 22 times
Oracle Performance Tuning Training | Oracle Performance Tuning
- 1. www.oracletrainings.com Oracle Performance TuningTraining AT Oracle Trainings Email : inbox.oracletrainings@gmail.com Contact : +91 8121 020 111
- 2. www.oracletrainings.com Oracle Performance TuningTraining Course Content Overview Of Performance Tuning • Basic Concepts in Performance Tuning • Getting Start with Performance Tuning Features & Tools Designing & Developing for Performance • Oracle_Methodology • Understanding the Investment Options • Understanding the Scalability • System _Architecture • The Application Design Principles • Workload Testing, Modeling, & Implementation • Deploying the New Applications
- 3. www.oracletrainings.com The Performance ImprovementMethods • Oracle Performance Improvement Method • Emergency Performance_Methods Configuring an Database for Performance • Performance Considerations for the Initial Instance Configuration • Creating & Maintaining Tables for Good Performance • Performance Considerations for the Shared Servers Automatic Performance Statistics • Data Gathering • Overview toAutomatic Workload Repository The Automatic Performance Diagnostics • Introduction to the Database Diagnostic Monitoring • Automatic Database Diagnostic_ Monitor
- 4. www.oracletrainings.com Memory Configuration &Use • Understanding the Memory Allocation Issues • Configuring & Using the Buffer Cache • Configuring & Using the Shared Pool and Large Pool • Configuring & Using the Redo Log Buffer • PGA Memory Management I/O Configuration & Design • Understanding the I/O • The Basic I/O Configuration Understanding The Operating System Resources • Understanding The Operating System Performance Issues • Solving the Operating System Problems • Understanding Of CPU • Finding The System CPU Utilization Instance Tuning Using the Performance Views • Instance_Tuning Steps • Interpreting Of Oracle Statistics
- 5. www.oracletrainings.com • Wait EventsOf Statistics • Idle Wait_ Events Tuning_Networks • Understanding the Connection Models • Detecting the Network Problems • Solving the Network Problems • Brief Overview SQL Tuning • SQL Tuning overview • Goals of Tuning • Identifying the High-Load SQL • The Automatic SQL Tuning Features • Developing the Efficient SQL Statements The Automatic SQL Tuning • Automatic SQL Tuning • The SQL Tuning Advisor • Managing the SQL Profiles with APIs • SQL Tuning-Sets • SQL Tuning Information-Views
- 6. www.oracletrainings.com Query Optimizer • Optimizer_Operations • Choosing the Optimizer Goal • Enabling & Controlling Query Optimizer Features • Understanding Query Optimizer • Understanding the Access Paths for the Query Optimizer • Understanding of Joins Managing The Optimizer Statistics • Understanding of Statistics • The Automatic Statistics Gathering • The Manual Statistics Gathering • System _Statistics • Managing _Statistics • Viewing_Statistics Using Indexes & Clusters • Understanding the Index Performance • Using Function-based Indexes for the Performance • Using the Partitioned Indexes for Performance
- 7. www.oracletrainings.com • Using theIndex-Organized Tables for Performance • Using Bitmap- Indexes for Performance • Using Bitmap -Join Indexes for Performance • Using Domain _Indexes for Performance The Optimizer Hints • Understanding the Optimizer Hints • Using the Optimizer Hints Using Plan Stability • Using the Plan Stability to Preserve Execution Plans • Using the Plan Stability with the Query Optimizer Upgrades Using of EXPLAIN PLAN • Understanding the EXPLAIN PLAN • The PLAN_TABLE O/p Table • Running of an EXPLAIN PLAN
- 8. www.oracletrainings.com • Displaying AnPLAN_TABLE Output • Reading of EXPLAIN PLAN Output • Viewing of Parallel Execution with EXPLAIN PLAN • Viewing the Bitmap Indexes with EXPLAIN PLAN • Viewing the Partitioned Objects with EXPLAIN PLAN Using Application Tracing_Tools • End to End Application _Tracing • Using the trcsess- Utility • Understanding the SQL Trace & TKPROF • Using the SQL Trace Facility & TKPROF • Avoiding Pitfalls in the TKPROF Interpretation • Sample TKPROF O/P
- 9. www.oracletrainings.com Please Like UsOn Facebook : https://www.facebook.com/oracleonlinetraining LinkedIn : https://www.linkedin.com/in/oracletrainings Twitter : https://twitter.com/oracletrainigs
- 10.