Re: Oracle Tools - Freeware That can show running queries

From: <rob_at_oraclewizard.com>
Date: Wed, 22 Jun 2016 18:13:35 +0000
Message-ID: <W1920822409130461466619215_at_atl4webmail07>

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 _at_navonpilot
youtube https://www.youtube.com/user/n4281k blog: http://www.oraclewizard.com
-----Original Message-----
From: Andrew Kerber [mailto:andrew.kerber_at_gmail.com] 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.'







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

Received on Wed Jun 22 2016 - 20:13:35 CEST