Learning is not a spectator sport

The more I use SQL Macros, the more I think they are a great feature for building simply little utilities to make life easier for the DBA (or developer). For example, ever wanted to access your current session trace file from within the session? It is relatively straightforward to do: query v$diag_info for the name…