Re: [Veritas-bu] FS mount parameter mincache and Netbackup

On all of our HP-UX servers 11iv1 and 11iv2 (11.11, 11.23) we use vxfs and use the following options for our Oracle DB filesystems:

delaylog,convosync=direct,mincache=direct,suid 0 0

The convosync=direct and mincache=direct are both important for insuring that the buffer cache is not used for these databases. The buffer cache actually decreases performance for Oracle DBs because they use their own caching algorithm within the SGA.

In short YES you should make the change they recommended as well as add the convosync option. We saw a fair performance increase on our databases when we did this a couple of years ago.

From: veritas-bu-bounces AT mailman.eng.auburn DOT edu [mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of net backup
Sent: Monday, August 20, 2007 5:16 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] FS mount parameter mincache and Netbackup

Hi All,

Due to some performance issues on an Oracle database, Oracle is recomending that we change the mount parameter MINCACHE from DSYNC to DIRECT. What if any impact would this have on Netbackup backing up flat files from that FS ? This is a HPUX 11i-23 server and in the past Veritas has recommended keeping this setting at DSYNC for backup performance but this is many years ago.

Any thoughts would be greatly appreciated , thanks

----------------------------------
CONFIDENTIALITY NOTICE: This e-mail may contain privileged or confidential information and is for the sole use of the 
intended recipient(s). If you are not the intended recipient, any disclosure, copying, distribution, or use of the 
contents of this information is prohibited and may be unlawful. If you have received this electronic transmission in 
error, please reply immediately to the sender that you have received the message in error, and delete it. Thank you.
----------------------------------

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu