Course not currently available
Oracle 11g - Application Tuning - Workshop Training Course
Course
In Leeds ()
Description
-
Type
Course
For who
The workshop is intended for advanced programmers and Oracle users who seek knowledge and information on the efficient development of information systems in an Oracle database, and the tuning and testing of performance issues in existing applications. This course builds on knowledge often unavailable or incorrectly presented in the technical documentation, and collected during many years of practice leading them instructors. These workshops may be the end of the training path for developers, or a single step for people with extensive experience designing and programming in Oracle
Purpose of training
The workshop aims to provide mechanisms that occur in an Oracle database when performing SQL statements. Allows participants to avoid errors during software development, and explore, diagnose, and resolve performance problems in existing applications.
Particular emphasis is placed on the workshops, where we show the methodology and the practical aspects of the application and tuning SQL statements.
The content of the training
Mechanics perform SQL commands
Managing the process cost optimization
Methods of data storage and indexing
Monitoring database performance and processes based on dictionaries and track system applications
Analysis of cases of the most common problems that cause performance
Notes
The workshops are based on the software version 11g XE
About this course
The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
Practical experience in working with Oracle
Reviews
Subjects
- Monitoring
- Information Systems
- Testing
- Server
- Database
- SQL
- Database training
- Statistics
- Systems
- Programming
Course programme
- Server processes
- Memory structure (SGA, PGA)
- Parsing and share cursors
- The data files, log files, parameter files
- Hypothetical plan (EXPLAIN PLAN, SQLPlus AutoTrac XPlane)
- The actual execution plan (V $ SQL_PLAN, XPlane, AWR)
- Monitoring the current status of the instance by system dictionary views
- The monitoring of historical dictionaries
- Tracking application (SQLTrace, TkProf, TreSess
- Properties cost optimization and regulated
- Determination to optimize
- Session parameters and instance
- Tips (hints)
- Patterns of query plans
- Impact statistics and histograms for performance
- The methods of collecting statistics and histograms
- Strategy of counting and estimating statistics
- Management statistics: blocking, copying, editing, automation of collection, monitoring changes
- Dynamic data sampling (temporary plates, complex predicates)
- Multi-column statistics, based on expressions
- Statistics System
- Spaces tables.
- segments
- Extensions (EXTENTS)
- Blocks
- The physical aspects of the table
- temporary Tables
- Tables index
- external Tables
- Partition Table (span, letter, hash, mixed)
- Physical reorganization of tables
- Building B-TREE indexes
- Properties index
- Indexes: a unique, multi-column, function, inverse
- Compression indices
- Reconstruction and merging indexes
- Virtual indexes
- Indexes private and public
- Bitmap Indexes and junction
- The impact of a place at the table level and block performance readings
- Loading Data conventional and direct path
- The order of predicates
- Methods of reading index (UNIQUE SCAN RANGE SCAN FULL SCAN FAST FULL SCAN MIN / MAX SCAN)
- Using functional indices
- The selectivity index (Clustering Factor)
- Multi-column indexes and SKIP SCAN
- NULL and indexes
- Index tables (IOT)
- Impact indices DML operations
- Sorting memory
- Sort index
- Sort linguistic
- The effect of entropy to sort (Clustering Factor)
- The merger: MERGE, HASH, NESTED LOOP
- Joins in OLTP and OLAP systems
- The order of switching
- Outer Joins
- AntI-join
- Joins incomplete (SEMI)
- Subqueries simple
- Correlated subqueries
- The views, the WITH clause
- Buffer Sort
- INLIST
- VIEW
- FILTER
- Count Stop Key
- Result Cache
- Read query plans for use dblinks
- Choosing the leading mark
Additional information
Oracle 11g - Application Tuning - Workshop Training Course