We are running Oracle 10g RAC with ASM. Our allocation of SAN space is 400GB. This 400GB is logically divided via ASM into 8-50GB disks, of which four are DATA and four are FLASH. The 400GB is presented to Oracle and the OS logically as a simple block of space. However, physically, the space is cobbled together over 14+ disks and managed by the SAN software/hardware. The concept of partitioning a table over several tablespaces in this environment would not seem to provide any benefit. What is your opinion?
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.