Hi all, I tried to sum up the size of archive / backup sizes using the backup/archives table joined with backup_objects/archive_objects, but the results are not plausible.
My queries: SELECT CAST(FLOAT(SUM(bo.bfsize))/1024/1024/1024 as DEC(14,1)) as size_gb FROM backups b, backup_objects bo WHERE b.object_id=bo.objid and backup_date<current_timestamp-30 days SELECT CAST(FLOAT(SUM(ao.bfsize))/1024/1024/1024 as DEC(14,1)) as size_gb FROM archives a, archive_objects ao WHERE a.object_id=ao.objid and archive_date<current_timestamp-30 days The summed backup / archives sizes are much greater than the summed results from auditocc table. It does not make sense to me. Is there anybody out there who tried to query that before and could supply me a select statement with plausible results? Best Regards, David
