For Oracle Developers: High performance PL/SQL

  • February 16, 2011 · 5:30 PM
  • Sydney Mechanics’ School of Arts

Presenter bio: Guy Harrison is a director of Research and Development at Quest Software, and has over 20 years of experience in database design, development, administration, and optimization. Guy is an Oracle ACE, and is the author of Oracle Performance Survival Guide (Prentice Hall, 2009) and MySQL Stored Procedure Programming (OReilly with Steven Feuerstein) as well as other books, articles and presentations on database technology. Guy is the architect of Quest's Spotlight® family of diagnostic products and has led the development of Quests Toad® for Cloud Databases. Guy can be found on the internet at www.guyharrison.net, on e-mail at [masked] and is @guyharrison on twitter. Abstract: Each release of the Oracle RDBMS is associated with dramatic improvements in PL/SQL performance. However, the ultimate performance of any PL/SQL program is still in the hands of the PL/SQL programmer. In this presentation we’ll examine trends in PL/SQL performance, look at tools to identify and tune problematic PL/SQL and examine PL/SQL performance best practices. Topics will include opportunities for improving SQL performance by using PL/SQL code, measuring and diagnosing PL/SQL performance issues, best practices for writing high performance PL/SQL and the use of new 11g optimizations to further turbo-charge application code.

Join or login to comment.

  • Antonio Ipili

    Excellent session. Thanks very much.

    February 18, 2011

  • Jack

    What a wonderful meeting!!!

    February 17, 2011

  • Milton Ingram

    Excellent advice for PL/SQL developers and DBAs

    February 17, 2011

  • Gary Myers

    Guy did an excellent job of highlighting the priority level for different tuning options.
    Great turnout. Glad to see the level of interest in PL/SQL.

    February 17, 2011

  • Victor Yim

    Guy highlighted a few areas that we should look at for PLSQL tuning.
    That is execellent.

    February 17, 2011

  • Geoffrey

    Reach very deep insight in a very short time. One of my best session of the meetup.

    February 17, 2011

  • Nuno Pinto do Souto

    Events like this one clearly show the added value the Sydney Meetup provides, compared to the "official UG channels".
    Thanks once again to Pythian and Yuri for helping to organize this.

    February 17, 2011

  • Yury Velikanov

    I am glad that I participated. It was very good PL/SQL performance related presentation. Guy gave many hints that could be used in real life. I would suggest anyone to listen to Guy next time you will have such opportunity.

    February 17, 2011

Our Sponsors

People in this
Meetup are also in:

Sometimes the best Meetup Group is the one you start

Log in

Not registered with us yet?

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy