Oracle Bucket Sensor

Define buckets and each channel depending on the value would fall into one or more buckets. You might show the count, or the average number that fall into the bucket.

For example this query would show you the response time for all active inactive for sessions for user and background sessions.

select round(et_last_call/60) as "SECONDS",  type || status as "ACTSTAT" from v$session;

Buckets
0-2 seconds
3-5 seconds
6-15 seconds
16-90 seconds
90-unlimited seconds
No value or rows

For example
channel 1 - where ACTSTAT = 'USERACTIVE'
channel 2 - where ACTSTAT = 'USERINACTIVE'
channel 3 - where ACTSTAT = 'BACKGROUNDACTIVE'
channel 4 - where ACTSTAT = 'BACKGROUNDINACTIVE'

If you overlap the buckets it would accumulate in more than one bucket.

This would be useful to show the responsiveness of the application.

I can write sql where each channel is a bucket however then you can only display one datapoint per sensor. So in the above example you would need 4 sensors to display that information.

oracle prtg sql