Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > Oracle 10g > Oracle Database 10g: Architecture for Developers Training

Oracle Database 10g: Architecture for Developers Training

Course#: WA1383

This is a special adaptation of the database architecture module normally presented to database administrators but customized for the benefit of developers. With a series of in-depth lectures developers are acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals. The objective is to provide developers with the skills needed to properly build and tune applications for optimum performance compatible with the architecture of the Oracle database. 

Objectives

At course completion students should be able to:

  • Explain the database memory structures, including the SGA and the shared pool
  • Explain the configurations possible for Oracle instances
  • Explain the structure of tablespaces, data files, extents, blocks and rows
  • Explain the structure of tables and indexes
  • Explain the role of redo log files, redo log buffers and rollback segments

Prerequisites

Mandatory prerequisites for this course are the following courses:

  • The course Oracle Database 10g: Introduction to SQL - Complete Library
  • The course Oracle Database 10g: Program With PL/SQL - Complete Library

Audience

Oracle developers

Duration

Two days.

Outline of WA1383 Oracle Database 10g: Architecture for Developers Training

1. ORACLE DATABASE SERVER ARCHITECTURE

  • Oracle Enterprise Manager (OEM)
  • OEM Console
  • APPLICATION ARCHITECTURES
  • 2-Tier Traditional Client/Server
  • 3-Tier Traditional Client/Server
  • 3-Tier Traditional Intranet or Internet
  • THE ORACLE DATABASE SERVER
  • How Does A SQL Statement Execute?
  • WHAT IS THE DATA DICTIONARY?
  • DATABASE USERS & SCHEMAS
  • SYS Schema Illustrated
  • OEM Security Manager, Users
  • Data Dictionary, DBA_USERS

2. UNDERSTANDING DATABASE OBJECTS

  • WHICH DATABASE OBJECTS EXIST?
  • OEM Schema Manager, Schema Objects
  • Data Dictionary, DBA_OBJECTS
  • OEM Schema Manager, Tables (General tab)
  • Data Dictionary, DBA_TABLES
  • Data Dictionary, USER_TAB_COLUMNS
  • OEM Schema Manager, Tables (Constraints tab)
  • Data Dictionary, DBA_CONSTRAINTS
  • Data Dictionary, DBA_CONS_COLUMNS
  • OEM Schema Manager, Sequences
  • Data Dictionary, DBA_SEQUENCES

3. INSTANCE & USER MEMORY STRUCTURES

  • IFILE Parameter
  • OEM Instance Manager, Initialization Parameters
  • Single Instance
  • Concurrent Instances And Databases, Same Server
  • Multiple Instances For One Database, Same Server
  • Oracle Real Application Clusters
  • Multiple Instances For One Database, Clustered Servers
  • SYSTEM GLOBAL AREA (SGA)
  • How The Java Pool Is Used
  • Parameters Which Determine SGA Size
  • About Oraclei Buffer Cache & Subcaches
  • SGA Size

4. INSTANCE & USER PROCESSES

  • WHICH PROCESSES ARE EXECUTING?
  • INSTANCE BACKGROUND PROCESSES
  • Instance Background System Processes Illustrated
  • DBWR & LGWR Processes
  • Checkpoints and CKPT Process
  • SMON & PMON Processes
  • ARCH Process
  • OEM Instance Manager, Background Process List
  • Oracle JServer Instance
  • Oracle JServer Instance Illustrated
  • SQL EXECUTION
  • PGA & Instance
  • Data Dictionary, V$SESSION
  • OEM Instance Manager, Sessions

5. DATA FILES, DATA SEGMENTS

  • WHICH FILES ARE USED BY THE DATABASE?
  • DATA FILES & THE PHYSICAL STORAGE HIERARCHY
  • UNDERSTANDING TABLESPACES
  • UNDERSTANDING DATA FILES
  • UNDERSTANDING SEGMENTS
  • UNDERSTANDING E_DERST
  • UNDERSTANDING DATABASE BLOCKS
  • PCTFREE/PCTUSED
  • UNDERSTANDING THE ROW STRUCTURE
  • UNDERSTANDING R_D
  • ROWID_TO_RESTRICTED()
  • ROWID_TO_EXTENDED()

6. DATA FILES, NON-DATA SEGMENTS

  • THE NON-DATA S_TA
  • INDEXES & INDEX SEGMENTS
  • Bitmap Vs B-Tree Index Scenario
  • DBA_INDEXES
  • DBA_IND_COLUMNS
  • TEMPORARY SEGMENTS, ROLLBACK SEGMENTS
  • DBA_SEGMENTS, DBA_ROLLBACK_
  • V$ROLLNAME and V$ROLLSTAT

7. NON-DATA FILES

We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.