Managing Dependencies


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number


Overview/Description
To manage dependencies and recompile PL/SQL units

Target Audience
Database administrators, application developers, and database operators

Prerequisites
Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases, the SQL programming language, and stored procedures; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration (hours)
1.4

Lesson Objectives

Managing Dependencies

  • retrieve local dependency information for a given scenario.
  • set an appropriate remote dependency mode in a given scenario.
  • display and interpret local dependency information and set a remote dependency mode.
  • explicitly recompile a PL/SQL program unit and recognize when a recompilation is successful.
  • identify the best practices used to minimize recompilation and simplify dependency management between packages and standalone procedures.

    • Course Number:
    216717_eng