About Estimating Database Size
Database upgrade is resource intensive. If the upgrade exceeds available resources, the upgrade halts. You must then resolve resource issues before resuming the upgrade.
To help you estimate the database size required when upgrading to the current Siebel CRM release, the following table shows the number of tables in 4-KB, 8-KB, 16-KB, and 32-KB table spaces in a sample Siebel Industry Applications database in a 7.8, 8.0 and 8.1 release. The following table also shows the space required by the tables.
Because Siebel CRM adopted a 1:1:1 database schema structure since Siebel CRM 7.7 (one table in each table space, one table space in each database), these releases require many more 16-KB and 32-KB table spaces than pre 7.7 releases. However, some tables might not require 16-KB and 32-KB table spaces if you convert LONG VARCHAR columns to CLOB columns.
Actual expected growth might also vary widely from these estimates, depending on which Siebel application you are using (Siebel Business Applications or Siebel Industry Applications), database configuration, row size of tables, data content, and code page. The number of tables and space estimates shown in the following table for Siebel CRM are for an EBCDIC database.
| Release | 4-KB Table Space | 8-KB Table Space | 16-KB Table Space | 32-KB Table Space |
|---|---|---|---|---|
8.1 |
4136 (5,194,752 KB) |
375 (828,416 KB) |
182 (71,680 KB) |
115 (134,144 KB) |
8.0 |
4229 (2,759,008 KB) |
331 (312,112 KB) |
171 (62,272 KB) |
105 (52,160 KB) |
7.8 |
3857 (569,442 KB) |
Not applicable |
459 (237,735 KB) |
86 (224,62 KB) |