About Training
DESCRIPTION
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 |
Concepts Parameter Configuration |
| Logical Structure | Flash Recovery Area |
| Segment Types Data, Indexes, UNDO/ROLLBACK, Temporary, Bootstrap Characteristics of Extensions Extensions INITIAL and NEXT Parameters MINEXTENTS, MAXEXTENTS 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 |
Privileges Powers Archiving Mode Cluster Concepts |
| Oracle File System (ASM) | Configuring the Connection Server and Client |
| Concepts Advantages and disadvantages Automatic Storage Management |
Communication Components Client Configuration Files Tnsnames.ora, SQLNET.ora Server Configuration Files Listener.ora TNSPING |
30H
Hire
