Basic HTML version of Foils prepared 7 October 97

Foil 39 File Striping in Oracle

From Second Part of RDBMS Discussion ARL Database Tutorial -- February 98. by Gang Cheng Marek Podgorny Chao-Wei Ou
Automatic file striping and disk partitions by the operating system on nCUBE2
  • General OS and server level, less flexible, but relatively transparent to DBA
  • data skew is less possible, due to the Gigacache
Manually file striping at database table level on IBM SP2
  • Application-specific, flexible, but difficult to handle with large number of files and impossible to determine optimal striping length
  • data skew is highly possible

© on Mon Oct 13 1997