You want the size of the tablespace to increase when it is full. Which option would you use?
A.
use automatic extent allocation
B.
disable threshold for the tablespace
C.
use freelists to manage the free space
D.
use automatic segment space management
E.
create the tablespace as a bigfile tablespace
F.
use the RESIZE clause while creating the tablespace
G.
enable AUTOEXTEND for at least one of the data files in the tablespace
Using Autoextend to Increase Oracle Database File Sizes
Autoextend can be very helpful to busy DBAs by allowing Oracle to automatically increase file sizes to a pre-determined limit when necessary, which can make the workday a bit easier by minimizing the effort expended to monitor disk space. In a heavily used system where inserts and updates eclipse the deletes, autoextend gives the DBA some “breathing room” so he/she can attend to more pressing issues. For those unfamiliar with using autoextend, we’ll show how to enable it and how to manage the available space.
Setting a file in a tablespace to autoextend is a fairly easy task as long as the user performing the actions has DBA or SYSDBA privileges:
You can specify automatic file extension by specifying an AUTOEXTEND ON clause when you create datafiles using the following SQL statements:
CREATE DATABASE
ALTER DATABASE
CREATE TABLESPACE
ALTER TABLESPACE