RE: Oracle Tools - Freeware That can show running queries
Date: Thu, 23 Jun 2016 09:30:59 +0100
Message-ID: <DUB408-EAS233D9F4E375A83C04B1D31AA12D0_at_phx.gbl>
Timely:
http://krisrice.blogspot.co.uk/2016/06/kill-db-sessions-easy-way-with-sqlcl.html?m=1
Sent from my Windows Phone
From: Dominic Brooks<mailto:dombrooks_at_hotmail.com> Sent: 22/06/2016 18:17
To: gogala.mladen_at_gmail.com<mailto:gogala.mladen_at_gmail.com>; oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org> Subject: RE: Oracle Tools - Freeware That can show running queries
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. 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 Thu Jun 23 2016 - 10:30:59 CEST