topic Re: Monitoring % of freespace left in tablespace (oracledb extension) in Open Q&A

Monitoring % of freespace left in tablespace (oracledb extension)

leonatay — Fri, 04 Nov 2022 08:14:47 GMT

Hi community,

By any chance have anyone tried to configure the metrics so that % of free space left in tablespace (instead of the absolute value) can be displayed? because was working with a client that wants to be notified when the % of free space in tablespace is less than a certain value.

This data came from oracleDB extension.

Thank you!

Sincerely,

Leona

Re: Monitoring % of freespace left in tablespace (oracledb extension)

dannemca — Thu, 03 Nov 2022 17:28:37 GMT

Hi @leonatay , good day.

If you do not have a metric that show used/free space by %, you can do some math to get it.

Used Space % = ((Total space - Free Space)/Total space)*100

https://www.dynatrace.com/support/help/dynatrace-api/environment-api/metric-v2/metric-expressions

Regards