Company Profile Newsletter IT Training Business Training Coaching Consulting Schedule Accreditations Contact Us
Popular Topics:
SharePoint Training Crystal Reports Training Photoshop Training Oracle Training Microsoft Excel Training
Project Management Training Finance Training Effective Management Training
Java Programming
Print PageOracle Database 10g: Advanced PL/SQL Programming & Tuning
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
View other Oracle Courses available
- Cost: Price on application
- Duration: 4 days
- This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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
• managing invalid objects
Dynamic sql :
• about cursor sharing
• bind variables & cursor peeking
• using the cursor_sharing parameter
• bind variables & cursor peeking
• using the cursor_sharing parameter
Using collections :
• about collections
• bulk bind using collections
• collection methods
• bulk bind using collections
• collection methods
Retrieving ddl with dbms_metadata() :
• why retrieve object definitions?
• retrieving default metadata
• retrieving customized metadata
• retrieving default metadata
• retrieving customized metadata
Advanced dbms_metadata() processing :
• set_transform_param()
• get_query()
• get_query()
Processing dependent objects with dbms_metadata() :
Redefining tables with dbms_redefinition() :
• about table redefinition
• using the dbms_redefinition() package
• using the dbms_redefinition() package
Using other system-supplied packages :
• dbms_describe()
• utl_mail
• dbms_scheduler()
• utl_mail
• dbms_scheduler()
Using large objects (lobs) :
Advanced interface methods :
• about external procedures
• registering with the database
• oracle net configuration
• calling 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
• 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
• 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
• 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
• 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
• 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
• installing dbms_trace()
• using dbms_trace() to manage runs
• examining the plsql_trace_... Tables