I have events that have
tablespace, tablespace_size, table_owner, table_name, table_size
ie
WORK_TS 10000000 joe Joe_table1 1000
WORK_TS 10000000 joe Joe_table2 5000
WORK_TS 10000000 mary Mary_table1 3000
WORK_TS 10000000 mary Mary_table2 7000
PROD_TS 10000000 joe Joe_table3 1000
PROD_TS 10000000 joe Joe_table4 5000
PROD_TS 10000000 mary Mary_table3 3000
PROD_TS 10000000 mary Mary_table4 7000
I want to sum the total space used in a tablespace by the table_owner, tablespace and then divide that sum by the tablespace_size
index="oracle" source="oracle_tables" | stats sum(table_size) as owner_used_space by table_owner, tablespace
I get the sums but cannot divide by them by the tablespace_size
... View more