For many years DBAs have been getting low level tracing information about session through the creating and reading of Oracle generated trace files. These trace files can be generated against a full system load or individual sessions. The types of information generated by these traces in Table 1 clearly show why they have been used for many years. There just wasn’t an easy way to get this information from within Oracle’s internal views.  While Oracle 10g has provided quite a few mechanisms to trace the session by querying internal views, the generation of trace files is still around and still quite viable. In addition Oracle 10g allows us to generate trace files and analyze them with added functionality. This article will focus in on how we can generate trace files in Oracle 10g.

Read more at: Oracle Session Tracing Part V