Training Lot, Bandal Dhankude Plaza, Office No.
25 & 31, B Wing, Kothrud Depo, Pune- 411 038
Oracle Exadata with RAC DBA Training Course Outline
Instructor : Anshu Singare
Requirements :
Hardware :
1. 100 GB Hard disk storage
2. 2 / 2+ CPU
3. 8 / 8+ GB RAM
4. Microphone & speaker for trainer
Software :
1. Oracle database 12c / 11g located on Exadata machine @
http://www.oracle.com/technetwork/database/enterpriseedition/downloads/index.html
2. Oracle VirtualBox (Version 4.3.12) @
https://www.virtualbox.org/wiki/Downloads
3. VMWare player (Any version after version 6) @
https://my.vmware.com/web/vmware/free#desktop_end_user_computing/v
mware_player/6_0
4. Putty (or another SSH client) @ http://www.putty.org/
5. Web browser (Firefox / IE / Chrome)
6. Internet connectivity
Setup (Required, if customer provides own environment for training) :
1. On Exadata Box : An OS user to be used for training, say ostrng
2. Exadata Database : Create a new DB on Exadata box, using the new OS
user
3. Exadata Database : Create multiple database schemas for each trainee +
1 for trainer , say user1, user2, .
4. OEM 12c (Oracle Enterprise Manager) configured to manage the above
Exadata environment built for this training. An EM12c read-only account
will also do.
Contact : an_shoo@yahoo.co.in / Anshu.singare@gmail.com
Phone : +91-77605-36968 , Alt. : +1-719-776-9207
Training Lot, Bandal Dhankude Plaza, Office No. 25 & 31, B Wing, Kothrud Depo, Pune- 411 038
Schedule :
Total duration including 1 day for RAC : 6 days
The Workshop days are broken down as follows:
1. Day 1 Introduction
Exadata Overview, comparison with 11g database wherever suitable.
Hardware Components viz. Infiniband, Flash Cache, etc.
Software Components
Current Configurations
Monitoring from Admin / Development perspective
2. Day 1 Offloading and Smart Scan
Concepts
Smart Scan Prerequisites
Column Projection Optimization
Predicate Filtering Optimization
Other Offloading Optimizations
Column projection from OLAP perspective
3. Day 2 Troubleshooting Smart Scans
Smart Scan Disablers
Performance Statistics
Wait Events
Trace and SQL Monitor
Parameters
How to know smart-scan is happening
4. Day 2 Storage Indexes
Concepts
Storage Indexes Prerequisites
Low/High Values Optimization
Nulls Optimization
Storage indx. vs Oracle indexes, composite indexes replacement
Controlling SI
Contact : an_shoo@yahoo.co.in / Anshu.singare@gmail.com
Phone : +91-77605-36968 , Alt. : +1-719-776-9207
Training Lot, Bandal Dhankude Plaza, Office No. 25 & 31, B Wing, Kothrud Depo, Pune- 411 038
5. Day 3 - Exadata Smart Flash Cache
Concepts
Smart Flash Cache Optimization
Write-back Flash Cache
Exadata Snap cloning
DB virtualization
Controlling SFC
6. Day 3 - Hybrid Columnar Compression
Concepts
Compression Types, Index compression
HCC Mechanics
HCC Optimization
Controlling HCC
7. Day 4 - Exadata Parallel Operations
Concepts
Configurations
Auto DOP
Parallel Statement Queuing
In-Memory Parallel Execution in Exadata vs. traditional (no in-memory)
RAC vs single instance on Exa.
Dedicated vs multitenant (12c) : IORM context
DBFS for loading
Controlling parallelism
Sorting affected by queries ?
8. Day 4 - Exadata Performance analysis
AWR & ADDM Concepts
Generate AWR report
Examine an AWR report
Exadata wait events using AWR
SQL plan baselining / profiling - using EM
9. Day 5 - Exadata Command line
Introduction to CellCLI
Possibilities at cell / storage nodes
Experimenting with CellCLI all list options
Contact : an_shoo@yahoo.co.in / Anshu.singare@gmail.com
Phone : +91-77605-36968 , Alt. : +1-719-776-9207
Training Lot, Bandal Dhankude Plaza, Office No. 25 & 31, B Wing, Kothrud Depo, Pune- 411 038
CellCLI flashcache drop & recreate
CellCLI on multiple nodes
10. Day 6 - Oracle RAC (Real Application Clusters)
RAC architecture, concepts, utilities
Oracle ASM (Automatic Storage Management)
Database Cloning
Schema mirroring
Oracle Database Services with RAC
11. Day 6 Database maintenance
Tablespace management with UNDO . TEMP
Validation of invalid objects
Table locking / blocking mechanisms
Exadata health-check (Exachk / racchk)
Contact : an_shoo@yahoo.co.in / Anshu.singare@gmail.com
Phone : +91-77605-36968 , Alt. : +1-719-776-9207
