Re: Oracle Tools - Freeware That can show running queries

SQL Developer and SQLcl are sweet, but my all time favorite tool :) is Tanel's ashtop (DIAG pack license does apply)

http://blog.tanelpoder.com/files/scripts/ash/ashtop.sql

>>> top 20 SQLs running in the last minute
SQL> _at_ashtop sql_id "session_type='FOREGROUND'" sysdate-1/60/24 sysdate

    Total
  Seconds AAS %This SQL_ID FIRST_SEEN LAST_SEEN     DIST_SQLEXEC_SEEN

--------- ------- ------- ------------- -------------------
------------------- -----------------
       42      .7   13% | 8dfpzb2zcd0b1 2016-06-22 12:48:44 2016-06-22
12:49:43                39
       39      .7   12% |               2016-06-22 12:48:45 2016-06-22
12:49:40                 1
       23      .4    7% | 04fqpz7dx017m 2016-06-22 12:48:45 2016-06-22
12:49:41                 2
       22      .4    7% | 9hbdta6bzbwgp 2016-06-22 12:48:47 2016-06-22
12:49:37                22
       19      .3    6% | d6c22h0yj78sr 2016-06-22 12:48:44 2016-06-22
12:49:40                19
       16      .3    5% | 2skwhauh2cwky 2016-06-22 12:48:47 2016-06-22
12:49:43                11
       14      .2    4% | 5nvv2uwj6df0f 2016-06-22 12:48:49 2016-06-22
12:49:43                14
       12      .2    4% | 2jfqzrxhrm93b 2016-06-22 12:48:50 2016-06-22
12:49:40                 5
       11      .2    3% | cuua5znsjkdps 2016-06-22 12:48:50 2016-06-22
12:49:42                11
        9      .2    3% | f2yr0jkvga2v4 2016-06-22 12:48:44 2016-06-22
12:49:36                 2
        8      .1    2% | 8wyh705n6yjgy 2016-06-22 12:48:59 2016-06-22
12:49:35                 8
        8      .1    2% | cnf77vn34f2jw 2016-06-22 12:48:52 2016-06-22
12:49:37                 6
        7      .1    2% | 76nym0mhs3txk 2016-06-22 12:48:56 2016-06-22
12:49:34                 1
        5      .1    2% | 0b98m1dkpqp4u 2016-06-22 12:48:50 2016-06-22
12:49:41                 5
        5      .1    2% | 6xf7w6w937ga8 2016-06-22 12:48:53 2016-06-22
12:49:42                 5
        5      .1    2% | a3ng095bt6qqv 2016-06-22 12:48:52 2016-06-22
12:49:37                 5
        5      .1    2% | bvqb79b0m8ywt 2016-06-22 12:48:45 2016-06-22
12:49:31                 1
        5      .1    2% | d3hgxyvc8vnbx 2016-06-22 12:48:52 2016-06-22
12:49:43                 1
        4      .1    1% | 95zq8ah8xttcz 2016-06-22 12:48:55 2016-06-22
12:49:31                 4
        4      .1    1% | ay39m2h9x83ws 2016-06-22 12:48:51 2016-06-22
12:49:39                 4

20 rows selected.

Then you can use dplan and session detail scripts to do the other stuff you'd like. Plus you get the added advantage of having everything properly logged :)

Andy K

On Wed, Jun 22, 2016 at 12:09 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> Sure. One that runs with the oracle client preferably, but is primarily
> monitoring software without a lot of other functionality to navigate
> through to get to the screen of interest. I dont want to have to go
> through a two hour class to explain to the people I give the tool how to
> use it.
>
>
>

--
http://www.freelists.org/webpage/oracle-l