Re: What is real datafile size?

Sybrand Bakker wrote:

> On tablespace creation one (1) file size 10 M is created.
> As soon as the allocation runs out of the 10 M, new files! are added each
> 512 K big. The total size of all files will be 250M.
> Probably those 250M are never reached because the number of datafiles will

That is not true.

At the begining, a 10M file will be created. Once there can no longer be an extent created, the FILE is extended by 512K over and over again until it reaches 250M. Which would be 480 extentions. This would not be optimuim for most OS or storage systems. It would be better to have the next be larger. Say about 2M. That way your server is not spending too many cycles extending and not filling up your inode list or FAT table with index points.

use: SELECT NAME, BYTES from V$DATAFILES;

Ron Leedy
diCarta, Inc. Received on Fri Apr 14 2000 - 00:00:00 CDT