Management 11g

About Training


Duration: 30h
Target: professionals planning to better understand the internal structure and manage the Oracle database.
Requirements: Database Concepts, Basic knowledge of SQL.

Course Objectives

• Review the Oracle architecture
• Understand the expected events, database statistics and S.O.
• Set parameters related to performance (SGA and PGA)
• Find out slow points in the database
• Analyze and tune queries

Oracle architecture Internal processes
 Knowledge Instance
Foreground and Background Processes
Memory Areas
Database Knowledge
Data Files
Control files
Temporary files
Log files (Online and Archive)
Automatic memory management
32 x 64-bit architecture
 SELECT Sentence Processing
UPDATE processing
Consistent reading and Undoing Areas (UNDO)
Connection modes
Instance Configuration Boot Parameters
 Setting Data Buffer
Setting SQL Shared Pool
Configuring Transaction Log
Setting the PGA Aggregate
 Character Handling Functions
Data Handling Functions
Numbers Handling Functions (Mathematics)
Oracle Installation Database Creation
 Basic and Advanced Installation
Installation Wizard screens
 Creation Guide
Creation with Assistant – DBCA
Graphical Manager Oracle Physical Structure
 Enterprise Manager Java Console
Enterprise Manager Web Console
 Setting Block Size
Knowing the Block Areas
Data Files Maintenance
Maintaining Control Files
Maintaining Log Files
Working with Oracle Managed Files Flash Recovery Area
 Concepts and Features
Parameter Configuration
Parameter Configuration
Logical Structure Flash Recovery Area
 Segment Types
Data, Indexes, UNDO/ROLLBACK, Temporary, Bootstrap
Characteristics of Extensions
Extensions INITIAL and NEXT
Storage features of Tables and Indexes
TABLESPACES, PCTUSED, PCTFREE, and initrans maxtrans
Materialized Views Concept
Concept Partitioning
Synonyms Public and Private
Automatic Space Management (ASSM)
Extensions Management
Data dictionary
Local structure
Archiving Mode
Cluster Concepts
Oracle File System (ASM) Configuring the Connection Server and Client
Advantages and disadvantages
Automatic Storage Management
 Communication Components
Client Configuration Files
Tnsnames.ora, SQLNET.ora
Server Configuration Files


 SQL 11g PL/SQL 11g Management 11g Backup 11g Performance 11g

Our Clients