ＣＭ Oracle table space parameters
| Field name | Description | Default name / option | Record your value here |
|---|---|---|---|
| Frequently queried large objects | Table space holds tables for which updates, inserts, and deletes are very common. | ICMVFQ04 | |
| Moderately queried large objects | Table space holds large, persistant, frequently used tables, such as the item type tables. | ICMLFQ32 | |
| Rarely queried large objects | Table space holds large but infrequently used tables, such as event logs. | ICMLNF32 | |
| Frequently queried small objects | Table space holds small, frequently used but seldom updated tables. | ICMSFQ04 | |
| Table indexes | Table space holds library server indexes. | ICMLSNDX |
看看Linux上面这几个tablespace 对应的存储文件，
TABLESPACE FILE_NAME
———- ————————————————————
SYSTEM /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_SYSTEM_01.dbf
UNDOTBS1 /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_UNDOTBS1_01.dbf
SYSAUX /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_SYSAUX_01.dbf
ICMLFQ32 /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_ICMLFQ32_01.dbf
ICMLNF32 /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_ICMLNF32_01.dbf
ICMLSNDX /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_ICMLSNDX_01.dbf -LS index table
ICMLSTXT /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_ICMLSTXT_01.dbf – Oracle text search table
ICMSFQ04 /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_ICMSFQ04_01.dbf
ICMVFQ04 /u01/app/oracle/oradata/icmnlsdb/icmnlsdb_ICMVFQ04_01.dbf