I want to set alarm for Oracle table space monitoring when it reaches threshold value.

[cramesh]

Hi Team,

I want to set alarm for Oracle table space monitoring from dashboard when it reaches threshold value. any custom set-up to be done for this. please advise on it.

[Yosi_Neuman · Accepted solution]

Hi @cramesh 

Please utilize Oracle Database extension and then you be able to create a metric event on  com.dynatrace.extension.sql-oracle.tablespaces.freeSpace

HTH

Yos 

[manok]

Could you please help us how to configure table space utilization for custom oracle db extn for 12 and 11

[AntonPineiro]

Hi,

Do you want to create some alert? Remember extension support Oracle 12.2 or higher. Lower versions maybe are not going to work correctly.

Best regards

[manok]

yes, i want to create anomaly detection rule for the custom extn. i have created custom ext for oracle db 11 and able to see the db metric like com.dynatrace.extension.sql-oracle.tablespace.freeBytes but i could not cofnigure it

[AntonPineiro · Accepted solution]

Hi,

Can you see data about that metric? If yes, you can create an alert using metric event classic or Anomaly detector app.

Best regards