DX Unified Infrastructure Management

 View Only
  • 1.  Oracle probe tablespace_free checkpoint

    Posted Jul 12, 2019 10:43 AM
    Hi All,

    is there any way to create a threshold on any other variable, say example while running th tablespace_free query on oracle database i got below output.

    and create a threshold on MAXPCT variable.
    output

    Thanks,
    Naveen


  • 2.  RE: Oracle probe tablespace_free checkpoint
    Best Answer

    Posted Jul 12, 2019 11:11 AM
    I've not done it but, It is possible to create custom checkpoints.
    https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/oracle-oracle-database-monitoring/oracle-im-configuration#oracleIMConfiguration-(Optional)CreateCustomCheckpoints

    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=14959
    https://ca-broadcom.wolkenservicedesk.com/external/article?articleId=34944

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: Oracle probe tablespace_free checkpoint

    Posted Jul 12, 2019 11:59 AM
    Yes, custom check points will work here.

    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------



  • 4.  RE: Oracle probe tablespace_free checkpoint

    Posted Jul 12, 2019 01:13 PM
    HI All,

    thanks for your support ..
    custom checkpoint is the possible way but can we change existing default checkpoint on different variable.

    Thanks,
    Naveen


  • 5.  RE: Oracle probe tablespace_free checkpoint

    Posted Jul 12, 2019 01:35 PM
    The recommendation Support received from Development is to not modify the default checkpoints and create a new custom checkpoint with the changes needed.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 6.  RE: Oracle probe tablespace_free checkpoint

    Posted Jul 12, 2019 02:05 PM
    I see the default metric is using the PCT (Assuming MAXPCT).

    Other Metrics available are CHUNKS, PCT_USED, FREESP and MAXSIZE.


    ------------------------------
    Thank you.
    Rajashekar
    ------------------------------