zabora
zabora copied to clipboard
tb_size.sql script
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;
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