Oracle disk layout
When you run the Create_TS.oracle.sql script, which is provided for tablespace creation on your database, BMC recommends that you segregate the tablespaces on different disks, as shown in the following table.
Tablespaces for tables
Small | Large | Static |
|---|---|---|
BCM_DATA | BCM_EL | BCM_VMCKB |
BCM_VM | BCM_INV | BCM_ESIDKB |
BCM_WQ | BCM_DELTAINV | BCM_PATCH |
— | BCM_VMINV | — |
— | BCM_ESIDDATA | — |
— | BCM_SCAP | — |
Tablespaces for indexes
Small | Large | Static |
|---|---|---|
BCM_INDEX | BCM_ELINDEX | BCM_VMCKBINDEX |
BCM_VMINDEX | BCM_INVINDEX | BCM_ESIDKBINDEX |
BCM_WQINDEX | BCM_DELTAINDEX | BCM_PATCHINDEX |
— | BCM_VMINVINDEX | — |
— | BCM_ESIDDATAINDEX | — |
— | BCM_SCAPINDEX | — |
Recommended minimum disk layout
Disk | Rmp/s | File system | Purpose |
|---|---|---|---|
1 | 10 K / 15 K | ext3 | / SYSTEM - ORACLE |
1 | 10 K / 15 K | ext3 | / REDO LOG |
1 | 10 K / 15 K | ext3 | / TABLESPACES FOR TABLES |
1 | 10 K / 15 K | ext3 | / TABLESPACES FOR INDEXES |
1 | 10 K / 15 K | ext3 | / TEMPORARY TABLESPACES |
Recommended best disk layout
Disk | Rmp/s | File system | Purpose |
|---|---|---|---|
1 | 10 K / 15 K | ext3 | / SYSTEM - ORACLE |
2 | 10 K / 15 K | ext3 | / REDO LOG |
1 | 10 K / 15 K | ext3 | / TABLESPACES FOR SMALL TABLES |
1 | 10 K / 15 K | ext3 | / TABLESPACES FOR LARGE TABLES |
1 | 10 K / 15 K | ext3 | / TABLESPACES FOR STATIC TABLES |
1 | 10 K / 15 K | ext3 | / TABLESPACES FOR SMALL INDEXES |
1 | 10 K / 15 K | ext3 | / TABLESPACES FOR LARGE INDEXES |
1 | 10 K / 15 K | ext3 | / TABLESPACES FOR STATIC INDEXES |
1 | 10 K / 15 K | ext3 | / TEMPORARY TABLESPACES |
Recommended RAID implementation
Disk | Rmp/s | RAID level | File system | Purpose |
|---|---|---|---|---|
2 | 10 K / 15 K | 10 | ext3 | / SYSTEM |
8 | 10 K / 15 K | 10 | ext3 | / ORACLE + TABLESPACES |
2 | 10 K / 15 K | 10 | ext3 | / REDO LOG |
2 | 10 K / 15 K | 10 | ext3 | / TEMPORARY TABLESPACES |