search

akardapolov / ASH-Viewer

ASH Viewer provides a graphical view of active session history data within the Oracle and PostgreSQL DB
GNU General Public License v3.0
167 stars 72 forks source link

ASH Viewer API #14

Open vamckrishnap opened 6 years ago

vamckrishnap commented 6 years ago

Hi I was working with the ASH viewer and found it very fascinating. I just wanted to know if the ASH Viewer would expose an API so that I could write a custom code to capture metrics which I desire to monitor. Please help me in this. Also, I would be thankful if you can suggest a way to use a Listener kind of thing to capture metrics from the ASH Viewer. Thanks in advance.

akardapolov commented 6 years ago

Hi!

I am working on it. I decide to a complete rewrite of main code base (branch 4.0.0) to ease implement this features (and others too).

Thanks, Alex.

vamckrishnap commented 6 years ago

Great Alex . I am eager to work on this project and partner you as a co-author for the code-base. Let me know if you are having any timelines.

Regards Vamsi

jcepek commented 6 years ago

I too am very interested in running ASH-Viewer but in a headless state. Would like to be able to pass startup parm such as duration of logging session.

akardapolov commented 5 years ago

@Vamsi It will be done before the new year

@jcepek Need some time to prepare code to publish

jcepek commented 5 years ago

First and foremost "Thanks so much for considering this option", I could certainly help in the testing of its functionality and provide feedback. The value of a headless Ash Viewer and the ability to schedule the observation period would be incredibly useful.

Just a bit more information to further explain my use case. As a systems engineer there a times when there is value in monitoring a db in the middle of the night. My goal would be to write a wrapper which allows for call to headless Ash Viewer with parms such as log location, start time of logging, end time of logging/duration. Once completed, the log info would be collected and sent back for review in a local Ash Viewer client.

Best Regards

jcepek commented 5 years ago

@akardapolov Greetings Alex, Hope all is well! Just curious as to the status of this feature? Are you still intending to implement? Any guess as to when it may be available (no pressure, just highly anticipating this feature). If I can assist in pre-release testing, I would be happy to do so.

Best Regards

akardapolov commented 5 years ago

@jcepek need some time to prepare the code. 2-3 days left.

jcepek commented 5 years ago

@akardapolov Thank you for taking the time to respond. As I had said in a prior comment, would be happy to assist in proofing the changes.

akardapolov commented 5 years ago

@jcepek

Done

https://github.com/akardapolov/ASH-Viewer/tree/4.0.0 https://github.com/akardapolov/ASH-Viewer/releases/tag/v4.0.0

jcepek commented 5 years ago

@akardapolov First and foremost, Thank you for all you hard work. I have installed the latest release and so far so good.

One question, does the new release support any startup parameters in regard to when to start monitoring and when to end monitoring. If you recall my original post was inquiring into the ability to drive this in a headless fashion.

Best Regards !

jcepek commented 5 years ago

@akardapolov Greetings. Are you still considering providing the ability to provide a headless API for Ash Viewer?