Oracle Performance for Developers

Oracle Performance for Developers is a one-day course for application developers that helps you create faster, more scalable Oracle applications.

Course overview

Developers are often taught to treat the database merely as a "data store," a black box that the developer should neither want nor need to understand. However, two facts that we observe over and over again in the field lead to an inevitable contradiction:

  • By far the most important performance leverage in any application is in the hands of those who design and write the application.
  • Developers who have an appreciation for how the Oracle Database works write better applications that go faster, require less hardware, and make people happier.

This course approaches Oracle Database performance directly from the developer's perspective. It shows how the code path you create influences the performance of your software. It shows bad and good ways to accomplish the same specifications, using examples from several different application development languages. It teaches you how to find out for yourself whether the code you're writing is efficient.

This is not a features course with version-specific tips that evaporate over time. It is a fundamentals course that opens your eyes to smarter ways of using the Oracle Database so that it will provide services to your software more quickly and with less overhead than you may have thought possible.

Pricing

List price: $625 USD

Course agenda

Oracle performance overview

  • Performance is response time, response time is code path
  • Oracle Call Interface (OCI) model
  • Instrumenting your code

Oracle code paths

  • Preparing SQL
  • Fetching rows
  • Buffer access (logical and physical I/O)
  • Connecting and disconnecting
  • Network I/O

Case studies

Discussion and conclusions

Course at a Glance

Watch this informational video from Cary Millsap

Audience
Application software developers who are interested in making their Oracle-based applications faster and more efficient

Duration
1 day

Format
Instructor-led, lecture-based seminar, no hands-on labs, conducted in English

Software versions
Course material is applicable to Oracle Database versions 7 through 11g

Software language
Non-specific. Examples include Java, PHP, Perl, Visual Basic, and PL/SQL
 
Home Education Oracle Performance for Developers
Joomla Templates by Joomlashack