Re: What is real datafile size?

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: 2000/04/14
Message-ID: <390da322.24185166@netnews.worldnet.att.net>#1/1

The "size 10M" is the initial size for the new datafile. The "NEXT 512K" causes the data file to grow in 512K (1/2 meg) chunks. The MAXSIZE 250M tells Oracle not to allow the file to grow beyond 250 megabytes in size.

Your second command simply creates the file as a 250M file to begin with. The advantage is that you never have SQL statements slow down and wait while the file is extended. The disadvantage is that you are using all 250M of space whether you need it or not.

FWIW, I usually create large files. When I need more space, I either manually extend them, or I add other datafiles to the tablespace.

Jonathan

---

jonathan_at_gennick.com
http://gennick.com
Brighten the Corner Where You Are

On Fri, 14 Apr 2000 10:34:20 -0600, Sheng Jin <sheng.jin_at_ualberta.ca> wrote:

>Hi, When I read Oracle8 Server Administrator's Guide(p9-6), I am not
>sure for the real datafile size in following command:
>
>Alter Tablespace Users Add Datafile 'filename2' size 10M
> AutoExtend ON
> NEXT 512K
> MAXSIZE 250M
>
>[1] It seems the filename2 size can reach to 250M. What is the use of
>item 'size 10M'?
>[2] Does filename2 start to extend after it reach size 10M or from
>begin?
>[3] What is the difference of above command with the following one:
> Alter Tablespace User Add Datefile 'filename2' size 250M
>
>Any help will be appreciated!
>
>Sheng Jin
Received on Fri Apr 14 2000 - 00:00:00 CDT