tb_size.sql script

[astronono]

I implemented the zabora agent on my oracle DB and found out that the tb_size.sql in the package was not giving the right value.
I wrote another script that shows the right value now

SET pagesize 0
SET heading OFF
SET feedback OFF
SET verify OFF
select round((1-sum(nvl(fre.bytes,0))/tot.bytes)*100,2) "pct_used"
from dba_free_space fre,
(select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) tot, dba_tablespaces tbs
where tot.tablespace_name = tbs.tablespace_name
and fre.tablespace_name(+) = tbs.tablespace_name
and fre.tablespace_name = UPPER('&1')
group by tot.bytes/1024, tot.bytes;
QUIT;

[sergiotocalini]

Hi @astronono,

Thanks for opening this issue. Which oracle version are you using? maybe it is related with the versioning?
I would suggest you to replace this file in your installation and I will introduce based on oracle versions different sql scripts.
Your input will be much appreciated.

Regards,
Sergio