TECHZEN Zenoss User Community ARCHIVE  
FORUMS / Configuration & Administration / DISCUSSION

Looking for event transforms on oracle tablespace percent utilization

Subject: Looking for event transforms on oracle tablespace percent utilization
Author: Mayukh De
Posted: 2017-07-14 10:38

​Hi All,

I am looking for some transforms on oracle tablespace percent utilization alerts.
Requesting from anyone aware of the same.

------------------------------
Mayukh De
Senior Infra Developer
Cognizant technology Solutions Pvt Ltd
------------------------------

Subject: RE: Looking for event transforms on oracle tablespace percent utilization
Author: Jagadish N
Posted: 2017-07-14 11:10

Mayukh,

Can you elaborate more on your requirement ?

Cheers,
Jagadish

Subject: RE: Looking for event transforms on oracle tablespace percent utilization
Author: Mayukh De
Posted: 2017-07-14 11:16

Hi jagadish,

 

I have configured a datasource for getting Tablespace used percentage utilization, and then configured duration threshold for the same and placed in /Perf.

However the events are coming in the below format:

 

               

High Queue Latency Threshold Violation Detected. Currently 100.00% of the (dbUsedPct) data values, 3 out of a total of 3, in the last 15 minutes violated the maximum threshold of 85 or the minimum threshold of (not defined)

 

 

I need the events to show the current percentage utilization.

 

I have configured a custom datasource for collecting pct data and its showing in the graph:

 

This is the expression I have used:

( dbmTBSP_BYTES_USED / dbmTBSP_TOTAL_SIZE ) * 100

 

 

Thanks & Regards,

Mayukh De

Cognizant Technology Solutions

Ph: +91-8961757809 |

mayukh.de@cognizant.com

Kolkata

 

 

 


Subject: RE: Looking for event transforms on oracle tablespace percent utilization
Author: Jagadish N
Posted: 2017-07-14 12:04

Mayukh,

Have tried disabling the existing  datasource ? even after using the above expression, are you getting the same event message ?

Cheers,
Jagadish N

Subject: RE: Looking for event transforms on oracle tablespace percent utilization
Author: Mohammed Irshad
Posted: 2018-02-15 02:55

You will have to use an event transform to parse the values and the message when you are using a duration threshold. 

Please put the event details here I will help you with the transform. Otherwise, use minmax threshold.

------------------------------
Irshad
------------------------------


< Previous
New Zenoss Deployment - Modeling fails for Windows devices 		  Next
OVA installation upgradable? 		>