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