Calculating Oracle Table Spaces

Previous Next

Once you have defined your application in the USoft Developer repository, and want to generate the corresponding tables in the Oracle RDBMS, you can have USoft Developer calculate the required table space. Based on this calculation, USoft Developer will implement an Oracle database with enough table space to prevent fragmentation, thereby optimizing performance.

If you have the application tables generated without having the required table space calculated first, USoft Developer will use Oracle defaults.

NOTE 1: Before you can have USoft Developer calculate the required table space, you must at least have defined the site at which the application database will be used. Read "Defining Sites" for more information.

NOTE 2: If you want to make NEW calculations for a particular site, manually delete the information from the Site Indexes and Site Tables tables.

See Also

How USoft Developer Calculates Table Space

How Inserts are Handled

How Updates are Handled