function get_tablespace_tbl RETURN t_table IS l_table t_table := t_table (); BEGIN SELECT t_record (TABLE_SPACE, used_mb, free_mb, total_mb, max_mb, pct_free, max_pct_free) BULK COLLECT INTO l_table FROM ( SELECT fs.tablespace_name AS TABLE_SPACE, (DF.TOTALSPACE – FS.FREESPACE) as USED_MB, …
Weiterlesen »