'Roger schrag database specialists' diaporamas de présentation

Tutorial HK: Configuring Oracle on Linux For Peak Performance

980 views • 87 slides

Interpreting Wait Events To Boost System Performance

Interpreting Wait Events To Boost System Performance. Roger Schrag Database Specialists, Inc. www.dbspecialists.com. NoCOUG Winter Conference February 21, 2002. Session Objectives. Define wait events Discuss how to use the wait event interface

799 views • 68 slides

How Much Do Concurrent Updates Impact Query Performance in Oracle?

How Much Do Concurrent Updates Impact Query Performance in Oracle? . Roger Schrag Database Specialists, Inc. www.dbspecialists.com. Today's Session. Read-consistency and concurrency: Basic concepts How Oracle does it Other approaches Theoretical cost of read-consistency in Oracle

756 views • 59 slides

Use EXPLAIN PLAN and TKPROF To Tune Your Applications

988 views • 56 slides

Wait Event Enhancements in Oracle 10g

710 views • 56 slides

Finding the Performance Bottlenecks in Your Application

Finding the Performance Bottlenecks in Your Application. Ian Jones and Roger Schrag Database Specialists, Inc. www.dbspecialists.com IOUG-A Live! 1999 Paper #158. Finding the Bottleneck: Half the Battle in Tuning. One bad SQL statement can spoil performance

497 views • 36 slides

What You Can Do When Your Database Runs out of Temp Space

What You Can Do When Your Database Runs out of Temp Space. Roger Schrag Database Specialists, Inc. www.dbspecialists.com. Today's Session. Oracle sorting basics Identifying SQL statements that fail Diagnostic event 1652 Monitoring temporary space usage Temporary segments

540 views • 31 slides

How Are The Challenges Different for Internet DBAs?

312 views • 20 slides