Size of files. Can you estimate?

From: ExecMan <johndoe_at_mtekusa.com>
Date: 7 Dec 2006 14:02:41 -0800
Message-ID: <1165528960.929504.288890@16g2000cwy.googlegroups.com>

Hi,

I've just taken over a database. The database has 28 rollback segments. And, to my astonishment, these guys are not running their production database in archive log mode.

Short term fix is to put it in archive log mode. but, I'm wondering if there is any way to estimate how large the archive log files will be, or, how often they will be created based on the number of wraps the rollback segments have........

Here is my data to work with. I know it's a lot, so I appreciate your help.

NAME USN RSSIZE OPTSIZE HWMSIZE EXTENDS WRAPS SHRINKS AVESHRINK AVEACTIVE
------ --- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
RBS0 1 4190208 4194304 17297408 120 1225   23 2735415 2429731
RBS1 2 4190208 4194304 17821696 219 1325   32 3588096 2870508
RBS10 11 4190208 4194304 17821696 151 1239   21 3769880 1724976
RBS11 12 4190208 4194304 17297408 176 1250   25 3690987 1310009
RBS12 13 4190208 4194304 17821696 120 1216   22 2859752 1878547
RBS13 14 4190208 4194304 17297408 239 1379   38 3297495 2398540

RBS14   15    4190208    4194304   17821696        241       1385
  38    3325089     873264
RBS15   16    4190208    4194304   17297408        181       1285
  29    3272280    1564103
RBS16   17    4190208    4194304   16248832        155       1246
  26    3125563    1497080
RBS17   18    4190208    4194304   17297408        167       1279
  28    3127003     662942
RBS18   19    4190208    4194304   17297408        191       1325
  31    3230290    2764290
RBS19   20    4190208    4194304   17821696        149       1240
  23    3396474    1908383
RBS2     3    4190208    4194304   17297408        173       1271
  27    3359326    1255459
RBS20   21    4190208    4194304   16248832        197       1343
  33    3129840    1922859
RBS21   22    4190208    4194304   16248832        125       1241
  23    2849391    2520293
RBS22   23    4190208    4194304   17297408        273       1457
  43    3328619    1596865
RBS23   24    4190208    4194304   15724544        169       1274
  25    3544186    2106861
RBS24   25    4190208    4194304   17821696        188       1268
  27    3650597    1403512
RBS25   26    4190208    4194304   17297408        219       1350
  35    3280544     669183
RBS26   27    4190208    4194304   17297408        212       1335
  32    3473408     769582
RBS27   28    4190208    4194304   16248832        218       1405
  39    2930635    1670012
RBS28   29    4190208    4194304   17821696        185       1337
  31    3128815     717392
RBS3     4    4190208    4194304   13627392         73       1151
  15    2551534    2173562
RBS4     5    4190208    4194304   17821696        247       1387
  39    3320490    1928782
RBS5     6    4190208    4194304   17297408        217       1315
  31    3670016    1460498
RBS6     7    4190208    4194304   17297408        203       1348
  34    3130307     562245
RBS7     8    4190208    4194304   17297408        171       1269
  26    3448201     527361
RBS8     9    4190208    4194304   13627392        147       1245
  24    3211264     931141
RBS9    10    4190208    4194304   17821696        130       1210

  19 3587233 2876121

John Received on Thu Dec 07 2006 - 16:02:41 CST