O'Reilly logo

Pro Ora cle Database 10g RAC on Linux Installation, Administration, and Performance by Steve Shaw, Julian Dyke

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 21. Trace and Diagnostics

In this chapter, we will discuss methods for obtaining trace and diagnostic information from a RAC cluster. This chapter covers trace file locations, DBMS_MONITOR, and ORADEBUG.

DBMS_MONITOR is a package that was introduced in Oracle 10.1 that greatly simplifies and standardizes the commands required to enable and disable trace.

ORADEBUG is an undocumented utility, invoked from SQL*Plus, which allows users with the SYSDBA privilege to obtain a significant amount of additional trace and diagnostic information. A subset of this information is also available using the ALTER SESSION and ALTER SYSTEM commands.

Trace File Locations

In this section, we will discuss the locations where trace and diagnostic information is ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required