So this is easy. Most tools will do it. But what if you’re at the command line, with only SQL*Plus or sqlcl available?
git clone https://github.com/johnthomas22/SQLUtils
At your SQL prompt, type @sess. You’ll see a prompt allowing you to tweak the sort order.
For convenience you can set SQLPATH to include the location of utilities.
export SQLPATH=/home/oracle/SQLUtils
Pressing / <CR> repeatedly will show you things like “rows processed” and elapsed and CPU seconds for long-running SQLs. Almost, but not quite, a command-line live trace.
