Oracle DBA Environmental Training in Chennai

Oracle DBA Training in Chennai

Course Content:

Oracle Installation and Environments

  • Diff Project and Production DBA
  • Change Management
  • Environments Usage
  • Why kernel parameters?
  • How to calculate kernel values?
  • Silent Mode installation
  • DB auto startup/shutdown on Server reboots?
  • Releasing memory dump from OS level.

Architecture (Interview point – Technical Discussion)

  • Basic Architecture
  • PGA
  • Startup/shutdown
  • DMT/LMT
  • Space / Storage parameters
  • DB Fragmentation
  • Index Fragmentation
  • Partitions

Backup and Recovery (Interview point - Technical Discussion)

  • Exp/Imp
  • Data pump
  • UMB
  • UMR
  • RMAN
  • Utilities

Performance Tuning (Interview point - Technical Discussion)

  • SQL Tuning
  • Analyzing AWR/Statspack
  • Resolving Locks
  • Long Running Queries

Net*8 Architecture

  • Tnsnames
  • Listener
  • DBlinks

Dataguard

  • Logical / Physical
  • Related Parameters
  • Protection Modes

(c) 2013 Sakthi Software Solutions Pvt.Ltd. All Rights Reserved