| 1 |
Data partitioning must be very carefully designed to balance I/O and CPU
|
| 2 |
Parallel Loading is great ! --- almost linear speedup
|
| 3 |
Backup may be important to save time (we don't have)
|
| 4 |
The most difficult and trouble-making phase is the database preparation/loading/indexing phase which always involves storage management parameters
|
| 5 |
you must be both a DBA and sysadm and benchmarking relies critically on system stability
|
| 6 |
Be prepared to bring down the whole parallel system a couple of times a day
|
| 7 |
Be prepared that the results are negative (nothing may be obtained !)
|
| 8 |
you need at least twice the disk space of your original database size
|
| 9 |
performance tuning is extremely difficult with Oracle 7 parallel server
|
