Skip to Main Content
Toad for Oracle Unleashed
book

Toad for Oracle Unleashed

by Bert Scalzo, Dan Hotka
July 2015
Intermediate to advanced content levelIntermediate to advanced
288 pages
7h 26m
English
Sams
Content preview from Toad for Oracle Unleashed

Using the PL/SQL Profiler

Profiling PL/SQL enables you to see how long your code took to execute and how long each line of code took to execute. This is important information to have when you’re tuning PL/SQL code or a complete set of related routines.

Starting with version 8i, Oracle can track statistics on the execution of SQL, including procedures and functions. Toad interfaces with the DBMS_PROFILE (you will need execute privileges for this package) package, giving you an easy way to track and compare your program statistics. This package then populates three tables in the user’s account:

Image PLSQL_PROFILER_RUNS

PLSQL_PROFILER_UNITS

PLSQL_PROFILER_DATA ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Toad for Oracle

Toad for Oracle

Dan Hotka
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern
Oracle in a Nutshell

Oracle in a Nutshell

Rick Greenwald, David C. Kreines

Publisher Resources

ISBN: 9780134131900Purchase book