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