Oracle on Windows

[fgermana71]

I will be migrating an Oracle database to Nimble.  The Database is about 8 TB.  What is the recommended config?

Should I create 1 - 8 TB volume,4 - 2TB, 8 - 1TB.  No ASM.

Any recommendations would be great.

Thank you

[rbloemendal66 · Accepted solution]

Hi Fred,

Using more volumes is better due to the load balancing (MPIO) and the queue depth utilization. The more volumes the less queue depth per volumes.

Without any performance information I would opt to go for 8 volumes each 1TB.

Please make sure that you separate volumes for your logs, and use 4096 block size and turn OFF the caching.

For you other volumes please make sure you will use the same block size as you have defined with your db_block_size parameter in init.ora.

If you have any other questions, please do let us know

[fgermana71]

Follow up questions

If I create multiple volumes on the array attached them to the server and then create a dynamic mount and present it as one drive is that ok?

Thanks

[rbloemendal66]

Hi Fred,

I really would not do that. You have a NTS create file handler as well.

What you can do is create mountpoints, that will work.

Rob Bloemendal | Senior Systems Engineer

Mobile: +31 655 732 445