| Deep Dive Series - Oracle IO |
Claim your free video by clicking here -> Play
OraByte can prepare you for resolving complex IO Oracle ®issues in hours!
Deep-Dive-IO using Method-S
Method-S offers unique perspective and proven methodology to help you get handle on your most complex Oracle IO design, implementation and performance issues. In summary, you are getting Over 40 scripts and 51 video's with advanced ideas to help you embark on improving your IO subsystem.
Partial List of Oracle Performance Tuning IO Items Covered is:
# Tuning I/O: Top Down and Bottom Up
# Profile your Database for IO distribution
# Analyzing I/O Requirements
# Analyzing database effeciency
# Analyzing IOSTAT and HBA througput
# Planning File & ASM Storage
# Migration from Filesystem to ASM Storage
# Evaluating Device Bandwidth
# Designing I/O Layouts, LUNS, RAID, Striping
# ASM AU and Stripe size recommendation
# Mapping end to end IO flow and design
# Load Balancing and Striping
# I/O Rate: Read Rate and Write Rate
# I/O Concurrency
# IOPS, HBA and Throughput design and evaluation
# Using the Oracle Wait Interface to Troubleshoot I/O Issues
# TOP IO Wait Events in Oracle
# In-Depth study and recommendations on fixing FTS and FFS
# Advance Index tuning strategies and fixing db file sequencial waits, you think you got it right?
# Compensating for loss of OS cache, SGA and PGA adjustments from BUFFERED to DIRECT_IO
# AWR and ASH scripts and IO methods
# Understanding various IO sizes - ASM, OS, DB reads and writes and why 1MB is the magic number.
