Skip to Main Content
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
book

Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

by Sam R. Alapati, Darl Kuhn, Bill Padfield
August 2011
Intermediate to advanced content levelIntermediate to advanced
594 pages
15h 54m
English
Apress
Content preview from Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach

C H A P T E R  10

Tracing SQL Execution

Tracing session activity is at the heart of most SQL performance tuning exercises. Oracle provides a rich set of tools to trace SQL activity. This chapter introduces the Oracle SQL trace facility and shows you how to set up SQL tracing in your environment. Oracle provides numerous “events” that help you perform various types of traces.

Although there are several tracing methods available, Oracle now recommends that you use the DBMS_MONITOR package for most types of tracing. The chapter contains several recipes that explain how to use this package to generate traces. In addition, we show how to trace sessions by setting various Oracle events, the setting of which is often requested by Oracle Support. You'll ...

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

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition

RMAN Recipes for Oracle Database 12c: A Problem-Solution Approach, Second Edition

Darl Kuhn, Sam Alapati, Arup Nanda

Publisher Resources

ISBN: 9781430236627Purchase book