Show sessions

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

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

Details about the active SQL

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.

%d bloggers like this:
search previous next tag category expand menu location phone mail time cart zoom edit close