Database Reference
In-Depth Information
Page reclaims = 66357
Page faults = 1
…
Voluntary context switches = 2775
Involuntary context switches = 65892
Lessons Learned
The
ORADEBUG
command in SQL*Plus is an indispensable tool for troubleshooting and diag-
nosing performance problems. The basic workflow consists of attaching to a process, setting
an event or performing a diagnostic dump, retrieving the trace file name, and detaching.
ORADEBUG
provides access to information that is not available by any other means. The events set in a
process or session are an example of this. This chapter covered some of the most useful and
commonly used
ORADEBUG
commands. Many more features, such as
ORADEBUG
LKDEBUG
for invoking
the global enqueue service debugger in a RAC environment, exist.
