If you want 3rd party software there is DBArtisan from Embarcadero.
It will show you what is the current SQL being executed by a particular session.