Attendees with prior knowledge in the following, will find the course more easy to understand:

• Linux
• Oracle or Unix Administration

• Architecture

  Go to top
  • Defining an Oracle Server, Database, Instance.
  • Understanding Physical Structure, Memory Structure, Process Structure,Logical Structure, Execution of SQL Statements, User Session

• Creating a New Database

  • Identifying the application and the no. of applications the DB will support. Adv. of having each application on each DB. Adv. of having common DB.for all Applications.
  • UnderstandingTS, Changing Initialization parameters- SGAsize, Processes, TS Naming Conventions, Block Sizes, Type of DB, No. of users the DB has to support, etc,
  • Dropping a Database, ASM Database, sysaux, Tablespace, Default Tablespace.

• Managing an Oracle Database

  • Creating and Managing Initialization files - PFILE and SPFILE, Adv. of SPFILE over PFILE
  • Identifying the various states/options of Instance Startup/Shutdown, DB Mount/Open stages
  • Monitoring Alert and Trace Files in udump, bdump and cdump for DB Troubleshooting
  • Configuring System Global Area (SGA) - DB Buffer Cache, Log Buffer and Shared Pool
  • Understanding Background Processes - Mandatory/Optional and the jobs performed by them using the Data Dictionary to retrieve information about the database -V$, DBA_views

• Managing Tablespaces and Datafiles

  • Creating and Altering Tablespaces, adding, resizing, renaming and relocating a Datafile,Renaming Tablespace.Tablespace - offline, online, readonly, readwrite,

• Temporary tablespace groups, multiple blocks

  • Creating and Managing a Tablespace when using OMF and the advantages of OMF

• Feature

  • Extent management- Dictionary Managed and Locally Managed Tablespaces (AUTOALLOCATE, UNIFORM) and advantages of locally managed over dictionary managed

• Tablespaces

  • Big File Tablespace, Temporary Tablespace Group.

• Storage Management

  • Creating, Maintaining tables using appropriate storage settings - initial, minextents, pctfree, etc
  • Obtaining table information like avg. row length, chained rows, etc after analyzing the tables
  • Managing. Listing diff. types of Indexes and their uses. Creating B-Tree and Bitmap Indexes, Maintaining Indexes, Identifying unused Indexes, Obtaining Index

• Information

  • User Management
  • Creating user's, Managing resources with profiles, User Authentication, Managing user privileges and roles.
  • Managing Export's & Import's
  • Main Tasks of Exports and Imports Incremental, Cumulative and Complete Export and Import Points to remember before doing export and import

• Oracle Data Pump

  • Introduction, Benefits of Data Pump Export and Import
  • Data Pump Export and Import modes
  • Transport of Tablespace across different platform's

• Managing Undo Segments

  • Understanding Oracle Undo Segments, Retention Policy, Retention Gurantee/ Nogurantee, Switching Undo Table spaces

• Maintaining the Control File. Redo Log File and Archive Log Files

  • Importance, Role, Sizing, Contents, Multiplexing and Backing up of the Control File
  • Purpose of and how online redo tog files work with their associated Background Processes
  • Controlling log switches and checkpoints, Multiplexing and Archiving online redo log files

• Networking Overview

  • Explaining solutions included with Oracle for managing complex networks
  • Oracle Net Architecture - Explaining the key components, Role in Client/Server connections
  • Oracle Net Services Server-side Configuration, Oracle Net Services Client-Side Configuration
  • Configuring and Maintaining Distributed DBs by creating DB Links, Materialized Views Usage and Configuration of Oracle Shared Server, Components of the Oracle Shared Server, Configuring Shared Servers and Dispatchers, Identifying Useful Data Dictionary Views

• Backup and Recovery

  • Describing the basics of DB Backup, Restore and Recovery, Listing the types of Failures that may occur in an Oracle Environment, Defining Backup and Recovery Strategies. Instance and Media Recovery Structures - Describing the Oracle Processes, Memory Structures and Files related to Recovery, identifying the importance of Checkpoints, Redo Log Files and Archived Log Files, Describing the ways to tune Instance

• Recovery

  • User Managed Backups and Recoveries - Backup and Recovery Operations, Closed and Open DB Backups (Hot and Cold), Complete Recovery, Identifying the situations which require Incomplete Recovery, Recovery from loss of Online Redo Logs, Creating Clone DBs
  • Oracle Recovery Manager (RMAN) - Features and components, Repository, Channel Allocation, Configuring RMAN Environment. Backup Commands and Scripts for Backup sets. Image copies, Complete and Incomplete Recovery and Full/ Incremental Compressed backups. Incremental backups with block change tracking, RMAN compressed backup Availability

• Dataguard

  • Offers Maximum Protection/ Performance, centralizing and simplifying mgmt.. safeguarding against physical corruptions, provides Fail Over and Switch Over .

• Logminer

  • Read and Analyze the contents of redo log files, obtain info, about DML activities on standard tables, provides a means of auditing actions to either specific tables or by users

• Flashback Technology

  • Intro to Flash Recovery Area. Flashback Version Query, Flashback Transaction Query

• Performance Tuning

  • Overview of Tuning Phases, Goals, Methodology and Common Performance problems
  • Tuning O/S, Virtual and Physical Memory, Paging and Swapping, CPU Tuning guidelines
  • DB Conf. and I/O Issues, File Striping, Optimize/Tuning Sorting Operations, Diagnosing
    and Tuning Latch and Lock Contention, Partitioning, Redo Log File Configuration, Online Segment Shrinking
  • Enabling Oracle's Parallel Query Option, Multiple DB Writers, Log Writers, Table Caching
  • Sizing of SGA- Shared Pool (Reuse Stmts., etc.), Buffer Cache, Redo Log Buffer Cache
  • Tuning Rollback/Undo Segments - Usage, Configuration, Detecting and Resolving problems
  • Diagnostic and Tuning Tools -Alert Log File, Trace Files, TKPROF, Explain Plan, trcsess
  • Dynamic Performance Views, T1MED_ STATISTICS parameter to collect statistics, AWR, ASH,ADDM,ASMM
  • Application Tuning - SQL Tuning, Optimizer Modes, Plan Stability, Hints, Detecting and Resolving Row Chaining and Migration, Indexes, Data Storage Structures, Resumable
  • Space Allocation, Composite partitioning

• Oracle Enterprise Manager (OEM)

  • Creating OEM Repository, Configuring OEM with Oracle intelligent Agent and Management Server. Creating DB Objects (Tablespaces, Rollback Segments, etc., Performing various DBA operations (DB Backup, RMAN Backup), Scheduling Jobs, Events and Event- Notification, Undo Advisor.

• Oracle Advanced Replication

  • Configuring Master Sites and Materialized View Sites for Multimaster Replication and Materialized View Replication using Oracle Replication Management Tool

• Oracle Installation

  • OraclelOg on Red Hat Enterprise Linux 4

• Introduction to Oracle 9i: SQL

  • The program covers the concepts of both relational and object relational databases and the powerful SQL programming language. This program counts towards the Oracle 9i
  • Database Administrator Certification.

• Oracle 9i: Program with PL/SQL

  • This program introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. In the program, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

• Oracle 9i Forms Developer: Build Internet Applications

  • This program teaches students to develop and deploy Internet applications using Oracle9i Forms. Working in a rapid development environment, participants learn how to customize forms through user input items and how to control data access by creating event-related triggers. In this practical program, you also learn how to test and debug your Web applications through the Forms environment.

• Oracle 9i Database Administration Fundamental I

  • This program is your first step towards success as an Oracle professional, designed to give you a firm foundation in basic database tasks. In this program, you'll learn how to design, create, and maintain an Oracle database.
  • Students will gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another and how to create an operational database and properly manage the various structures in an effective and efficient manner.

• Oracle 9i Database Administration Fundamental II

  • This program gives the Oracle database administrator (DBA) a firm foundation in Oracle Net administration and backup and recovery operations.
  • Students learn about transporting data between databases and the utilities used to perform these activities. Students are also introduced to networking concepts and configuration parameters, as well as how to solve some common network problems. This program also addresses backup and recovery techniques, and examines various backup, failure, restore and recovery scenarios.

• Oracle 9i Database Performance Tuning

  • This program will introduce participants to the importance of good initial database design, and the method used to tune a production Oracle9i database. The focus is on Database and Instance tuning rather than specific operating system performance issues. Using the available Oracle tools, such as Oracle Enterprise Manager (with the Diagnostics and Tuning Packs) and STATSPACK participants also learn how to recognize, troubleshoot and resolve common performance related problems in administering an Oracle database

By the end of this course you would have learnt to create, execute and perform complex maintenance related operations using the Oracle database.