# Database Device Locations and Sizes

On the Database Device Locations and Sizes dialog box you must specify the pathnames and sizes to create the database tablespaces and datafiles. You can also add new datafiles to the ones that already exist. Type the pathname and click Add. To remove a datafile, you must select a datafile from the drop-down list and click Remove.

## Database storage

This table lists a rough starting value for the size of the Oracle Server tablespaces. Consider the requirements based on your system sizing for optimal performance.

Tablespace | Initial size | Description
--- | --- | ---
System | 5 GB | Stores information about all tables. The size depends on the number of companies
Temp | 10 GB | Space for tasks such as sorting.
Undo | 10 GB | Space for uncompleted transactions.
Redo | 6 files of 1 GB each | After a database crash, oracle can redo its transactions and bring the database data back to the state it was after the last redo record was created.
Data | See sizing, minimal 20 GB | Space for data and indexes. Store data and indexes in the same tablespace. Provide the same name for the tablespace on the dialog for the data and on the dialog for the indexes. Specify at least two different datafiles, for example: data01.dbf data02.dbf See your sizing report for specific information about the initial size.