There's the query plan analyzer built into SQL Developer, though I'm not sure if that's what you're looking for
Was looking more for an interactive parser similar to the above that does a good job of breaking down each join and which ones stand out as larger problems from everything else (visually). Even with Query Plan Analyzer / DBMS_XPLAN it can get pretty hectic, especially when it starts introducing bitmap and hash joins, and if you have a lot of tables even the indented table tree view can be unwieldy after a certain depth.
We're a place where coders share, stay up-to-date and grow their careers.
We strive for transparency and don't collect excess data.