topic Re: HP-UX 11i / Oracle 9.2 options for mount in Operating System - HP-UX

HP-UX 11i / Oracle 9.2 options for mount

claudio_22 — Mon, 13 Dec 2004 09:41:56 GMT

Hi,

I've read following for optmize Oracle on HP-UX :

===============================
Using Online JFS improves performance
Set these mount options

delaylog
nodatainlog
mincache=direct
convosync=direct

======================================

I've read man pages , anyway is not clear to me about advantages .

What exactly do these options and , above all , what could be cons ?

Thanks

Re: HP-UX 11i / Oracle 9.2 options for mount

Chris Xu — Mon, 13 Dec 2004 09:51:54 GMT

Here is a good discussion on that subject.

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=193104

In short, Oracle has its own memory management (SGA). Disabling buffer cache on Oracle data filesystems is a way to avoid double buffer the same data.

Chris

Re: HP-UX 11i / Oracle 9.2 options for mount

Chris Xu — Mon, 13 Dec 2004 09:58:33 GMT

Here is a more recent discussion on the subject:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=753721

Chris

Re: HP-UX 11i / Oracle 9.2 options for mount

Jean-Luc Oudart — Mon, 13 Dec 2004 10:51:24 GMT

Hi

you can check the attached document

Regards
Jean-Luc

Re: HP-UX 11i / Oracle 9.2 options for mount

Jean-Luc Oudart — Mon, 13 Dec 2004 10:57:56 GMT

Claudio,

I would also refer to the white papers indicated in this thread
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=712921

JFS tuning will give a better understanding for these parameters.

From my post (cf. 1st reply for you) last year, it does not seem that we'll get magic.

tuning the application / SQL should be the 1st step to improve the overall performance

Regards
Jean-Luc

Re: HP-UX 11i / Oracle 9.2 options for mount

Jean-Luc Oudart — Tue, 14 Dec 2004 07:12:51 GMT

Claudio,

You will be interested with (attached) the UX performance cookbook.

As a matter of fact, I'd be interested in performance results when you change these parameters.
You will have to record a performance baseline (OS & Oracle) before the changes, then new measures and compare.

Just let us know with your findings

Regards
Jean-Luc

Re: HP-UX 11i / Oracle 9.2 options for mount

claudio_22 — Tue, 14 Dec 2004 07:15:17 GMT

Thanks Jean ,

I've a lot of material to look now :-)