Oracle Database 11g: Architecture, SQL Tuning, and Optimization
Overview/Description Target Audience Prerequisites Expected Duration Lesson Objectives Course Number Overview/Description
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 manipulate the database, helps to ensure the Oracle Database server runs efficiently and as expected. This course explores the major architectural components of the Oracle Database server, memory structures, background processes, and physical and logical storage structures. It also examines SQL tuning, identifying the attributes of a SQL statement that can make it perform poorly, SQL tuning tools, and common tuning tasks. The steps involved in the execution of a SQL statement, the optimizer and its phases, and controlling optimizer behavior are also covered.
Target Audience
Support engineers, developers, technical consultants, data warehouse developers, and application developers.
Prerequisites
Oracle Database 11g: Introduction to SQL
Oracle Database 11g: SQL Fundamentals I