INFO.4690 Oracle 11gR2 High Performance and Internals (Formerly 90.469)

Id: 037549 Credits: 3-3

Description

In this course, students will learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, SQL Monitor, Automatic Workload Repository, Automatic Database, Diagnostic Monitor, Health Monitor, and practice these tuning methods utilizing and Oracle 11gR2 Enterprise database. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components. Various Oracle memory internals will be examined including the discovery and usage of key high performance DBMS packages and views, use of the Automatic Diagnostics Repository (ADR) interface, Cost-based optimizer statistics, and memory management, Throughout the course, students practice the art of tuning and internals using an Oracle 11gR2 Enterprise RDBMS through a series of weekly lectures, group discussions and hands-on lab workshops.

Prerequisites

Pre-Req: INFO 4500 Database Admin I: Oracle 10g and INFO 4530 Dtbase Admn II: Adv Oracle 10g.

View Current Offerings

Course prerequisites/corequisites are determined by the faculty and approved by the curriculum committees. Students are required to fulfill these requirements prior to enrollment. For courses offered through online or GPS delivery, students are responsible for confirming with the instructor or department that all enrollment requirements have been satisfied before registering.