I'd like to mention a small peace of software. It's called MrTrace and available in Version 188.8.131.52 right now. For me it's a tool to save time. So what is it doing at all?
MrTrace is a plugin for Oracles SQL Developer to access tracefiles via SQL Developer. It's previous version could only access the tracefile for the statement you just executed. But since version 2 you anyone with the right permissions access any tracefile in the trace directory.
For a DBA it does not sound spectacular to access tracefiles, but it can be quite annoying to get and (more...)