Oracle Database Discussions

Hi everyone,

I understand that, as the documentation describes, table partitioning for the purpose of striping is a very good strategy for high performing OLTP databases. So you can explicitly assign partitions to different database-files, residing on different disks. A pretty clear benefit.

What about ASM controlled storage? Does it help partitioning your tables here, for the purpose of striping? Or is it even better to abandon the ASM option for the sake of reliable striping benefit?

Thanks in advance for any helpful thought or real life report...