The Storage page enables you to automatically extend the data file when it is full.
If you choose the " Automatically extend data file when full " option, the data file will automatically increase in size when more space is needed in the database. The file increases in specified increments up to a specified maximum.
Setting your data files to extend automatically results in the following:
Reduces the need for immediate intervention when a tablespace runs out of space
Ensures applications will not halt because of failures to allocate extents
The page consists of the following:
Note : If the data file belongs to a read-only tablespace, all the fields on this page are disabled.
Determines whether the data file is extended automatically when it becomes full. If the box is not checked, the other fields on the page are disabled.
Increment : Determines the minimum size of the increments to add to the file when it extends. The data file will increase in the specified increment, up to a specified maximum size. The Increment By value is obtained by dividing the Auto Extend increment size by the db_block_size.
Unlimited : Sets no limit on allocating disk space to the data file. This option is specified by default.
Value : Allows you to specify the maximum size to which the file can automatically extend.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.