D
Dmitri Levin
Guest
I do not think there is a consensus on Single vs Multiple extents per area question. This discussion is as old as version 9. Both camps of gurus have valid points and will stand on their own. The simple solution -- 1 extent per aria works for me on 1.5 TB database. But other people have valid arguments to have multiple fixed extents instead of one huge variable. In OE one area could have only 1 variable extent. In Oracle I have several "variable" (autoextendable) "extents" (.dbf files) per "area" ( tablespace ) . And for a seasoned Progress DBA it is very unusual to see how all of them grow somehow together.
Continue reading...
Continue reading...