Andrew, SQL Developer is the way to go.
Click View -> DBA -> connect to database -> instance viewer -> double click
sessions
it gives you all the information you need. I use it on 10g - 12c. There are
some niggles in 10G that don't apply to your use case. Best things are: 1) it's
free and 2) very easy to use. I've gotten two customers off of Toad and on to
SQL Developer in the past year and they are raving about it.
-Rob
===================================
Robert P. LockardOracle ACEWinner of the 2015 Oracle Developers Choice Award
for Database DesignPresident Oraclewizard.com, Inc.
The question is not “who is going to let me,” it's “who is going to stop me."
Ayn Rand
(cell) 571.276.4790
(office) 410.766.6960
(fax) 410.766.0332
twitter @navonpilot
youtube https://www.youtube.com/user/n4281k
blog: http://www.oraclewizard.com
-----Original Message-----
From: Andrew Kerber [mailto:andrew.kerber@xxxxxxxxx]
Sent: Wednesday, June 22, 2016 10:56 AM
To: 'ORACLE-L'
Subject: Oracle Tools - Freeware That can show running queries
I know we have had this discussion before, but I am specifically looking for
just one thing. In the Oracle 10g client we had the nice java window that would
show all the running queries on the database, and allow you to look at the
query, and the explain plan, and kill the query if you had appropriate
privileges.
This behavior was moved out of the client and into the massive footprint of oem
cloud control in later versions. Is there any software out there that I can run
that will show just that, the running queries on the database, and allow me to
kill them if I am logged in with the appropriate privileges?
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'