Tim Hall MasterClasses - Oracle PL/SQL Tuning

Tim Hall - Oracle Certified Professional (OCP)This 2-day MasterClass contains everything you need to know about performance tuning of PL/SQL applications. Be there 14-15 September in Brussels OR 17-18 September in Utrecht!

Tim Hall – Oracle Certified Professional (OCP) – will be introducing you to the current best practices for PL/SQL performance, many of which can be implemented in existing applications and result in "quick fixes" for performance problems. Each case is illustrated with a simple example demonstrating the performance improvements associated with the best practice.

Then, the more complex best practices, such as array processing, data caching and memory management are covered in greater detail, allowing the attendees to understand not only the technicalities, but also the practical implications of using such methods.

Alternative methods for packaging and presenting data are discussed, including cursor variables and REF CURSOR types, along with table functions and pipelining. These techniques will be used to show how a PL/SQL API layer can be used to turn a RAD tool, in this case Oracle Application Express (APEX), into a serious enterprise development tool. The methods of monitoring and profiling PL/SQL to identify problem code are demonstrated, so that performance tuning can be focused onto the areas where it is most needed.

By the end of the seminar attendees will be confident they can identify what they need to do to bring ailing PL/SQL applications up to date, as well as making sure new application are "right first time".

NOTE: This MasterClass is not intended for teaching PL/SQL for first-time users!!! Read all the information on the Miracle Benelux website.

Comments:

Hi Tim,

Can you do SFTP using oracle database, Like the you created for FTP.
Can you guild me on this.

Regards
Asis

Posted by Asis on April 04, 2013 at 09:20 PM PDT #

Asis,
In order to get in touch with Tim Hall, you should click on his name in the post above and you will be taken to his blog. You will be able to contact him from there.

Regards,
Brandye Barrington

Posted by Brandye Barrington on April 11, 2013 at 08:59 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Official blog of the Oracle Certification Program

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
4
5
6
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today