kill-9

Oracle --thanks

EUREKA!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I FOUND IT!!!!!!!!!!!!!!!!!!!! DPA users (And SolarWinds staff) Please take note that I am not crazy and DPA does offer the capability I was talking about, but apparently I'm the only one who knows it... (Maybe I should come work for SolarWinds).…

Okay, thanks -- would you mind sharing what some of those cool reporting tools are? --thanks!

Okay thanks, I did eventually figure that out and it is working; but as a follow up question, why is "last_call_et >= 30"? I would assume that is how long you want the query to have been running before getting an alert, so >= 30 means any query that runs for 30 seconds or longer, correct? So, if I only wanted to be alerted…

Thanks for replying. Actually, these were canned as I am the only one who has the privilege to create a custom alert or report. And like I said, these were "all" Oracle database metrics that were populated in the drop down list box that was so long you had to do lots of scrolling to get from one end to the other. I just…

Couple of questions: 1) how is this different than the Long Running Transaction alert out-of-the-box of DPA? 2) how did you come up with the value of 30 for "and last_call_et >= 30" Thanks

Thanks mandevil -- that did the trick!

I followed the instructions when setting up the alert, but it's not working at all -- I set the threshold to 1 second to test, and no alerts. I cut and pasted the Oracle code because that's our repository platform. I tried running the sql provided at the command line and sqlplus doesn't like the "#" symbols -- are we…