| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Size of files. Can you estimate?
Mark D Powell wrote:
> On Dec 7, 5:48 pm, "hpuxrac" <johnbhur..._at_sbcglobal.net> wrote:
> > 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
> >
> > > JohnUmm 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.- Hide quoted text -- Show quoted text -
>
> John, look in the alert log and count how many log switches you have
> per day. Based on your online redo log size make an estimate.
>
> You can also try looking at v$log_history. I do not have a non-archive
> log mode database in front of me to check but I am pretty sure that
> Oracle still logs the swithes in the control file so you can see the
> history of switches here.
>
> HTH -- Mark D Powell --
Hi Mark,
Don't get upset, I know it is a lot of data, but how does this show me the log switches? This is a query from v$log_history......
RECID STAMP THREAD# SEQUENCE# FIRST_CHANGE# FIRST_TIME
NEXT_CHANGE#
------------------- ------------
584240 608604129 1 584240 2815333393 12/08/2006
00:41:53 2815333640
584241 608604141 1 584241 2815333640 12/08/2006
00:42:09 2815334042
584242 608604152 1 584242 2815334042 12/08/2006
00:42:20 2815335349
584243 608604173 1 584243 2815335349 12/08/2006
00:42:32 2815336687
584244 608604185 1 584244 2815336687 12/08/2006
00:42:53 2815338011
584245 608604197 1 584245 2815338011 12/08/2006
00:43:05 2815339303
584246 608604212 1 584246 2815339303 12/08/2006
00:43:17 2815340614
584247 608604225 1 584247 2815340614 12/08/2006
00:43:32 2815341938
584248 608604237 1 584248 2815341938 12/08/2006
00:43:45 2815343240
584249 608604261 1 584249 2815343240 12/08/2006
00:43:57 2815344520
584250 608604273 1 584250 2815344520 12/08/2006
00:44:21 2815345808
584251 608604284 1 584251 2815345808 12/08/2006
00:44:33 2815347127
584252 608604309 1 584252 2815347127 12/08/2006
00:44:44 2815348375
584253 608604323 1 584253 2815348375 12/08/2006
00:45:09 2815349686
584254 608606581 1 584254 2815349686 12/08/2006
00:45:23 2815352695
584255 608607008 1 584255 2815352695 12/08/2006
01:23:01 2815353252
584256 608607019 1 584256 2815353252 12/08/2006
01:30:08 2815353314
584257 608607030 1 584257 2815353314 12/08/2006
01:30:19 2815353359
584258 608607039 1 584258 2815353359 12/08/2006
01:30:30 2815353424
584259 608607049 1 584259 2815353424 12/08/2006
01:30:39 2815353474
584260 608607060 1 584260 2815353474 12/08/2006
01:30:49 2815353543
584261 608607070 1 584261 2815353543 12/08/2006
01:31:00 2815353615
584262 608607085 1 584262 2815353615 12/08/2006
01:31:10 2815353678
584263 608607093 1 584263 2815353678 12/08/2006
01:31:25 2815353738
584264 608607102 1 584264 2815353738 12/08/2006
01:31:32 2815353802
584265 608607114 1 584265 2815353802 12/08/2006
01:31:42 2815353921
584266 608607143 1 584266 2815353921 12/08/2006
01:31:54 2815354453
584267 608607156 1 584267 2815354453 12/08/2006
01:32:23 2815354501
584268 608607170 1 584268 2815354501 12/08/2006
01:32:36 2815354542
584269 608607179 1 584269 2815354542 12/08/2006
01:32:50 2815354591
584270 608607184 1 584270 2815354591 12/08/2006
01:32:59 2815354655
584271 608607200 1 584271 2815354655 12/08/2006
01:33:04 2815354712
584272 608607207 1 584272 2815354712 12/08/2006
01:33:20 2815354775
584273 608607216 1 584273 2815354775 12/08/2006
01:33:27 2815354830
584274 608607227 1 584274 2815354830 12/08/2006
01:33:36 2815354890
584275 608607236 1 584275 2815354890 12/08/2006
01:33:46 2815354947
584276 608607248 1 584276 2815354947 12/08/2006
01:33:56 2815355010
584277 608608838 1 584277 2815355010 12/08/2006
01:34:08 2815358195
584278 608611011 1 584278 2815358195 12/08/2006
02:00:38 2815361900
584279 608614811 1 584279 2815361900 12/08/2006
02:36:51 2815367037
584280 608614842 1 584280 2815367037 12/08/2006
03:40:11 2815370987
584281 608614871 1 584281 2815370987 12/08/2006
03:40:42 2815374953
584282 608614900 1 584282 2815374953 12/08/2006
03:41:11 2815378075
584283 608614925 1 584283 2815378075 12/08/2006
03:41:40 2815381848
584284 608614949 1 584284 2815381848 12/08/2006
03:42:05 2815385731
584285 608617592 1 584285 2815385731 12/08/2006
03:42:29 2815427651
584286 608618894 1 584286 2815427651 12/08/2006
04:26:32 2815431451
584287 608618899 1 584287 2815431451 12/08/2006
04:48:14 2815434137
584288 608618907 1 584288 2815434137 12/08/2006
04:48:19 2815436923
584289 608618913 1 584289 2815436923 12/08/2006
04:48:27 2815439748
584290 608618919 1 584290 2815439748 12/08/2006
04:48:33 2815442602
584291 608618928 1 584291 2815442602 12/08/2006
04:48:39 2815445378
584292 608618935 1 584292 2815445378 12/08/2006
04:48:48 2815448304
584293 608618941 1 584293 2815448304 12/08/2006
04:48:55 2815451141
584294 608618950 1 584294 2815451141 12/08/2006
04:49:01 2815453916
584295 608618954 1 584295 2815453916 12/08/2006
04:49:10 2815456716
584296 608618963 1 584296 2815456716 12/08/2006
04:49:14 2815459490
584297 608618973 1 584297 2815459490 12/08/2006
04:49:23 2815462078
584298 608618980 1 584298 2815462078 12/08/2006
04:49:33 2815464613
584299 608618988 1 584299 2815464613 12/08/2006
04:49:40 2815466988
584300 608618997 1 584300 2815466988 12/08/2006
04:49:48 2815469589
584301 608619003 1 584301 2815469589 12/08/2006
04:49:57 2815472433
584302 608619011 1 584302 2815472433 12/08/2006
04:50:03 2815475036
584303 608619018 1 584303 2815475036 12/08/2006
04:50:11 2815477448
584304 608619024 1 584304 2815477448 12/08/2006
04:50:18 2815479359
584305 608619029 1 584305 2815479359 12/08/2006
04:50:24 2815480309
584306 608619039 1 584306 2815480309 12/08/2006
04:50:29 2815481230
584307 608619044 1 584307 2815481230 12/08/2006
04:50:39 2815482247
584308 608619048 1 584308 2815482247 12/08/2006
04:50:44 2815483239
584309 608619059 1 584309 2815483239 12/08/2006
04:50:48 2815484268
584310 608619064 1 584310 2815484268 12/08/2006
04:50:59 2815485430
584311 608619068 1 584311 2815485430 12/08/2006
04:51:04 2815486702
584312 608619078 1 584312 2815486702 12/08/2006
04:51:08 2815487856
584313 608619084 1 584313 2815487856 12/08/2006
04:51:18 2815489140
584314 608619091 1 584314 2815489140 12/08/2006
04:51:24 2815490484
584315 608619097 1 584315 2815490484 12/08/2006
04:51:31 2815491737
584316 608619103 1 584316 2815491737 12/08/2006
04:51:37 2815493018
584317 608619107 1 584317 2815493018 12/08/2006
04:51:43 2815494238
584318 608619121 1 584318 2815494238 12/08/2006
04:51:47 2815495432
584319 608619125 1 584319 2815495432 12/08/2006
04:52:01 2815496624
584320 608619136 1 584320 2815496624 12/08/2006
04:52:05 2815498935
584321 608619144 1 584321 2815498935 12/08/2006
04:52:16 2815501964
584322 608619149 1 584322 2815501964 12/08/2006
04:52:24 2815505113
584323 608619154 1 584323 2815505113 12/08/2006
04:52:29 2815508148
584324 608619162 1 584324 2815508148 12/08/2006
04:52:34 2815511197
584325 608619167 1 584325 2815511197 12/08/2006
04:52:42 2815514313
584326 608619473 1 584326 2815514313 12/08/2006
04:52:47 2815517863
584327 608621413 1 584327 2815517863 12/08/2006
04:57:53 2815530249
584328 608621421 1 584328 2815530249 12/08/2006
05:30:13 2815530318
584329 608621434 1 584329 2815530318 12/08/2006
05:30:21 2815530395
584330 608621454 1 584330 2815530395 12/08/2006
05:30:33 2815530484
584331 608621468 1 584331 2815530484 12/08/2006
05:30:54 2815530602
584332 608621480 1 584332 2815530602 12/08/2006
05:31:08 2815530786
584333 608621490 1 584333 2815530786 12/08/2006
05:31:19 2815530856
584334 608621512 1 584334 2815530856 12/08/2006
05:31:30 2815532422
584335 608621538 1 584335 2815532422 12/08/2006
05:31:52 2815534551
584336 608621561 1 584336 2815534551 12/08/2006
05:32:18 2815536673
584337 608621583 1 584337 2815536673 12/08/2006
05:32:41 2815538798
584338 608621608 1 584338 2815538798 12/08/2006
05:33:03 2815540903
584339 608621630 1 584339 2815540903 12/08/2006
05:33:28 2815543018
584340 608621649 1 584340 2815543018 12/08/2006
05:33:50 2815545153
584341 608621671 1 584341 2815545153 12/08/2006
05:34:09 2815547244
584342 608623526 1 584342 2815547244 12/08/2006
05:34:31 2815551308
584343 608625004 1 584343 2815551308 12/08/2006
06:05:25 2815560139
584344 608625025 1 584344 2815560139 12/08/2006
06:30:04 2815561368
584345 608625048 1 584345 2815561368 12/08/2006
06:30:24 2815563167
584346 608625066 1 584346 2815563167 12/08/2006
06:30:48 2815564944
584347 608625084 1 584347 2815564944 12/08/2006
06:31:06 2815566044
584348 608625098 1 584348 2815566044 12/08/2006
06:31:24 2815566795
584349 608626117 1 584349 2815566795 12/08/2006
06:31:38 2815570587
584350 608627293 1 584350 2815570587 12/08/2006
06:48:37 2815575169
584351 608628611 1 584351 2815575169 12/08/2006
07:08:13 2815579429
584352 608628630 1 584352 2815579429 12/08/2006
07:30:11 2815581529
584353 608628648 1 584353 2815581529 12/08/2006
07:30:30 2815583638
584354 608628665 1 584354 2815583638 12/08/2006
07:30:48 2815585787
584355 608628681 1 584355 2815585787 12/08/2006
07:31:05 2815587917
584356 608628697 1 584356 2815587917 12/08/2006
07:31:21 2815590045
584357 608628718 1 584357 2815590045 12/08/2006
07:31:37 2815592210
584358 608628735 1 584358 2815592210 12/08/2006
07:31:58 2815594356
584359 608628754 1 584359 2815594356 12/08/2006
07:32:15 2815596514
584360 608628772 1 584360 2815596514 12/08/2006
07:32:34 2815597355
584361 608628779 1 584361 2815597355 12/08/2006
07:32:52 2815597557
584362 608628794 1 584362 2815597557 12/08/2006
07:32:59 2815597666
584363 608628807 1 584363 2815597666 12/08/2006
07:33:14 2815598946
584364 608628814 1 584364 2815598946 12/08/2006
07:33:27 2815604286
584365 608628828 1 584365 2815604286 12/08/2006
07:33:34 2815608686
584366 608628842 1 584366 2815608686 12/08/2006
07:33:48 2815612309
584367 608628940 1 584367 2815612309 12/08/2006
07:34:02 2815615949
584368 608630054 1 584368 2815615949 12/08/2006
07:35:40 2815620270
584369 608631083 1 584369 2815620270 12/08/2006
07:54:14 2815623682
584370 608632202 1 584370 2815623682 12/08/2006
08:11:23 2815627843
584371 608632213 1 584371 2815627843 12/08/2006
08:30:02 2815628909
584372 608632243 1 584372 2815628909 12/08/2006
08:30:13 2815632318
584373 608632257 1 584373 2815632318 12/08/2006
08:30:43 2815635622
584374 608632269 1 584374 2815635622 12/08/2006
08:30:57 2815638712
584375 608632277 1 584375 2815638712 12/08/2006
08:31:09 2815641846
584376 608632282 1 584376 2815641846 12/08/2006
08:31:17 2815644971
584377 608632287 1 584377 2815644971 12/08/2006
08:31:22 2815648069
584378 608632298 1 584378 2815648069 12/08/2006
08:31:27 2815651129
584379 608632304 1 584379 2815651129 12/08/2006
08:31:38 2815655188
584380 608632311 1 584380 2815655188 12/08/2006
08:31:44 2815659735
584381 608632382 1 584381 2815659735 12/08/2006
08:31:51 2815663291
584382 608633406 1 584382 2815663291 12/08/2006
08:33:02 2815667380
Received on Fri Dec 08 2006 - 08:57:02 CST
 |
 |