I think we need a bit more detail to help you with this one.
What version of Zenoss? And is it Zenoss Core or the chargeable Zenoss Resource Monitor?
| Subject: |
RE: Oracle Table Space Thresholds |
| Author: |
Jane Curry |
| Posted: |
2018-12-05 09:20 |
Hi Eddie,
Can I suggest you keep discussions here on the forum, rather than using private messaging / email. That way, everyone benfits from questions and answers :)
Eddie said......
Good Morning and thank you for your response.
When we start the RM is says Zenoss Service Dynamics.
And the versions are:
Zenoss 6.2.1 r218
ControlCenter 1.5.1
ZenPackx.zenoss.DatabaseMonitor ver. 3.0.12
Also, the graph uses dbmTBSP.BYTES_FREE and how would we convert that into a Threshold?
--------------------------------
So are you seeing values in your graphs for dbmTBSP.BYTES_FREE?? If so, all you need to do is have a threshold based on this same value. The manual for this ZenPack is at
https://www.zenoss.com/product/zenpacks/databasemonitor . This page suggests that there should already be a threshold that might do the job for you...
Tablespace templates are enabled by default. If you have more than 100 Tablespaces per instance you may see performance issues that can cause collection to fail. If that is the case, you can disable Tablespace monitoring by disabling those templates.
To disable these templates:
- Navigate to Advanced -> Monitoring Templates
- Select OracleTableSpace
- DoubleClick dbmTBSP and uncheck Enabled
- -Save-
So looks like the template should be enabled by default but someone in your organisation may have disabled or modified it. Hopefully, this gives you enough info to at least check what you have. You may also find that there is an active threshold but that it is not set at 90% - so you can change it.
Cheers,
Jane
------------------------------
Jane Curry
Skills 1st United Kingdom
jane.curry@skills-1st.co.uk
------------------------------
| Subject: |
RE: Oracle Table Space Thresholds |
| Author: |
Nicholas Arellano |
| Posted: |
2018-12-05 14:26 |
We may have worded this wrong on the graph using dbmTBSP.BYTES_FREE. These are the Data Sources available for the Oracle Tablespaces below and there are no out of the box Thresholds that exist. We are wondering if anyone is monitoring the TableSpace Utilization and how they created the Threshold in order to do this.
dbmTBSP.BYTES_FREE
dbmTBSP.BYTES_USED
dbmTBSP.MAXBYTES
dbmTBSP.TOTAL_SIZE
------------------------------
Nicholas Arellano
Administrator
CPS Energy
San Antonio TX
2103534171
------------------------------
| Subject: |
RE: Oracle Table Space Thresholds |
| Author: |
Jane Curry |
| Posted: |
2018-12-05 15:15 |
Have a look at the Zenoss Administrators Guide - the Performance Monitoring chapter, especially the Thresholds section, should show you how to do this. (
https://www.zenoss.com/services-support/documentation )
You seem to know the datapoints that you are interested in (dbmTBSP.BYTES_FREE etc). The Admin guide is generic so it works just as well for datapoints from a ZenPack as anything else.
Cheers,
Jane
------------------------------
Jane Curry
Skills 1st United Kingdom
jane.curry@skills-1st.co.uk
------------------------------
