Oracle 10g Application Tuning

ProTech Professional Technical Services Canada, Ltd.
Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This course provides students with an introduction to application and database tuning. Students will learn how the cost-based optimizer works. A discussion of basic Oracle architecture will provide the foundation for understanding both SQL statement and system performance. Students will use EXPLAIN PLAN and AUTOTRACE for evaluating execution strategies and the DBMS_STATS package for gathering optimizer statistics. Also discussed is how to influence the behavior of the optimizer with hints, physical schema changes and alternative SQL statement syntax. Factors that affect overall system performance such as the buffer cache, SGA structures and waits due to locks and latches are presented.

Audience: This course is designed for Database Administrators and Application Designers and Developers.

Topics:
Tuning Overview
Oracle Architecture
ALERT Logs, Trace Files, and Events
SQL Statement Processing
SQL Statement Tuning
Indexes
Cost-Based Optimizer
Influencing the Optimizer
Tuning Tools
Optimizer Plan Stability
Locking and Concurrency
Prerequisites: Before attending this course, students should take ProTech’s Oracle 10g Database Administration or Oracle 9i Database Administration.
...''

Phone:866-821-9311

School Address:

111 Peter Street
Suite 626
Toronto, ON M5V 2H1 Canada

Jobs & Resumes: Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg
Houses & Roommates: Calgary, Edmonton, Ottawa, Toronto, Vancouver, Victoria, Winnipeg

J2EE Web Application Programming using BEA WebLogic
Java Programming Essentials Using Eclipse
Advanced Java Programming
Java Server Pages Programming with BEA WebLogic
Java Server Pages
Java Servlet Programming
JavaServer Faces Development
Linux System Administration
MySQL Administration and Management
OOAD with UML
Oracle 10g Database Administration
Oracle 10g Database Performance and Tuning
Oracle 10g New Features for Administrators
Oracle 10g SQL & SQL*Plus
Project Management Fundamentals

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa.