Email Subscription Notifications Suspended Temporarily
We are in the process of making navigation in the Servers and Operating Systems forums simpler and more direct. While doing this, we have to temporarily suspend email notifications for subscriptions. If you are subscribed to one or more discussion boards or blogs in the community, please check them daily to see new content. Notifications will be turned back on in a few days. We apologize for any inconvenience this may cause. Thanks, Warren_Admin
EVA Storage
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 10g/11 on EVA5000

SOLVED
Go to solution
AlexanderT2
Occasional Contributor

Oracle 10g/11 on EVA5000

Hi all,

i hope this question belongs here.

I want to ask if anyone has experience with ORA datafiles on EVA5000,
and what would be the best settings for the DATAFILES to get the most performance out of the EVA.

i.e. Blocksize,Clustering etc

tips ,links and other infos are greatly appreciated

kind regards

Alex
3 REPLIES
Highlighted
Danny Petterson - DK
Trusted Contributor

Re: Oracle 10g/11 on EVA5000

Hi!

Hm - we have a lot of Oracle databases running on a lot of EVA's, and don't do that much special stuff.

Blocksize should be 8K, as Oracle also uses. You would like to get as close to raw performance as possible, which makes you want to use some kind of direct IO enabling, or something like that, if your OS/filesystem-type presents these possibilities.

/Danny
Mikko Niskanen_1
Frequent Advisor
Solution

Re: Oracle 10g/11 on EVA5000

See Oracle mount options white paper (updated Sep'2010):
http://h71019.www7.hp.com/ERC/downloads/4AA1-9839ENW.pdf

Few key snippets from the docu:

"With VxFS 5.0 on 11.31, the filesystem no longer needs to have a filesystem block size of 1 KB for efficient direct I/O."

"Beginning with VxFS 5.0.1or higher on HP-UX 11i v3, the concurrent I/O feature is available with the OnlineJFS licenses."

Also check your SCSI queue depth, default is 8, maximum 255.
AlexanderT2
Occasional Contributor

Re: Oracle 10g/11 on EVA5000

Thanks for the answer guys.

Sadly im damned to use Windows as an operating system..., and the only thing,i found,on direct I/O was for win NT4.0

maybe im lucky and someone else is damned to use windows as an DB Server enviorment :)

kd

Alex