Advanced Oracle for Administrators


Course Number: ORC-336

Duration: 4 days (26 hours)

Format: Live, hands-on

Oracle for Administrators Training Overview

Accelebrate's Advanced Oracle for Administrators training teaches students the skills needed to keep a database running reliably and efficiently, including working with multitenant architecture  (CDB/PDB), tuning the database, tuning SQL, and performing backup and recovery.

Location and Pricing

Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.

Objectives

  • Understand, work with, and administer a multitenant architecture
  • Set up a Multitenant environment
  • Generate AWR SQL reports
  • Install and use Statspack
  • Investigate the SGA memory structures
  • Understand the purpose of indexes
  • Create and maintain indexes
  • Use SQL performance investigation tools
  • Apply SQL tuning techniques
  • Configure the database
  • Work with more advanced RMAN capabilities

Prerequisites

Students should have taken Accelebrate's Oracle for Administrators training or have equivalent experience.

Outline

Expand All | Collapse All

Multitenant Architecture
  • Investigate the multitenant architecture
  • Describe the container types: root, seed, pluggable
  • Understand how Oracle Net establishes sessions
  • Query the views that describe the environment
  • Describe some features relevant to large deployments
Set up a Multitenant Environment
  • Create a container database
  • Create pluggable containers
  • Convert a non-CDB to a pluggable container
  • Relocate, unplug, and drop containers
  • Hot clones of PDBs and non-CDBs
  • Upgrade a CDB
Multitenant Administration
  • Startup and shutdown a CDB
  • Open and close pluggable containers
  • Tablespace management
  • Create local and common objects
  • Understand use of roles and privileges
  • Set instance parameters
Using Statspack and AWR Reports
  • Understand the automatic snapshot mechanism
  • Use the DBMS_WORKLOAD_REPOSITORY package
  • Create snapshots
  • Create baselines
  • Modify settings
  • Generate and interpret AWR reports
  • Generate AWR SQL reports
  • Install and use Statspack
Frequently Encountered Wait Events
  • Disc I/O events
  • Buffer cache related events
  • Shared pool events
  • Redo generation events
  • Contention events
  • Enqueue waits
  • Latch and mutex events
Tuning Memory Structures
  • Investigate the SGA memory structures
  • Diagnose and fix issues with sizing of the SGA components
  • Use automatic shared memory management (ASMM)
  • Manage the aggregate PGA 
  • Understand the need for PGA memory
  • Correctly size the aggregate PGA
  • Work with temporary tablespaces
  • Enable automatic memory management (AMM)
Indexes
  • Understand the purpose of indexes
  • Describe the types of index
  • B-tree indexes
  • Function based indexes
  • Reverse key indexes
  • Bitmap and bitmap join indexes
  • Create and maintain indexes
  • The Oracle Text domain index type
The SQL Tuning Methodology
  • Define the purpose of tuning
  • Describe the SQL execution cycle
  • Understand the concept of cost based optimization
  • Learn the steps to tune a SQL statement
SQL Performance Investigation Tools
  • AWR reports
  • Statspack reports
  • Generate and read execution plans
  • The EXPLAIN PLAN command
  • The SQL*Plus autotrace facility
  • The DBMS_XPLAN package
  • Consider the use of SQL Trace
The Cost Based Optimizer
  • Understand the CBO’s decision making process
  • Join order
  • Join methods
  • Access methods
  • Use techniques to test alternative execution plans
  • Determine if statistics are inaccurate or inadequate
  • Gather object and other statistics
Techniques to Tune Any SQL statement
  • Recognize “red flags” in execution plans
  • Look for frequently seen errors in analysis and design
  • Some common programming mistakes
  • Gather all necessary statistics
  • Apply a solution discovery method
Configure the Database to Prevent Data Loss
  • Understand the importance of archive log mode
  • Ensure that files are multiplexed where possible
  • Manage the controlfile
  • Manage the online redo log
  • Consider use of a Fast Recovery Area
  • Consider use of Oracle Managed Files
  • Enable database flashback
  • Data Pump as part of a recovery strategy
The Basics of Backup, Restore, and Recovery with RMAN
  • Backup the database
  • Backup and remove archive logfiles
  • Perform complete and incomplete recovery
  • Configure defaults
Some more Advanced RMAN Capabilities
  • Decide between backupsets and image copies
  • Create incremental backups
  • Enable block change tracking
  • Use incrementally updated copies
  • Enable encryption and compression
  • Understand incomplete recovery usage cases
RMAN Maintenance, Reporting, and Tuning
  • Understand retention policies
  • Generate reports
  • Remove obsolete backups
  • Update the repository with external changes
  • Manage archive logfiles
  • Create long term and offsite backups
  • Consider performance options
Conclusion

Training Materials

All students receive comprehensive courseware and a related textbook.

Software Requirements

  • Windows or Linux with at least 8GB RAM
  • A complete installation of a modern instance of Oracle
  • Please contact us for detailed setup instructions if you have purchased this class.


Learn faster

Our live, instructor-led lectures are far more effective than pre-recorded classes

Satisfaction guarantee

If your team is not 100% satisfied with your training, we do what's necessary to make it right

Learn online from anywhere

Whether you are at home or in the office, we make learning interactive and engaging

Multiple Payment Options

We accept check, ACH/EFT, major credit cards, and most purchase orders



Recent Training Locations

Alabama

Birmingham

Huntsville

Montgomery

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

Los Angeles

Oakland

Orange County

Sacramento

San Diego

San Francisco

San Jose

Colorado

Boulder

Colorado Springs

Denver

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Jacksonville

Miami

Orlando

Tampa

Georgia

Atlanta

Augusta

Savannah

Hawaii

Honolulu

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Frederick

Hagerstown

Massachusetts

Boston

Cambridge

Springfield

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Minneapolis

Saint Paul

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Las Vegas

Reno

New Jersey

Princeton

New Mexico

Albuquerque

New York

Albany

Buffalo

New York City

White Plains

North Carolina

Charlotte

Durham

Raleigh

Ohio

Akron

Canton

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Oklahoma City

Tulsa

Oregon

Portland

Pennsylvania

Philadelphia

Pittsburgh

Rhode Island

Providence

South Carolina

Charleston

Columbia

Greenville

Tennessee

Knoxville

Memphis

Nashville

Texas

Austin

Dallas

El Paso

Houston

San Antonio

Utah

Salt Lake City

Virginia

Alexandria

Arlington

Norfolk

Richmond

Washington

Seattle

Tacoma

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Calgary

Edmonton

British Columbia

Vancouver

Manitoba

Winnipeg

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan