Presentation Title: Diagnosing IO Performance Problems
Speaker: Mr Wiktor Moskwa
Company: Credit Suisse
Presentation abstract: Learn how to diagnose IO bottlenecks and performance problems across different

layers of the IO stack, from Oracle database to storage solution.

To do it efficiently we will have to stop treating the IO subsystem as a black box

and follow the lifecycle of an IO request on its journey from Oracle process to

physical disks and back again.

The diagnostic part of the talk will make use of Linux command line tools, custom scripts,

SQL queries on dynamic performance views, ASH and historical AWR views.

Example solutions will be based on real life case studies.

Presentation begins: 04/12/2016 17:10
Presentation duration: 50
Presentation content level: 1 (1 = indepth, 5 = strategic overview)
Audience experience: Intermediate
Audience function: Product Expert, Product User
Speaker biography: While I started working with Oracle 9 years ago, I spent 5 years developing and designing software for embedded automotive systems and mobile devices. Now I'm back with Oracle technology and leading a small team of Oracle experts dedicated to performance tuning in Credit Suisse bank.
Related topics: Database: Automatic Storage Management (ASM) , Database: Performance & Internals , Database: SQL & PL/SQL
Hall: Hall 7A

Diagnosing_IO_Performance_Problems.zip1.0 MB04/12/2016 13:33:18