If you're referring to allocated size, you can sum the sizes of all the datafiles at the OS level ("du -sk" in Unix). If you're referring to utilized size, that is indeed dynamic. A snapshot valid for a particular time could be taken by "select sum(bytes)/(1024*1024) MB from dba_segments".

Tim