<< Click to Display Table of Contents >>

Datafiles and Fragmentation

Top Previous Next

The leftmost portion of the page shows a portion of the Overview Tablespaces page. The right side displays information about datafiles associated with the currently selected tablespace.

File information

ID number of the datafile

File name

Status from V$DATAFILE: ONLINE, OFFLINE, SYSTEM, RECOVER, or SYSOFF

Status  from DBA_DATA_FILES: INVALID or AVAILABLE

Total Size in MBytes

Highwater in MBytes

Auto-extensibility data

Whether auto-extensible

Auto-extension increment in Kbytes

Maximum size in Kbytes

Free space fragmentation

Number of chunks

Minimum size

Maximum size

The following context operations are available:

TblSpaceAddFile

Add Datafile

 

 

Shows a modal dialog for adding a new data file to the tablespace, or in the case of a temporary tablespace, for adding a new tempfile.

07_Drop

Offline Drop

 

 

Executes the ALTER TABLESPACE xxx OFFLINE DROP. Attention: This does not drop the datafile. You must run media recovery after executing this command! See Oracle documentation for further details.

 

Change Status

Enable

Online

Switches the datafile online.

 

 

DISABLE

Offline

Switches the datafile offline.

07_Drop

Drop

 

 

For tempfiles, drops the tempfile, using ALTER DATABASE TEMPFILE.

TblSpaceRenameFile

Rename

 

 

Renames the datafile.

05_Properties

Properties/Resize

 

 

Shows a modal dialog for viewing and modifying properties of the datafile or tempfile. You can also resize the datafile or tempfile.

 

Grid View

 

 

For more information, see object window

 

Clicking on the plus sign to the left of the datafile name shows information about free space fragmentation and segments in the selected datafile:

 

tablespaces_datafiles