Course Duration : 6 Weeks - Normal , 15 Days - fast track
Payment - Online/Offline Transactions
Mentor - 8+ years Exp
Using Webex Online with live instructions on Database
1. Architecture
Defining an Oracle Server, Database, Instance. Understanding Physical Structure, Memory Structure, Process Structure, Logical Structure, Execution of SQL Statements, User Session
2. Creating a New Database
Creating / deleting Database using OEM
3. 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
4. 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.
5. Storage Management
Creating, Maintaining tables using appropriate storage settings – initial, minextents, pctfree, etc
6. 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
7. Networking Overview
SQL *Networking (Configuring tnsnames and listener files).
8. 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
9.Backup and 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
10. Performance Tuning
Sizing of SGA – Shared Pool (Reuse Stmts., etc.), Buffer Cache, Redo Log Buffer Cache
Diagnostic and Tuning Tools – Alert Log File, Trace Files, TKPROF, Explain Plan, trcsess, Dynamic Performance Views, TIMED_STATISTICS parameter to collect statistics, STATSPACK
11. Oracle Installation
Oracle 9i on Red Hat Enterprise Linux 4/Windows
12. Oracle 10g New Features
ADDM, AWR, ASH
Flashback Features
Data Pump
Resumable Space Mgmt at Inst level Performance Tuning
ASM Database
RMAN Compressed backups
Temporary TS groups
TTS across Platforms
