Skip to Main Content
Toad Pocket Reference for Oracle, 2nd Edition
book

Toad Pocket Reference for Oracle, 2nd Edition

by Jeff Smith, Patrick McGrath, Bert Scalzo
May 2005
Intermediate to advanced content levelIntermediate to advanced
130 pages
4h 31m
English
O'Reilly Media, Inc.
Content preview from Toad Pocket Reference for Oracle, 2nd Edition
78
|
Toad Pocket Reference for Oracle
After Debugging
When you complete a debugging session, there is one final
step you need to perform in order to clean up the Debug-
ger’s symbol table. Toggle off the “Toggle compiling with
debug” button and compile your stored program once more.
It will now recompile without the debug symbol tables. This
is especially important on production systems as the debug
symbols can adversely affect your code’s performance.
Code Profiling
Code Profiling is an extremely powerful tool that can be used
by developers to identify bottlenecks and code execution
problems. Toad uses the Oracle Probe Profiler API to collect
performance data on PL/SQL applications. This feature is
included in the Toad for Oracle Standard Edition. To use
this feature, you must first verify that you have the DBMS_
PROFILER package (created by Oracle’s PROFLOAD.sql
script). Then use Tools
ServerSide Object Wizard to cre-
ate Toad’s Profiler tables.
Toggle Database
PL/SQL Profiling on and then execute
your stored program. The Profiler prompts you to name each
run (execution). As each run completes, the Profiler Analysis
window displays performance data for each line of code.
Because this information is stored in database tables, you will
be able to run ad hoc queries and customize your own
reports. The reports will be viewable from the menu (shown
in Figure 17) invoked from Database
Profiler Analysis.
Using ...
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

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

Robert Freeman, Matthew Hart
Oracle Database 11g A Beginner's Guide

Oracle Database 11g A Beginner's Guide

Ian Abramson, Michael Abbey, Michael Corey

Publisher Resources

ISBN: 9780596529079