Effects of Autoextend and Resize on BR*Tools

Autoextend and Resize are two Oracle options for influencing the size of the data files of the database system:

·        Autoextend extends the data files automatically by a specified amount

·        Resize lets you increase the size of data files manually (up to the maximum file system size), or reduce their size (down to the last used block ID of the data file).

These options influence the BR*Tools functions below, and have been adjusted accordingly.

Restore and Recovery

When performing a recovery (that is, importing the offline redo log files), the Oracle database system automatically takes into account the autoextends made to the data files during or after a database backup.

Database System Check

Parameters for checking freespace in tablespaces that take into account the Autoextend option are the following:

·        TABLESPACE_FULL for absolute freespace

·        CRITICAL_SEGMENTS for critical segments

For more information, see BRCONNECT Default Conditions for Database Administration.

Reorganization

·        The preventative freespace check includes the Autoextend option

·        Before you reorganize a table, you can set the Autoextend parameters MAXSIZE and INCREMENT_BY when you alter the data files. The parameter MAXSIZE takes into account the memory of the file system or the raw device.

For more information, see Reorganizing Tables with BR*Tools.

Tablespace Management

·        You can create the data files of the tablespaces with the parameters AUTOEXTEND ON (OFF), MAXSIZE and INCREMENT_BY. You can also change these parameters. The parameter MAXSIZE takes into account the memory of the file system or the raw device.

For more information, see Extending a Tablespace with BR*Tools and Creating a Tablespace with BR*Tools.

·        You can increase or reduce the size of the data files of the tablespaces with the Resize action. For more information, see Altering a Data File with BR*Tools.