Performance Tuning APEX Applications with Scott Spendolini

Performance Tuning APEX Applications is written for those that are writing and maintaining applications which are core to the success of their business. 

The course starts out by discussing the core concepts of performance tuning and introduces a concrete methodology for diagnosing the root cause of any performance problem.  It then introduces tools and techniques, both inside and outside of APEX, that can be used to identify, diagnose and address performance problems.

Students will have the opportunity to use what they have learned to identify and diagnose performance problems in a live application. 

Course Topics
Principles of Performance Tuning
  • Defining Performance 
  • When to Tune Performance
  • What Information IS Needed to Tune Performance
Cultivating Good Performance Habits
  • Good Installation Habits
  • Understanding How APEX Works
  • Working With the APEX Architecture
  • APEX Code Intsturmentation
Monitoring your APEX Application's Performance
  • Being Proactive in Monitoring Performance
  • APEX Built-In Monitoring Tools
  • Using SQL Developer to Monitor APEX Performance
Built-in Diagnosis Tools
  • Making the most of DEBUG mode
  • #TIMING# as a Diagnosis Tool
  • Isolation Page Items
  • Reporting on MODULE and ACTION
Diagnosing Un-Instrumented Code
  • Diagnosing Performance From the Browser
    • FireBug
    • YSlow
  • Diagnosing Performance From PL/SQL
    • DBMS_TRACE
    • DBMS_PROFILER
    • DBMS_HPROF
Instrumenting Your PL/SQL
  • Basic Instrumentation
    • DMBS_OUTPUT
    • Inserting into a table
    • Setting MODULE and ACTION
  • Using 3rd Party Libraries
    • QEM
    • ILO
Using 10046 Level 12 Trace Data
  • Introduction to 10046 Level 12
  • Interpreting Trace Data
    • TKPROF
    • SQL-DEVELOPER
    • PROFILER
  • 10046 and APEX
Coding For Performance - Best Practices
  • Fundamentals of SQL & PL/SQL Execution
  • The Logical Order of Code
  • Considerations When Choosing Data Types
  • Bind Variables
  • Bulk Operations
  • Ref Cursors
Performance Tuning APEX Applications with Scott Spendolini
  • Item #: APEX004
Price $1,200.00
Availability Out-of-Stock