WA1383 Oracle Database 10g: Architecture for Developers Course Outline
 
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