Oracle Database 10g: Advanced PL/SQL Programming & Tuning

Request more details:

Description:
The objective of this course is to allow experienced PL/SQL developers to write efficient programs. Advanced techniques which not only improve execution speed but also enhance the functionality of the programs are also discussed. Objectives: -Exploiting and managing cursor sharing. -Utilizing cursor variables. -Invoking external procedures. -Including dynamic SQL and other advanced programming techniques. -Efficiently executing dynamic SQL using bulk bind techniques. -Tuning with the DBMS_PROFILER() system-supplied package. -Debugging with the DBMS_TRACE() system-supplied package. -Performance tuning and analysis of PL/SQL applications.

View other Oracle Courses available
Prerequisites:
Mandatory Pre-Requisites: Oracle Database 10g: Introduction to SQL - Complete Library and Oracle Database 10g: Program With PL/SQL - Complete Library
Pl/sql development support from em :
about em & pl/sql
managing invalid objects
Dynamic sql :
about cursor sharing
bind variables & cursor peeking
using the cursor_sharing parameter
Using collections :
about collections
bulk bind using collections
collection methods
Retrieving ddl with dbms_metadata() :
why retrieve object definitions?
retrieving default metadata
retrieving customized metadata
Advanced dbms_metadata() processing :
set_transform_param()
get_query()
Processing dependent objects with dbms_metadata() :
Redefining tables with dbms_redefinition() :
about table redefinition
using the dbms_redefinition() package
Using other system-supplied packages :
dbms_describe()
utl_mail
dbms_scheduler()
Using large objects (lobs) :
Advanced interface methods :
about external procedures
registering with the database
oracle net configuration
calling external procedures
About pl/sql performance tuning :
about the tuning effort
the difficulty of tuning
the sql & pl/sql execution environment
the impact of the systems infrastructure
Using the tuning utilities :
Influencing oracle10g pl/sql compilation :
plsql_warnings
plsql_optimize_level
pl/sql native execution
Pl/sql tuning with dbms_profiler() :
about dbms_profiler()
installing dbms_profiler()
using dbms_profiler() to manage runs
examining the profiler tables
Evaluating the pl/sql profiler data :
about the profiler data
user queries of the cross run tables
system-supplied cross run tables queries
Pl/sql advanced programming & tuning techniques :
autonomous transactions
using nocopy for parameters
choosing the optimum datatype
useful pl/sql coding techniques
Pl/sql debugging with dbms_trace() :
about the trace facility
installing dbms_trace()
using dbms_trace() to manage runs
examining the plsql_trace_... Tables