Re: Oracle Tools - Freeware That can show running queries

I have checked it out. I even reported 2 bugs to Jeff Smith directly. I love SQLcl, but I doubt that SQLcl is what the original poster asked about. Regards

On 06/22/2016 01:16 PM, Dominic Brooks wrote:
> Check out SQLcl.
>
> Sent from my Windows Phone
> ------------------------------------------------------------------------
> From: Mladen Gogala <mailto:gogala.mladen_at_gmail.com>
> Sent: ‎22/‎06/‎2016 17:32
> To: oracle-l_at_freelists.org <mailto:oracle-l_at_freelists.org>
> Subject: Re: Oracle Tools - Freeware That can show running queries
>
> 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
> <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

-- 
Mladen Gogala
Oracle DBA
http://mgogala.freehostia.com


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