Presentation: "Oracle Troubleshooting and Tuning for Developers"
Track:
Relational Databases
Time:
Monday 11:00 - 12:00
Location:
SAS Nortvegia
Abstract: "Fix the database!" "Write better code!" If you listen closely in many
IT departments, you can hear the battle cries of the development and DBA
staffs. As the pressure for faster response time increases along with
the variety of development languages and tools, the gap between the
application developer and database engineer grows wider. This session
will cover the basics of the wait interface, extended SQL trace and
TKPROF, the explain plan myth, and identifying inefficient SQL
operations using Method R and Throw Away. The goal is to introduce basic
optimization and troubleshooting topics and to establish a common ground
of understanding to enable developers and designers to interact more
effectively with database administrators when troubleshooting and tuning.
Download slides
Daniel Fink is a Senior Oracle Database Engineer and independent
consultant, specializing in Oracle internals, troubleshooting and
optimization. He started as a DBA on Oracle 7.0.16 running Parallel
Server on OpenVMS and has experience on major Unix platforms and
releases up to 10G. He is a member of the Oak Table network, highly
regarded presentor and trainer. He maintains a library of his research
at optimaldba.com and can be reached at Mail:
daniel.fink@optimaldba.com.
