<< Click to Display Table of Contents >>

Overview Tablespaces

Top Previous Next

Overview Tablespaces is the default sheet, and lists all the tablespaces in the database by:

Tablespace name

Tablespace number

Status

Whether ONLINE, OFFLINE, or READ ONLY

Type of Extent Management

Type of Space Management

Allocation type (System, User)

Whether Permanent or Temporary

Whether logging is in effect

Statistics

Largest Next Extent

Largest Free Chunk

Number of Segments

Maximum Extent per Segment

Default Storage Parameters

Initial Extent Size

Next Extent Size

Increase Percentage

Minimum Extents

Maximum Extents

frmTablespaces_Overview

 

 

Offline tablespaces are grayed. In any of the following situations, the tablespace name is displayed in red:

Any next extent is greater than the largest free chunk

The number of free blocks is less than 100

The number of extents is less than MAX_EXTENTS - 5

The usage is more than 90%

 

A chart diagram shows the size and free space of the tablespaces by users.

 

 

overview_tablespace_diagram

 

 

The following context operations are available:

TblSpaceCreate

Create ...

 

 

Creates a new tablespace.

07_Drop

Drop

 

 

Drops the selected tablespace(s). Be sure you really don't need the selected tablespace(s).

05_Properties

Properties/Alter ...

 

 

Shows a modal dialog for viewing and modifying properties of the tablespace.

 

Rename

 

 

Allows renaming of the tablespace. A check box allows for optionally backing up the control file to a trace file (starting with Oracle 10g).

 

Logging

 

 

Allows logging to be turned on or off.

 

Backup

TblSpaceBackupBeg

Begin

Indicates to the server that you are going to backup the tablespace.

 

 

TblSpaceBackupEnd

End

Indicates to the server that the backup of the tablespace has been finished.

 

Change status

Enable

Online

Switches the tablespace online.

 

 

DISABLE

Offline normal

Switches the tablespace offline.

 

 

 

Offline temporary

Switches the tablespace temporarily offline.

 

 

 

Offline immediate

Switches the tablespace immediately offline.

 

Coalesce ...

 

 

Coalesces free space in the tablespace.

139_ShowDDL

Show DDL

 

 

Generates DDL for the selected object to a file.

 

Grid View

 

 

For more information, see object window