Re: Size of files. Can you estimate?

ExecMan wrote:
> 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

Umm John ( nice name by the way ) ... rollback segments don't have anything to do ( directly ) with how much archive is going to be generated.

However, the activity of your online redo logs is important and can be used to get an idea of how much archive log data is going to be generated. Received on Thu Dec 07 2006 - 16:48:37 CST