{"id":4128,"date":"2022-05-19T10:10:09","date_gmt":"2022-05-19T09:10:09","guid":{"rendered":"https:\/\/republify.se\/?post_type=product&p=4128"},"modified":"2025-09-17T09:30:31","modified_gmt":"2025-09-17T08:30:31","slug":"oracle-database-performance-management-and-tuning","status":"publish","type":"product","link":"https:\/\/republify.se\/index.php\/produkt\/oracle-database-performance-management-and-tuning\/","title":{"rendered":"Oracle Database: Performance Management and Tuning"},"content":{"rendered":"

Overview<\/strong><\/p>\n

\n
\n
    \n
  • Use the Oracle tuning methodology<\/li>\n
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues<\/li>\n
  • Use database advisors to proactively correct performance problems<\/li>\n
  • Identify problem SQL statements<\/li>\n
  • Tune SQL performance problems<\/li>\n
  • Monitor instance performance by using Enterprise Manager<\/li>\n
  • Tune instance components by primarily using instance parameter<\/li>\n<\/ul>\n<\/div>\n<\/div>\n

     <\/p>\n

    \n
    \n
    \n

    Audience<\/h4>\n
      \n
    • Administrator<\/li>\n
    • Database Administrator<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n
      \n

      <\/h3>\n

      Prerequisites<\/h3>\n
      \n
      \n
      Suggested Prerequisite<\/div>\n
        \n
      • Oracle Database: Install and Upgrade Workshop<\/li>\n
      • Familiarity with Oracle Database installation<\/li>\n
      • Familiarity with Oracle Database configuration concepts<\/li>\n<\/ul>\n
        <\/div>\n
        Required Prerequisite<\/div>\n
          \n
        • Oracle Database: Administration Workshop<\/li>\n
        • Basic knowledge of Linux operating system<\/li>\n
        • A working knowledge of SQL and PL\/SQL packages<\/li>\n
        • Basic understanding of Oracle Database architecture<\/li>\n
        • Familiarity with basic database monitoring procedures<\/li>\n<\/ul>\n

           <\/p>\n<\/div>\n<\/div>\n<\/div>\n

          \n

          Delegates will learn how to<\/h3>\n
          \n
          \n
            \n
          • Describe Performance Management<\/li>\n
          • Use AWR Performance Statistics<\/li>\n
          • Use AWR Based Tools<\/li>\n
          • Improve SQL Statement Performance<\/li>\n
          • Influence the Optimizer<\/li>\n
          • Use Tuning Analyzers and Advisors<\/li>\n
          • Monitor Operations and applications<\/li>\n
          • Manage Database Memory<\/li>\n
          • Use In-Memory Column Store Feature<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n
            \n

            Outline<\/h2>\n
            \n
            \n

            Overview & Preparing the Databases<\/p>\n

              \n
            • Defining the Scope of Performance Issues, Tuning Life Cycle Phases and Using Enterprise Manager to Identify OS Issues<\/li>\n
            • Using the Time Model to Diagnose Performance Issues<\/li>\n
            • Using Statistics and Wait Events to Diagnose Performance Issues<\/li>\n
            • Using Log and Trace Files to Monitor Performance<\/li>\n
            • Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance<\/li>\n
            • Using Statspack to View Performance Data: Installing Statspack, Creating Snapshots and Generating Statspack Reports<\/li>\n
            • Using Automatic Workload Repository<\/li>\n
            • Setting Up and Viewing Server-Generated Alerts<\/li>\n
            • Using Baselines<\/li>\n
            • Configuring and Managing Automated Maintenance Tasks<\/li>\n
            • Using ADDM to Analyze Performance and AWR-Based Tools to Identify Performance Issues<\/li>\n
            • Using Active Session History Data for First Fault System Analysis and Generating and Reviewing an ASH Report to Identify Performance Issues<\/li>\n
            • Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues<\/li>\n<\/ul>\n

              Overview of SQL Statement Processing<\/p>\n

                \n
              • Maintaining Indexes<\/li>\n
              • Maintaining Tables: Block Space Management, Shrinking Segments, Advanced Index Compression, Analyzing the Impact of Excess Blocks<\/li>\n
              • Introduction to Query Optimizer and Using Initialization Parameters to Control Optimizer Behavior<\/li>\n
              • Understanding Execution Plans, Using AUTOTRACE and EXPLAIN PLAN<\/li>\n
              • Viewing Execution Plans by Using SQL Trace and the TKPROF Utility<\/li>\n
              • Managing Optimizer Statistics<\/li>\n
              • Using Automatic SQL Tuning<\/li>\n
              • Using the SQL Plan Management Feature<\/li>\n<\/ul>\n

                Overview of the SQL Advisors<\/p>\n

                  \n
                • Using the SQL Tuning Advisor and SQL Access Advisor to Improve SQL Performance<\/li>\n<\/ul>\n

                  Overview of Real Application Testing Components<\/p>\n

                    \n
                  • Using SQL Performance Analyzer to Determine the Impact of Changes<\/li>\n
                  • Using Database Replay to Test System Performance<\/li>\n
                  • Implementing Real-Time Database Operation Monitoring<\/li>\n
                  • Using Services to Monitor Applications<\/li>\n<\/ul>\n

                    Overview of Memory Structures<\/p>\n

                      \n
                    • Managing Shared Pool Performance<\/li>\n
                    • Managing Buffer Cache Performance<\/li>\n
                    • Managing PGA and Temporary Space Performance<\/li>\n
                    • Configuring the Large Pool<\/li>\n
                    • Using Automatic Shared Memory Management<\/li>\n
                    • Introduction to In-Memory Column Store<\/li>\n
                    • Configuring the In-Memory Column Store Feature<\/li>\n
                    • Using the In-Memory Column Store Feature to Improve SQL Performance<\/li>\n
                    • Using In-Memory Column Store with Oracle Database Features<\/li>\n<\/ul>\n

                       <\/p>\n<\/div>\n<\/div>\n<\/div>\n

                      Kursen levereras i samarbete med<\/h3>\n

                      \"\"<\/p>\n

                      Kontakta oss om denna kurs<\/h2>\n