Application Integration
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle on Windows

SOLVED
Go to solution
fgermana71
Occasional Visitor

Oracle on Windows

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

3 REPLIES
rbloemendal66
Occasional Visitor
Solution

Re: Oracle on Windows

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
Occasional Visitor

Re: Oracle on Windows

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
Occasional Visitor

Re: Oracle on Windows

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