topic Re: Oracle on Windows in Application Integration

Oracle on Windows

fgermana71 — Mon, 07 Apr 2014 12:41:39 GMT

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 — Tue, 08 Apr 2014 08:04:50 GMT

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 — Tue, 08 Apr 2014 12:41:44 GMT

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 — Tue, 08 Apr 2014 12:48:20 GMT

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