Online Optimizer eLearning

Oracle Database 11g Problem SQL Statements Oracle Optimizer ...Optimizer Oracle Oracle Database 11g helps to identify problem SQL statements using Oracle Optimizer and execution plans. This course discusses SQL statement processing and the role of the Oracle Optimizer and execution plans. It also explains how to generate and view execution plans using the DBMS_XPLAN package, the EXPLAIN PLAN command, SQL*Plus AUTOTRACE command options, and the  more...

Oracle Database 11g SQL Performance Database Replay Oracle Database 11g: SQL Performance & Database Replay Oracle Database Replay allows you to test the impact of a system change by replaying a real-world workload on a test system before it is exposed to a production system. This course demonstrates how to use Database Replay to capture and replay workloads to test the impact of a system change. It also explains how to use SQL Performance  more...

Oracle Database 11g Architecture SQL Tuning Optimization Oracle Database 11g: Architecture, SQL Tuning & Optimization Oracle The Oracle Database server consists of an Oracle Database and one or more Oracle Database instances. SQL (Structured Query Language) is the language with which all programs and users access an Oracle Database. Monitoring the performance of and tuning database components, as well as the SQL statements used to access and  more...

Oracle Database 11g Execution Plans and Star Transformations ...tions Oracle An execution plan is the output of the optimizer and is presented to the execution engine for implementation. The execution plan instructs the execution engine about the operations it must perform for retrieving the data required by a query most efficiently. This course explores gathering, displaying, and interpreting execution plans. It also covers the EXPLAIN PLAN command  more...

Oracle Database 11g Optimizer Statistics Hints Cursor Sharing ...Optimizer Statistics, Hints & Cursor Sharing Oracle Optimizer statistics describe details about the database and the objects in the database and are used by the query optimizer to select the best execution plan for each SQL statement. This course covers gathering optimizer and system statistics, setting statistic preferences, using dynamic sampling, and manipulating optimizer statistics.  more...

Oracle Database 11g R2 SQL Monitoring Performance Enhancements ...atabase to automatically manage its own memory and gather optimizer statistics. These features enable the DBA to ensure the optimal memory sizes are being used for the database using Automatic Memory Management, and that SQL statements are running properly by monitoring them in real-time using Enterprise Manager. It also offers a new feature to conceptually extend the buffer cache by using DB  more...

Oracle SQL Tuning Diagnostics and Tuning Schema ... efficient data access methods that are available for the optimizer. Create the appropriate database objects before starting to tune SQL statements. C ontent Emphasis Skills-Based A udience Application Developers, Database Administrators, and Designer/Developers. T otal Learning Time 6 - 8 Hour(s) Course Contents Unit 1: Managing Performance  more...

Oracle SQL Tuning Tuning SQL and the Optimizer ...n SQL statements that can reuse parsing and influence the optimizer to improve performance. L earn To: Identify the factors that affect network traffic. Identify the factors that affect parsing. Identify the guidelines for the reuse of parsed code. Identify the factors in SQL code design that affect response time. Identify the methods to improve network  more...

Oracle8 Performance Tuning Managing Memory and Disk I O ...ficient SQL statements. Identify the characteristics of optimizer modes. Perform the steps to set the optimizer mode at the instance level using the OPTIMIZER_MODE parameter. Perform the steps to register a module using the SET_MODULE procedure. Perform the steps to track a module using the READ_MODULE procedure. Perform the steps to view statistics for the current session using the  more...

SQL Server 7 0 - Implementing a Database - Part 2 Course Overview This is the second course in a five part series that will provide students with the knowledge to to implement a database solution with Microsoft SQL Server 7.0. L earn To: Implement data integrity. Create and maintain indexes. C ontent Emphasis Skills-Based A udience This course is designed for IT professionals responsible for implementing a database  more...

Exchange Server 5 5 Concepts and Administration - Part 3 ... database files. Run the Microsoft Exchange Performance Optimizer by using the Microsoft Exchange Optimizer option. Display the performance optimizer log by using the Start button. Match the Exchange Server maintenance utilities with their functions. Match the database size maintenance methods with their uses. Identify the factors to be considered when planning a backup strategy.  more...

Oracle8i Performance Tuning Managing Memory Disk I O ...ment by using AUTOTRACE. Identify the characteristics of optimizer modes. Set the optimizer mode at the session level by using the OPTIMIZER_MODE parameter. Unit 2: Tuning the Shared Pool Duration: 1.5 - 2 Hour(s) Select the contents of the library cache. Identify the contents of the data dictionary cache. Select the functions of the Multithreaded Server Connection. Identify the  more...

Oracle Database 10g New Features for Administrators Part 2 ...ad Repository (AWR). Identify guidelines for gathering optimizer statistics. Identify features of Automatic SQL Tuning. Identify features of SQL Tuning Advisor. Audience: The target course audience is Data Administrators, PL/SQL Developers, and Technical consultants who have experience with the Oracle9i Database. Deployment: Self-Study Language Options:  more...

SQL Server 2000 Design Implement Databases Part 4 Managing Indexes ...g composite indexes. Identify the functions of the query optimizer. Identify the features of cost-based optimization. Sequence the steps for processing queries by using query optimizer. Audience The audience for this course includes database designers, database managers, and technical managers. Candidates for Exam 70-229 operate in medium to large computing environments that use SQL  more...

Oracle9i Peformance Tuning Managing Memory and Disk I O ...inistering an Oracle database. Learn To: o Match the optimizer modes with their descriptions. o Match the OPTIMIZER_MODE parameter values with their description. o Identify the methods of creating stored outlines. o Identify the three major areas of the Shared Pool. o Identify the parameters used to tune the Shared Pool. o Identify the goals for tuning the Library Cache. o  more...

mySAP com - Overview The Computer Based Training course (CBT) mySAP.com Overview aims to provide all employees of your company an introduction to SAP's answer to e-business, and the possibilities that mySAP.com offers. Trainees will be shown why mySAP.com was developed and the key components it contains. Furthermore, it shows how application hosting can be controlled throughout the system's entire life cycle,  more...

SAP Advanced Planner Optimizer APO Overview ...o Supply Chain Management (SCM). o Advanced Planner and Optimizer (APO). o APO Integration and Technology. o APO Planning Components. o Supply Chain Cockpit (SCC). o Demand Planning. o Supply Network Planning and Deployment. o Production Planning & Detailed Scheduling (PP/DS). o Transportation Planning (TP/VS). o Global Available-to-Promise (ATP). Audience The intended  more...

SAP R 3 4 6 Curriculum ...egic Enterprise Management (SEM) SAP Advanced Planner & Optimizer (APO) - Overview mySAP.com Workplace Overview SAP R/3 FI AR / AP: Organization, Master Records and Posting SAP R/3 4.6 FI AR / AP: Account/Document Posting and Periodic Processing SAP R/3 4.6 FI Payments SAP R/3 4.6 FI: General Ledger Organization and G/L Account SAP R/3 4.6 FI: General Ledger Posting and Periodical  more...