Course details

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.

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
Updated on 08 November, 2015

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.
they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.
their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:
restructuring for competitiveness
productivity improvements through updating work processes to match new technology
managing outstheircing
strategic financial planning and engineering
their methodology is to:
Work closely with clients to understand and help them prioritise their needs
Design and deliver the best mix of training activities and consultancy to establish the competencies required
Provide ongoing coaching to sustain the improved practices and processes
they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.
their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.
See all Professional Training Solutions Ltd courses
Are you from Professional Training Solutions Ltd ? Claim your course!
Courses you can instantly connect with... Do an online course on Oracle starting now. See all courses

Is this the right course for you?

Rate this page

Didn't find what you were looking for ?

or