Tablespace management

The users can manage the logical and physical storage space of a database running in OwlDB. One tablespace can contain multiple data files. The users can view and modify tablespaces only when the database operation status is Running and the instance status is Normal.

Figure 1. Tablespaces

Viewing tablespaces

1. Navigate to the OwlDB Console screen > Administration > Tablespaces menu.

2. Click the DB Alias drop-down button to pull down the database whose tablespace the users want to view.

3. View the list of tablespaces.

• The users can filter by type and status, logging or not, and assignment type.

• The users can directly search for the name and the size of the next assigned Extent.

Item	Description
Name	Tablespace name
Type	Tablespace type - Permanent: Stores persistent data and is the most commonly used type. - Temporary: Stores temporary data and deletes data when the session ends or the task is completed. - Undo: Stores data that has been modified
Status	Tablespace Status - ONLINE : Normal connection to the database and available for use - OFFLINE: Disconnected from the database (objects stored in the tablespace are inaccessible)
Used/Total Size	The space used by data files belonging to this tablespace.
Total/Max Size	The size that data files belonging to this tablespace have been allocated.
Logging	Whether to log
Allocation Type	Extent allocation method - SYSTEM : Dynamically assigns the extent size according to system needs - UNIFORM: Stores objects using extents of the same size.
Next Extent	Next allocation Extent size

---

Creating tablespaces

1. Navigate to the OwlDB console screen > Administration > Tablespaces menu.

2. Click the DB Alias drop-down button to pull down the database for which the users want to create the tablespace.

3. Click the Create button

Note

Based on a data block size of 8 KB, even if the users set UNIFORM SIZE to less than 128 KB, it will be set to the minimum size of 128 KB for Extent.

---

Modifying tablespaces

1. Navigate to the OwlDB console screen > Administration > Tablespaces menu.

2. Click the DB Alias drop-down button to pull down the database whose tablespace the users want to modify.

3. Click the Edit button.

---

Deleting tablespaces

1. Navigate to the OwlDB console screen > Administration > Tablespaces menu.

2. Click the DB Alias drop-down button to pull down the database whose tablespace the users want to delete.

3. Click the Delete button.

---

Viewing data files

1. Refer to 'Viewing tablespaces' to pull down the database whose data files the users want to view.

2. Click the Tablespace radio button to pull down a tablespace to view data files.

3. View the list of data files.

• The users can filter the status and whether they are auto-expanded or not, and whether they are assigned or not.

• The users can search directly by tablespace name and data file name, next expansion capacity, physical read/write count, and single block read count.

Item	Description
Tablespace Name	Tablespace Name
Name	Data File Name
Status	Data File Status - UNUSED: Not yet used - ONLINE: Normal usage - OFFLINE: Disconnected - RESETLOG: Initializing the log file - RECOVERY : Recovery status
Used/Total Size	Current usage/current allocated capacity
Total/Max Size	Current allocated capacity/maximum allocated capacity
Auto Extend	Whether to extend automatically
Next	Next extended capacity
Physical Reads	Number of physical reads
Physical Writes	Number of physical writes
Single Block Reads	Number of single block reads.

---

Creating data files

1. Refer to "Viewing data files" and pull down the tablespace where the users want to create the data file.

2. Click the Create button.

---

Modifying data files

1. Refer to "Viewing data files" and pull down the tablespace where the users want to modify the data file.

2. Click the Edit button.

---

Deleting data files

1. Refer to "Viewing data files" and pull down the tablespace where the users want to modify the data file.

2. Click the Delete button.