Usual meaning of "size" of a database

When you say that your DB is 100 GB in size, do you mean the sum of the sizes of all files (including perhaps the ones in the TEMP tablespace)?

The way I calculate the size of a DB is to do a sum(bytes) over all segments of all tablespaces.

But of course, one could do a fresh gathering of statistics and multiply the average size of rows times the number of rows and add for all indexes and tables. But this will ignore size of other kind of objects.

So what is the usual method to report the size of a database, according to your experience?

Thanks
Rick Denoire Received on Thu Feb 05 2004 - 16:26:14 CST