1.   Managing Oracle Data Storage.

• Block, Extents & Segments.
• Database, Tables Spaces & Data Files.
• Tables, Indexes & Views.

2.   Managing Oracle Memory Structure.

• SGA.
• Background Process.
• Memory Allocation to different Objects.

3.   Designing Data Integrity.

• Primary & Forign Key.
• Defining Relational Integrity.
• Cascading Operation.

4.   Managing Rollback & Temporary Segments.

• Defining Specialty of Rollback & Temporary Segments.
• Creating Rollback & Temporary.
• Allocating Rollback & Temporary Segments to Database Objects.

5.   Managing Data Security.

• Managing Users.
• Managing Roles.
• Getting Privileges to Users/Roles.

6.   Designing Backup Strategies.

• Type & Cause of Failures.
• Planing & Selection of Backup Strategies.
• Backup Consideration Tips.
• Testing Plans for Backup & Recovery.

7.   Oracle Backup/Recovery options.

• Physical Offline Backup & Recovery.
• Physical Online Backup & Recovery.
• Logical Backups using Import/Export.

8.   Overview of Tuning.

• Tuning Plan Development.
• Tuning Types.
• Oracle Tuning Tools.

9.   Application Tuning.

• Explain the Primary Importance of SQL Tuning.
• Diagnoses Tools for Application Tuning.

10.   Memory Structure Tuning.

• Tuning the Shared Pool.
• Tuning the Buffered Cache.
• Tuning Data Dictionary Cache.

11.   Tuning Sorts.

• SQL Operation & Sorts Requirements.
• Minimizing Disk Sorting.
• Use Direct Writes.

12.   Other Tuning Considerrations.

• Tuning Redo Mechanism.
• Tuning Rollback Segments.
• Tuning Oracle Physical Storage Parameters and Objects.

Level 1:Foundation | Level 2:Application Development Tools | Oracle Forms | Oracle Reports |
Level 3:Database Administration | | Oracle on the Net | Back | Home