Previous Topic: CSE Database Partitioned Across Multiple DrivesNext Topic: SQL Server


DDL Customization

If you have plenty of disks you can customize the DDL. The tables of greatest impact are DOBJ and DASC, the largest and most accessed, and DBSUBEX, which is heavily accessed during subset download. For a description of the results of customizing, see the table, Recommended Configuration for Optimal Disk Performance.

To create a system with this configuration, add the required tablespaces in the $IEFCSGEN/../cse_oracle/dbiefd.sql file. Then use sqlplus to create those tablespaces and run the cse_config using the initialize option instead of the create option.