Managing Dependencies

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.