Oracle8i Architecture For Developers

This is 2-day course is an 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. On course completion students will 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

 
key facts buy online

• code: d045eng
• 2 days
• Download outline
• Print licence available

Student edition
• A4 format
• A5 format
Instructor edition
• A4 format
• A5 format

Target audience

This course has been developed for Oracle developers. Students should have attended the following courses or have equivalent knowledge and experience:

  • Introduction To Oracle SQL & SQL*Plus
  • Introduction To Oracle PL/SQL Language
  • Introduction To Oracle Advanced SQL & SQL*Plus
Course content

Oracle database server architecture About the administration tools • Application architectures • The Oracle database server • Oracle server options • What is the data dictionary? • Database users and schema

Understanding database objects Which database objects exist? • About tables • About constraints • About sequences

Instance and user memory structures What is a database instance? • System Global Area (SGA)

Instance and user processes Which processes are executing? • Instance background processes • SQL execution processes

Data files, data segments Which files are used by the database? • Data files and the physical storage hierarchy • Understanding tablespaces • Understanding data file • Understanding segments • Understanding extents • Understanding database blocks • Understanding the row structure • Understanding ROWID

Data files, non-data segments The non-date segments • Indexes and index segment • Temporary segments • Rollback segments • DBA_SEGMENTS • DBA_ROLLBACK_SEGS

Non-data files REDO LOG files • Control file • Trace and alert files

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today

A gtslearning business division :: gtslearning CompTIA learning solutions ::Contact us :: Site map
© gtslearning, 2008. All rights reserved. Ownership of all trademarks and service marks is observed and respected.