SAINORA

HomeCourses Oracle DBA

Oracle DBA

Concepts and Administration

  • Oracle installation in linux and solaris
  • Configuration kernel parameters
  • Oracle architecture
  • 10G Automatic management
  • Program Global Area
  • Startup and shutdown options
  • Creating database
  • Managing control files
  • Managing log file
  • Managing tablespaces
  • Managing datafiles
  • Managing tables and indexes
  • Materialized views
  • Partitions
  • Locks
  • Data integrity
  • Space and storage parameters
  • Undo
  • temp management
  • Temporary database
  • Users
  • Roles and privilages
  • Profiles
  • Scheduler
  • DBMS_JOBS
  • Workshop with Scenarios
  • Assessments

Backup and recovery

  • Export
  • Import and Datapump
  • RAID
  • SAN
  • NAS
  • NFS Storage
  • User Managed backup(UMB)
  • UMB Cloning User Managed Recovery
  • Point in time to recover(PITTR)
  • Configuration RMAN
  • RMAN Backups
  • RMAN Cloning
  • Merge Backups
  • RMAN PITTR
  • Maintaining Recovery Catalog
  • Workshop with Scenarios
  • Assessments

Network Administrator

  • Client server configuration
  • Tnsnames
  • LDAP and Naming Servers
  • Listiner Control utility
  • Unix tools:FTP,SFTP,SCP,WINSCP
  • Workshop with Scenarios
  • Assessments

Oracle Utilities

  • NID
  • CSSCAN,CSALTER
  • Oerr
  • Dbverify
  • Oraenv
  • Orapwd
  • Sqldr
  • Tnsping
  • Wrap
  • Workshop with Scenarios
  • Assessments

Performance Tuning

  • Why Tuning?
  • SQL Tuning
  • Application Tuning
  • Tuning Sorts
  • Resizing SGA/PGA
  • Detecting I/O Issues
  • Latch Contention
  • DBMS_STATS
  • Configuration Statspack and AWR
  • Levels Of Tracing
  • Active Session Histroy
  • SQL tuning Advisor
  • SQL Access Advisor
  • 10046 and 10053 trace events
  • Using TKPROF
  • Interpreting AWR And Statspack
  • Optimizer Modes And Paramaters
  • Network Tuning
  • OS Tuning
  • Workshop with Scenarios
  • Assessments

Patching And Upgradation

  • Oracle 9i To 10g to 11g Upgradation
  • Version migration(10.2.0.1 to 10.2.0.4)
  • Implementing Opatch
  • Workshop with Scenarios
  • Assessments

Oracle Security

  • Db Vault
  • Fine Grain Access Control (FGA)
  • VPD Policies
  • Workshop with Scenarios
  • Assessments

Dataguard

  • Dataguard Architecture
  • Protection modes
  • Configuration physical standby
  • Configuration logical standby
  • Switchover and failover
  • Cascaded standby Database

Other Utilities

  • Using Quest Toad
  • Using ERWIN (Data modeling)
  • Using putty and Xmanager tolls
  • Workshop with Scenarios
  • Assessments

Real Time Environmental Training

  • Seminars/Tips from Corporate DBAs
  • Various DBA Environment Discussion
  • Resume Preparation
  • Mock Inverviews from Corporate DBAs