RE: Oracle Tools - Freeware That can show running queries
Date: Wed, 22 Jun 2016 09:04:44 -0700 (PDT)
Message-ID: <2a8a81d4-6602-4811-8310-49cdc023e0fc_at_default>
For example, SQLcl is just 14MB download.
You could create Session, Kill, and Plan alias ‘commands’ that does what you want with minimal typing and no GUI overhead.
There’s also auto-refresh avail for your Session command via ‘Repeat’ feature that would give you a monitor like experience.
Jeff
From: Jeff Smith
Sent: Wednesday, June 22, 2016 12:01 PM
To: andrew.kerber_at_gmail.com; l.flatz
Cc: ORACLE-L
Subject: RE: Oracle Tools - Freeware That can show running queries
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]
Sent: Wednesday, June 22, 2016 11:49 AM
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 <HYPERLINK "mailto:l.flatz_at_bluewin.ch" \nl.flatz_at_bluewin.ch> wrote:
How about sql developer session viewer?
Von meinem Samsung Gerät gesendet.
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?
To: l.flatz
Cc: ORACLE-L
Subject: Re: Oracle Tools - Freeware That can show running queries
--
Andrew W. Kerber
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 22 2016 - 18:04:44 CEST
'If at first you dont succeed, dont take up skydiving.'
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'