Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Preparing for a Trace

Before you can use TKPROF, you must collect information about SQL statements into a trace file. To use the SQL Trace utility, you must have the following settings in the initialization file for the target Oracle database:

  • TIMED_STATISTICS must be set to TRUE. For Oracle9i Release 2, setting the STATISTICS_LEVEL parameter to TYPICAL or ALL will also collect timing statistics, and the value of DB_CACHE_ADVICE.TIMED_STATISTICS or TIMED_OS_STATISTICS will override the value set for STATISTICS_LEVEL.

  • MAX_DUMP_FILE_SIZE must be big enough to hold all the information written to the trace file.

  • USER_DUMP_DEST must point to a valid directory.

Tip

The SQL Trace utility writes all trace files to the USER_DUMP_DEST directory, so make sure you have a way to recognize your particular trace file.

All of these parameters are session parameters and can be changed dynamically with Oracle9i.

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 Internals

Oracle Internals

Donald K. Burleson
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

Publisher Resources

ISBN: 0596003366Errata Page