Re: Oracle Tools - Freeware That can show running queries
Date: Wed, 22 Jun 2016 12:30:38 -0400
Message-ID: <576ABD2E.9000509_at_gmail.com>
Oracle SQL*Developer should satisfy all of the requested functionality, but in case it isn't good enough, you can try with tora: https://github.com/tora-tool/tora/wiki. It started as a free Toad clone, but has developed into something very useful by itself. Regards
On 06/22/2016 12:09 PM, Andrew Kerber 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.
>
> On Wed, Jun 22, 2016 at 11:01 AM, Jeff Smith <jeff.d.smith_at_oracle.com 
> <mailto:jeff.d.smith_at_oracle.com>> wrote:
>
>     So not just any free software out there, but one that is
>     ‘lightweight.’
>
>     Can you please define, lightweight?
>
>     *From:*Andrew Kerber [mailto:andrew.kerber_at_gmail.com
>     <mailto:andrew.kerber_at_gmail.com>]
>     *Sent:* Wednesday, June 22, 2016 11:49 AM
>     *To:* l.flatz
>     *Cc:* ORACLE-L
>     *Subject:* Re: Oracle Tools - Freeware That can show running queries
>
>     I am aware of that one. However, I was really looking for
>     something a little more lightweight, preferable something that
>     pretty just has a session viewer.
>
>     On Wed, Jun 22, 2016 at 10:36 AM, l.flatz <l.flatz_at_bluewin.ch
>     <mailto:l.flatz_at_bluewin.ch>> wrote:
>
>     How about sql developer session viewer?
>
>     Von meinem Samsung Gerät gesendet.
>
>
>
>     -------- Ursprüngliche Nachricht --------
>     Von: Andrew Kerber <andrew.kerber_at_gmail.com
>     <mailto:andrew.kerber_at_gmail.com>>
>     Datum: 22.06.16 16:56 (GMT+01:00)
>     An: ORACLE-L <oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>>
>     Betreff: 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.'
>
>
>
>
>     -- 
>
>     Andrew W. Kerber
>
>     'If at first you dont succeed, dont take up skydiving.'
>
>
>
>
> -- 
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
-- Mladen Gogala Oracle DBA http://mgogala.freehostia.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 22 2016 - 18:30:38 CEST
