Hi Keith,

I think you're looking for a

select sum(FILE_SIZE) from contents where VOLUME_NAME='your.volume'

Regards
     Mecki