Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShareBuy Print Version
    Oracle 9i Advanced PL/SQL Programming

    • Oracle 9i Advanced PL/SQL Programming

    • By:

    • Publisher: Sideris Courseware Corp.

    • Pub. Date:

    • Print ISBN: ORA05DEV9i04SG

    • Pages in Print Edition: 398

    • Subscriber Rating: 0 out of 5 rating0 [0 Ratings]

    1ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    The objective of this course is to allow PL/SQL developers to write efficient and tuned programs. Performance techniques, problem areas and troubleshooting tools are all presented. Please note: This course is alternately named Oracle 9i PL/SQL Application Tuning.

    Subscriber Reviews

    Average Rating: 0 out of 5 rating Based on 0 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     

    View Sample
    Oracle 9i Advanced PL/SQL Programming
    View Sample

    Copyright

    View Sample

    Table of Contents

    View Sample
    Section 1: Course Introduction
    View Sample

    Objectives

    View Sample

    About This Course

    View Sample

    About The Sample COMPANY Database

    View Sample

    Workshop Section Course Introduction

    View Sample

    Workshop System Requirements

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 2: Understanding The Tuning Issues
    View Sample

    Objectives

    View Sample

    The Difficulty Of Tuning

    View Sample

    The SQL & PL/SQL Execution Environment

    View Sample

    The Impact Of The Systems Infrastructure

    View Sample
    Section 3: Using TKPROF & AUTOTRACE
    View Sample

    Objectives

    View Sample

    About The Tuning Utilities

    View Sample

    Using TKPROF

    View Sample

    Using AUTOTRACE

    View Sample

    Workshop Section Using TKPROF & AUTOTRACE

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 4: Using The Statspack Utility
    View Sample

    Objectives

    View Sample

    About The Statspack Utility

    View Sample

    Setting Snapshot Levels & SQL Thresholds

    View Sample

    Maintaining The Statistics Performance Tables

    View Sample

    Workshop Section Using The Statspack Utility

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 5: Exploiting & Managing Cursor Sharing
    View Sample

    Objectives

    View Sample

    About Cursor Sharing

    View Sample

    Bind Variables & Cursor Peeking

    View Sample

    Using The CURSOR_SHARING Parameter

    View Sample
    Section 6: Using Cursor Variables
    View Sample

    Objectives

    View Sample

    About Cursor Variables

    View Sample

    Using Cursor Variables

    View Sample

    Using SYS_REFCURSOR

    View Sample

    Workshop Section Using Cursor Variables

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 7: Invoking External Procedures
    View Sample

    Objectives

    View Sample

    About External Procedures

    View Sample

    Registering With The Database

    View Sample

    Oracle Net Configuration

    View Sample

    Calling External Procedures

    View Sample

    Workshop Section Invoking External Procedures

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 8: Advanced Program Units
    View Sample

    Objectives

    View Sample

    About Advanced Program Units

    View Sample

    Using Invoker Rights

    View Sample

    Native Dynamic SQL

    View Sample

    Autonomous Transactions

    View Sample

    Workshop Section Advanced Program Units

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 9: Using Collections
    View Sample

    Objectives

    View Sample

    About Collections

    View Sample

    Bulk Bind Using Collections

    View Sample

    Collection Methods

    View Sample

    Workshop Section Using Collections

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 10: PL/SQL Tuning With DBMS_PROFILER()
    View Sample

    Objectives

    View Sample

    About DBMS_PROFILER()

    View Sample

    Installing DBMS_PROFILER()

    View Sample

    Using DBMS_PROFILER() To Manage Runs

    View Sample

    Examining The Profiler Tables

    View Sample

    Workshop Section PL/SQL Tuning With DBMS_PROFILER()

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 11: Evaluating The PL/SQL Profiler Data
    View Sample

    Objectives

    View Sample

    About The Profiler Data

    View Sample

    User Queries Of The Cross Run Tables

    View Sample

    System-Supplied Cross Run Tables Queries

    View Sample

    Workshop Section Evaluating The PL/SQL Profiler Data

    View Sample

    Exercises

    View Sample

    Solutions

    View Sample
    Section 12: PL/SQL Tuning Techniques
    View Sample

    Objectives

    View Sample

    Using NOCOPY For Parameters

    View Sample

    Using The RETURNING Clause

    View Sample

    Choosing The Optimum Datatype

    View Sample

    Useful PL/SQL Coding Techniques

    View Sample
    Section 13: PL/SQL Debugging With DBMS_TRACE()
    View Sample

    Objectives

    View Sample

    About The Trace Facility

    View Sample

    Installing DBMS_TRACE()

    View Sample

    Using DBMS_TRACE() To Manage Runs

    View Sample

    Examining The PLSQL_TRACE ... Tables

    View Sample

    Workshop Section PL/SQL Debugging With DBMS_TRACE()

    View Sample

    Exercises

    View Sample

    Solutions

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Windows version files

    • extras.zip