Getting total amount of active versions.

[Emil S. Hansen]

Hello *SMers.

Is there a SELECT statement that can show me the (total) size of all active
files?

I have
SELECT SUM(LOGICAL_MB) AS Data_In_MB, SUM(NUM_FILES) \
AS Num_of_files FROM OCCUPANCY
for showing the total size of all files, but how about the size of
active files only? It will give me an idea about how much I will need to
restore in a disaster.
-- 
Best Regards
Emil S. Hansen - [EMAIL PROTECTED] - ESH14-DK
UNIX Administrator, Berlingske IT - www.bit.dk
PGP: 109375FA/ABEB 1EFA A764 529E 82B5  0943 AD3B 1FC2 1093 75FA

"tjaa men ville disse lister ikke være kedelige hvis vi altid gav
hinanden ret med det samme :o)" - Kim Schulz på SSLUG.PROG

msg26667/pgp00000.pgp
Description: PGP signature