Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When using a RAID device for tablespaces, what should I set the EXTENTSIZE of the tablespace to?

April 26, 2017device raid tablespace tablespaces

0

Posted

When using a RAID device for tablespaces, what should I set the EXTENTSIZE of the tablespace to?

1 Answer

0

Posted

It is recommended that you set the EXTENTSIZE to match the stripe set of the RAID device for efficient data retrieval. Further tuning may be required depending on benchmark tests run on your individual systems. Example:- If you have a RAID 5 (4+1) system with 128k strip size you could set your EXTENTSIZE at 64k and your PAGESIZE at 8k.