O1010 – 10g DBA Fundamentals I Oracle

by Elite Training Claim Listing

This course is aimed at the DBA's who often have to make the first attempt at solving performance problems prior to, and as they develop. We cover all aspects of internal database tuning on an Oracle 10g platform in this three-day course.

£895

Contact the Institutes

Fill this form

Advertisement

Elite Training Logo

img Duration

5 Days

Course Details

Training Course Objectives:

Everyone involved with the Oracle system; system architects, designers, developers and database administrators (DBA's), should consider performance tuning while carrying out their work.

This course is aimed at the DBA's who often have to make the first attempt at solving performance problems prior to, and as they develop. We cover all aspects of internal database tuning on an Oracle 10g platform in this three-day course.

The enhancements and changes that have been introduced in 10g will be discussed during this course for the benefit of DBA's responsible for earlier RDBMS versions for the purposes of planning and upgrade tuning.
FAQ Training Course Contents: Tuning Overview

  • Tuning Questions/Goals/Steps

Alerts, Trace Files & Events

  • Diagnostic Information

  • The Alert Log File

  • User Trace Files

  • Statistics Event Views

Dynamic Performance Views

  • Dynamic Performance Views

  • Collecting System-Wide Statistics

  • Collecting Session Related Statistics

  • Statspack

Oracle Wait Events

  • I/O related events

  • Lock related events

  • Latency related events

  • Gathering wait event data

Automatic Workload Repository

  • Automated snapshot collection

  • Active Session History

Automatic Database Diagnostics

  • Enterprise Manager Advisors

  • ADDM reports

  • Time model statistics

  • Wait model statistics

Tuning the Shared Pool

  • The Shared Global Area

  • Tuning the Library Cache

  • The Data Dictionary Cache

  • User Global Area and Shared Server

Tuning the Buffer Cache

  • Evaluating the Cache Hit Ratio

  • Adding Buffers

  • Using Multiple Buffer Pools

  • Defining Multiple Buffer Pools

  • Caching Tables

Tuning The Redo Log Buffer

  • Sizing The Redo Log Buffer

  • Reducing Redo Operations

SQL Tuning

  • Optimizer Modes

  • Diagnostic Tools

  • V$SQL_PLAN

  • Monitoring table and index useage

DBMS_STATS

  • Gathering statistics

  • Changing the data dictionary statistics

  • Automating statistics collection

Optimiser Plan Stability

  • Creating stored outlines

  • Using stored outlines

  • Viewing the execution paths

  • The OUTLN user

Materialised Views

  • Creating

  • Registering existing summary tables

  • Refresh options

Database Config. & I/O Issues

  • Tablespace Usage

  • Partitioning Tables and Indexes

  • Distributing Files Across Devices

  • Tuning Checkpoints

  • Automatic Storage Management

Oracle Blocks Efficiency

  • Database Storage Hierarchy

  • Database Block Size

  • Multiple Block Sizes

  • PCTFREE and PCTUSED

  • Automaic Space Segment Management

  • Detecting Chaining

  • Monitoring and Rebuilding Indexes

Tuning Rollback Segments

  • Rollback Segment Usage

  • Tools for Tuning Rollback Segments

  • Using Less Rollback

  • Using Automatic Undo Management

Tuning the Operating System

  • CPU Tuning Guidelines

  • Tuning Memory

  • Tuning I/O

Optimizing Sorts

  • Sort Area and Parameters

  • Tuning Sorts

  • Avoiding Sorts

  • Configuring Temporary Tablespaces

  • Database Default Temporary Tablespace

  • Automatic PGA Management

Tuning Different Applications

  • Comparing B-Tree and Bitmap Indexes

  • Creating Reverse Key Indexes

  • Index-Organized Tables

  • Clusters / Cluster Types

  • Histograms

Database Resource Manager

  • Creating Consumer groups and adding users

  • Allocating resources to groups

  • Activating resource plans

Lock Contention

  • Locking Mechanisms

  • Tools for Monitoring Locking Activity

  • Resolving Contention

  • Deadlocks

Contention Issues

  • Diagnosing Latch Problems

  • Resolving Latch contention

  • Diagnosing Free List Contention

  • Resolving Free List Contention

  • Glasgow Branch

    1 Blythswood Square, Glasgow
  • Liverpool Branch

    Liverpool Science Park Innovation Centre 131 Mount Pleasant, Liverpool

Check out more Oracle courses in UK

London IT Training (LIT) Logo

Oracle Certified Professional (Java Ee 7 Application Developer Training)

This course is designed for Java EE (Enterprise Edition) software developers.

by London IT Training (LIT)
PCWorkshops Logo

Oracle Fundamentals Course

At this Oracle SQL Fundamentals couse, we cover SQL queries, group by's , aggregates, joins, date-functions, String Functions, Random Functions, Math Functions, Insert, update and delete, Creating and changing tables, sub-queries in detail, views, stored procedures, custom function, table variables...

by PCWorkshops
London IT Training (LIT) Logo

Teradata Training

Teradata is a data warehousing solution used to handle massive data warehouse operations. Participants will obtain in-depth knowledge of Teradata’s database architecture, as well as the product’s capabilities and benefits, throughout this Teradata certification course.

by London IT Training (LIT)
Global Knowledge Logo

Oracle Advanced Pl/sql

This course,designed for Oracle database administrators and software development personnel who need to gain practical experience of the advanced features of PL/SQL such as program design,packages,cursors,large objects and collections.

by Global Knowledge [Claim Listing ]
I Train Scotland Logo

Microsoft SQL Server

This 2 day course provides a foundation for designing, building and working with relational databases, enabling students to effectively develop and use relational databases in a business environment.

by I Train Scotland [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy