There’s a nice Metalink Note 438452.1 about various less known Oracle performance tuning utilities.
If you haven’t heard about things like StackX, LTOM, HangFG, SQLTXPLAIN, OS_Watcher or OPDG then it’s time to check this note out! :)
Tanel Poder's blog: IT & Mobile for Geeks and Pros
Oracle, Exadata, Performance, Troubleshooting - Mobile Life and Productivity.
Looking at this lenghty list one may wonder why so many exists as they are all based on sqlplan and event 10046. I would gladly exchange half of those variations-on-a-theme against a single one deals with the 10053.
The PL/SQL profiler is the only one that does something unique.