Online Automatic Sql Tuning eLearning

Oracle Database 11g R2 Managing Database Memory Performance Oracle Database 11g R2: Managing Database Memory & Performance Oracle Because there is a finite amount of memory available on a database server and on an Oracle Database 11g instance, you must pay attention to how memory is allocated. Also, database planning must include a balance between performance, cost, and reliability. You must consider the investment in the system architecture, which  more...

Oracle Database 11g Using AWR Defining Problems Oracle Database 11g: Using AWR & Defining Problems Oracle Automatic Workload Repository (AWR) is the infrastructure that provides services to Oracle Database 11g components that collect, maintain, and utilize statistics for problem detection and self-tuning purposes. This course explains how to create and manage AWR snapshots, and demonstrates how to use the snapshots to generate individual  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 Tuning PGA Temporary Space AMM Oracle Database 11g: Tuning PGA, Temporary Space & AMM Oracle Oracle Database 11g provides various methods for tuning, monitoring and managing memory and temporary tablespaces. Automatic Program Global Area (PGA) memory management adapts the SQL memory allocation based on PGA memory available, SQL operator needs, and system workload. A temporary tablespace is used to store transient data  more...

Oracle Database 11g Segment Space I O and Performance Tuning Oracle Database 11g: Segment Space, I/O and Performance Tuning Oracle Oracle Database 11g provides various methods for tuning segment space usage and input/output (I/O). This course explains how to use Automatic Segment Space Management (ASSM) to tune segment space usage, how to shrink segments using SQL or the Enterprise Manager, and how to use table compression. Automatic Storage  more...

Oracle Database 11g Application Tracing Automatic SQL Tuning ...Automatic SQL Tuning Oracle Oracle Database implements tracing by generating a trace file for each server process when you enable the tracing mechanism. This course explores configuring the SQL Trace facility to collect session statistics, using the TRCSESS utility to consolidate SQL trace files, formatting trace files using the tkprof utility, and interpreting the output of the tkprof  more...

Oracle Database 11g R2 Intelligent Infrastructure Enhancements ... alert log. Oracle Database 11g has expanded features for automatic SQL tuning and the Automatic Workload Repository, which allows the DBA to ensure the database is running efficiently, and by using the Enhanced Resource Manager the DBA has the ability to optimize resource allocation among many different database sessions to prevent excessive overhead. This course identifies how to  more...

Oracle Database 11g Database Replay and Automatic SQL Tuning Explain the benefits and uses of Oracle Database 11g's crucial developer tools, Database Replay and Automatic SQL Tuning, when setting up and testing a database  more...

Oracle Database 10g Administration Workshop II Part 3 This course covers various functions of the Flashback technology. In addition to performing flashback operations at the database level, you can flash back a table or recover a table that has been dropped by mistake. The course also covers the tools used to monitor and improve database performance as well as detect and repair database corruption. Learn To: Identify features of  more...

Oracle Database 10g New Features for Administrators Part 1 Oracle Database 10g is the first database designed for enterprise grid computing. It is the most flexible and cost-effective way to manage enterprise information. This course covers the new features of Oracle Database 10g that are applicable to database administration. The features include Manageability concepts, Grid computing, enhanced installation features, configuration and performance  more...

Oracle Database 10g New Features for Administrators Part 2 ...r 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: US English Total Learning Time: 6  more...