| Oracle DBA |
 |
Duration: 2 Months (60 Hours)
Class Day: Saturdays 7 hours or 2 weekday evenings 6.00 – 9.00PM
|
Oracle 10g Database Administration Foundation Course
Every information system has a database in the backend to store data obtained from various applications, which is the basic essential of any information system. To have an Information system we need to create, organise, manage and maintain the database.
All these tasks are performed by a Database Administrator. In many universities IS/IT based courses have one or two subjects related to databases, mostly focussing on development using MS-Access and, in advance courses, Oracle.
In the university courses you will find all the theories from origin of the databases to the current research and developments in the industry, but these courses often miss the main point of student centred comprehension of the subject and its use and implementation in the real world.
How does our CGC foundation DBA course differ from the university courses?
This foundation course is designed for those individuals who are aspiring to become professional Database Administrators. The methodology adopted is to give the students a real work-based learning experience, where they can begin to comprehend the role of a DBA and the contents that are an essential part of the package.
What will you learn on a DBA foundation course?
You’ll learn to setup a Linux server from scratch and then build a fully fledged Oracle 10g installation and creation of an Enterprise level database.
How will you learn DBA differently at CGC?
We need an environment where we could learn and practise the things that we learn, for example if you need to learn to drive a car you need a fully functional car, know-how for manoeuvring it and professional guidance to do it safely and efficiently.
At CGC we will enable you to develop that environment by rigorous practical hands on training sessions with one of our expert trainers along with study material and plenty of notes to practise all that is required for handling the tasks of a DBA. Once you have all the necessary setup and set objectives, it will all depend on how much you practice.
Course Contents
Oracle Installation
- Oracle10g on Red Hat Enterprise Linux 4.
Architecture
- 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.
- Understanding TS, Changing Initialization parameters – SGA size, Processes, TS Naming Conventions, Block Sizes, Type of DB, No. of users the DB has to support, etc, Dropping a Database, ASM Database.
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
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
Managing Rollback and Undo Segments
- Creating and Managing Rollback Segments, Optimal Parameter, Online/Offline, Pending Offline, Deferred Rollback Segments, Snapshot too old scenario
- Understanding Oracle Undo Segments, Retention Policy, Retention Gurantee/Nogurantee, Switching Undo Tablespaces
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
Maintaining the Control File and Redo Log File
- Importance, Role, Sizing, Contents, Multiplexing and Backing up of the Control File
- Purpose of and how online redo log files work with their associated Background Processes
- Controlling log switches and checkpoints, Multiplexing and Archiving online redo log files
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 baclups with block change tracking
- Transporting Data between DBs using Export, Import, Data Pump, Transportable TS across platform, SQL*Loader
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 Oracle10g’s New Features
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, TIMED_STATISTICS parameter to collect statistics, STATSPACK
- 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.
|
|
News
