Configuration & Administration

Expand all | Collapse all

Oracle Table Space Thresholds

  • 1.  Oracle Table Space Thresholds

    Posted 10 days ago
    Hello,

    Question is --- How does one set up a tablespace alert when the utilization reaches 90%?

    regards



    ------------------------------
    Eddie Cuellar
    Admistrator
    CPS Energy
    TX
    ------------------------------


  • 2.  RE: Oracle Table Space Thresholds

    Posted 10 days ago
    Hi Eddie,
    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?

    Do you have an Oracle ZenPack installed?

    Cheers,
    Jane

    ------------------------------
    Jane Curry
    Skills 1st United Kingdom
    jane.curry@skills-1st.co.uk
    ------------------------------



  • 3.  RE: Oracle Table Space Thresholds

    Posted 9 days ago
    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.
    nrarellano@cps-satx.com@7:40 AM">

    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
    ------------------------------



  • 4.  RE: Oracle Table Space Thresholds

    Posted 9 days ago
    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
    ------------------------------



  • 5.  RE: Oracle Table Space Thresholds

    Posted 9 days ago
    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
    ------------------------------