oradebug
There are various ways in which one session can affect how another session behaves. One of the oldest and easiest is the oradebug utility, which you can take advantage of if your account has sysdba privileges. Many of the things you can do with oradebug you can also do by setting events, so some of the tricks listed in this section will reappear in different guises later on.
Suspending Processes
Some of the things I did to get a better understanding of dbwr and lgwr required those processes to stop. Oradebug allows you suspend and resume a process. The first thing to do is to attach to an Oracle process, which I tend to do by using the pid from v$process. There are many simple queries you can write to find the process id for a background ...
Get Oracle Core: Essential Internals for DBAs and Developers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
