Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - Oracle: Application Development and Tuning


distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services


Oracle: Application Development and Tuning
DURATION: 4 days

FEE: $2,380

Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

There is a surcharge associated with training two or fewer students.


  • Programmer
  • Database Administrator
  • System Designer
  • System Analyst
  • IT Professional


    1. The Application Environment
      • Utilize the data dictionary to examine the architecture and database.
      • Use the Oracle utilities to load a database.
    2. Maintaining Data Integrity
      • Create a table for testing locking and read consistency.
      • There are several techniques for ending a transaction: 1- Issue a Rollback on the current transaction and review the results. 2- Examine what happens to the current transaction if a DDL statement is executed. 3- Examine what happens to the current transaction if the session is killed.
      • Experiment with the options available for maintaining read consistency.
      • Code DML for experimenting with a data lock.
    3. PL/SQL Programming Techniques
      • Code a program which uses a dynamic PL/SQL reference cursor.
      • Recognize the pitfalls to avoid with dynamic SQL.
    4. Oracle PL/SQL Extensions
      • Code the utilities which will improve performance and result in more efficient application maintenance.
    5. Improving Query Performance
      • Write and execute SQL using hints to determine when they should be used and the effects of hints.
    6. Tuning the Application
      • Use the Profiler API to profile run-time behavior and identify performance bottlenecks.
      • Oracle provides a Trace API for tracing the execution of programs on the server; trace the execution by subprogram or exception.
    7. SQL Statement Tuning
      • Change the execution plan for running queries without changing the code itself; this will serve to insulate an application execution plan against any structural changes or upgrades.
      • Utilize Stored Outlines for storing the execution plan in Oracle tables; this will later be referred to by the optimizer for executing the queries and optimizer plan stability.
    8. Tuning the Operating System
      • Adjust optimizer statistics and parameters.
      • Optimize the instance.

    Web-based Training   Blended Learning    


Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.